Senior Consultant

CBIZ; Pune District; On-site; INR 2,500,000 - 3,500,000; Full time

Job summary

CBIZ in India is seeking an experienced Data Engineer to design, build, and maintain scalable data pipelines, warehouses, and curated data models that support enterprise reporting, analytics, and BI solutions. You will partner with architects, BI developers, analysts, and data governance teams to translate business requirements into reliable technical solutions.

You will own complex SQL, ETL/ELT processes, troubleshoot data quality and performance in production, and contribute to CI/CD practices

Qualifications

• Bachelor's degree or equivalent required; CS/IS/Data Engineering preferred.
• 7+ years of data engineering, warehousing, analytics engineering, or similar.
• Experience designing and operating reliable data pipelines and analytical data structures in production.
• Strong SQL, data integration patterns, cloud analytics platforms.
• Experience with Power BI semantic models, data modeling for BI consumption, Microsoft Purview, Python, PySpark, APIs.

Responsibilities

• Design, build, and maintain scalable data pipelines, data warehouses, Lakehouses, and curated data models.
• Develop, optimize, and troubleshoot SQL, ETL/ELT processes for accuracy, performance, and reliability.
• Partner with architects, BI developers, analysts, governance teams, and stakeholders to translate requirements into reliable solutions.
• Perform root cause analysis and resolve data quality, refresh, performance, integration, and production issues.
• Design data validation, reconciliation, monitoring, and exception handling to improve trust in data assets.
• Contribute to engineering standards for SQL development, source control, deployment, documentation, testing, and support.
• Participate in code reviews, release planning, CI/CD, and agile delivery.
• Document data flows, transformation logic, dependencies, and operational procedures.
• Collaborate with global teams across India and US time zones with overlap as needed.
• Mentor and support team members, sharing knowledge and promoting best practices.

Skills

SQL & Databases

Data Warehousing

ETL/ELT Design

Python / PySpark

Azure Data Platform

Power BI Modeling

Data Governance

Cloud Data Platforms

Team Collaboration

Mentoring

Education

Bachelor's degree in CS/IS/Data Eng

Tools

Microsoft SQL Server

Azure SQL

SSIS

Azure Data Factory

Azure Synapse

Databricks

Microsoft Fabric

Power BI

Job description

• Design, build, and maintain scalable data pipelines, data warehouses, Lakehouse’s, and curated data models that support enterprise reporting, analytics, and business intelligence solutions.
• Develop, optimize, and troubleshoot complex SQL, ETL, and ELT processes to ensure data accuracy, performance, reliability, and repeatability across production data environments.
• Partner with architects, BI developers, analysts, data governance teams, and business stakeholders to translate business requirements into reliable, well-documented technical solutions.
• Perform root cause analysis and resolve complex data quality, refresh, performance, integration, and production support issues.
• Design and implement data validation, reconciliation, monitoring, and exception-handling processes to improve trust in enterprise data assets.
• Contribute to engineering standards for SQL development, source control, deployment, documentation, testing, and ongoing support.
• Participate in code reviews, release planning, testing, production deployments, and CI/CD practices within an agile delivery environment.
• Document data flows, transformation logic, technical design decisions, dependencies, and operational support procedures.
• Collaborate effectively with global teams across India and U.S. time zones, including maintaining reasonable overlap with U.S.-based stakeholders as business needs require.
• Mentor and support other team members by sharing technical knowledge, promoting best practices, and helping strengthen overall data engineering capabilities.

Skills & Qualifications

• Bachelor’s degree or equivalent experience required, degree in Computer Science, Information Systems, Data Engineering, Engineering, Mathematics, or a related field preferred.
• Minimum of 7 years of related experience in data engineering, database development, data warehousing, analytics engineering, or a similar technical role.
• Demonstrated ability to design, build, support, and optimize reliable data pipelines and analytical data structures in a production environment.
• Strong technical knowledge of SQL, relational databases, data integration patterns, cloud data platforms, and enterprise analytics environments.
• Experience with Power BI semantic models, data modeling for BI consumption, Microsoft Purview, Python, PySpark, APIs, or automation frameworks.
• Ability to formulate, document, and recommend technical standards, procedures, and improvements that support scalable and governed data delivery.
• Demonstrated ability to communicate verbally and in writing throughout all levels of an organization, both internally and externally.
• Ability to work independently in an India-based role while collaborating with U.S.-based stakeholders and distributed project teams.
• Ability to support business-critical production processes, participate in issue resolution, and provide on-call or after-hours support as required by business needs.
• Ability to travel as required by business needs.
• Experience with Microsoft SQL Server, Azure SQL, SSIS, Azure Data Factory, Azure Synapse, Microsoft Fabric, Databricks, or similar cloud data platforms.
• Strong understanding of data warehousing concepts, dimensional modeling, star schemas, slowly changing dimensions, data marts, and curated analytical data layers.

Preferred Qualifications

• Advanced SQL development experience, including query optimization, stored procedures, views, indexing strategies, performance tuning, and troubleshooting.
• Demonstrated experience with ETL/ELT pipeline design, data integration, data transformation, data validation, and production support.
• Experience working with source control, Azure DevOps or similar work management tools, CI/CD processes, deployment pipelines, and structured release practices.
• Experience supporting data governance, data quality, metadata, lineage, access control, or enterprise reporting standards.
• Ability to troubleshoot complex data issues independently and communicate findings, risks, and recommendations clearly to both technical and non-technical audiences.
• Strong written and verbal English communication skills, with the ability to collaborate effectively across global and cross-functional teams.
• Experience in professional services, finance, accounting, advisory, insurance, benefits, technology, or another regulated business environment is a plus.