# Data Consultant

**Company**: WSP
**Location**: Noida, Uttar Pradesh, Uttar Pradesh
**Experience**: senior
**Job type**: full-time
**Category**: Data Science
**Industry**: Consulting

**Apply**: https://emit.fa.ca3.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_2001/job/95171?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply
**Canonical**: https://yubhub.co/jobs/job_5d4b4aee-5e9

## Description

We are looking for a skilled Data Consultant with 3-5 years of experience in building and developing enterprise-grade applications.

You will work within the Digital Solutions team to build scalable, secure, and high-performing business applications used across major global infrastructure and environmental projects.

This is an exciting opportunity to support the ongoing development of digital solutions for our clients, unlocking solutions to the world's most critical challenges.

**Responsibilities**

- Design, develop, and maintain scalable data pipelines and analytical solutions using SQL Server and Python, ensuring data quality, performance optimization, automation, and operational efficiency.

- Integrate, extract, transform, and model data from diverse sources including SQL databases, SharePoint, APIs, ArcGIS, and Python-based data services to support enterprise ETL and analytics requirements.

- Develop and deliver robust reporting and data solutions by collaborating with business stakeholders and technical teams, translating complex requirements into actionable insights and scalable data products.

- Build and support automated data ingestion, transformation, and incremental loading processes, while monitoring and maintaining data pipelines to ensure reliability, accuracy, and availability of business-critical reporting.

- Apply data governance and best practices, including data security, role-based access control, version control, deployment pipelines, and lifecycle management across analytical platforms.

- Leverage Python and AI-powered capabilities to automate repetitive tasks, enhance data processing workflows, and support the development of foundational Generative AI and AI Agent solutions.

- Create and maintain comprehensive technical documentation to support governance, maintenance, and knowledge sharing.

- Collaborate with cross-functional teams to identify opportunities for process improvement through data engineering, automation, machine learning, and emerging AI technologies.

**Required Essential Skills and Expertise**

- 3-5 years of hands-on experience in Python and SQL, with strong expertise in data modeling, query optimization, and developing scalable data solutions.

- Proficient in Python-based data engineering, automation, and analytical workflows.

- Strong expertise in SQL Server database design, relational data modeling, schema architecture, query optimization, and efficient management of large-scale datasets.

- Experienced in building AI-enabled and Generative AI solutions.

- Advanced knowledge of SQL development, including complex queries, joins, stored procedures, indexing strategies, and performance optimization techniques.

- Skilled in integrating data from multiple enterprise and external sources.

- Strong understanding of RESTful services, JSON, OData queries, and API-driven architectures.

- Experience developing AI-powered analytical solutions that combine Python, SQL, and machine learning techniques.

- Proficient in designing and implementing scalable data pipelines, ETL/ELT processes, and automated workflows using Python and SQL technologies.

- Strong problem-solving and debugging skills.

- Experience with GitHub, Azure DevOps, and modern software development practices.

- Good understanding of Power BI integration with Python, SQL Server, APIs, Power Apps, Power Automate, and Dataverse.

- Knowledge of enterprise data governance, security, deployment pipelines, row-level security (RLS), workspace management, and data refresh strategies.

- Ability to leverage Generative AI, Python, and SQL to automate business processes and develop innovative data-driven solutions.

- Skilled in extracting, transforming, modeling, and analyzing complex datasets using Python, SQL Server, and AI technologies.

**Qualifications**

- Bachelor's or Master's degree in computer science, Information Technology or related field (or equivalent experience).

- At least 5+ years of experience in Microsoft Power BI Platform Technology.

## Skills

### Required
- Python
- SQL
- data modeling
- query optimization
- scalable data solutions
- data engineering
- automation
- analytical workflows
- SQL Server database design
- relational data modeling
- schema architecture
- AI-enabled solutions
- Generative AI solutions
- RESTful services
- JSON
- OData queries
- API-driven architectures
- machine learning
- GitHub
- Azure DevOps
- Power BI
- Dataverse

---

Source: [Apply at emit.fa.ca3.oraclecloud.com](https://emit.fa.ca3.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_2001/job/95171?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply)