Business Intelligence Consultant - Data Engineering [T500-29748]

CIBC India; Hyderabad; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

CIBC India is seeking a senior Data Engineering Consultant to design, build, and modernize data pipelines and ETL processes. The role focuses on data migration to cloud platforms such as Azure Databricks and ensuring robust, scalable data warehousing solutions for analytics.

You will collaborate with business and technology stakeholders to translate requirements into engineering solutions, maintain data quality, and contribute to SDLC activities in a dynamic, global team.

Qualifications

• 7+ years of experience in data engineering, ETL development, or related data-focused technology roles.
• Strong hands-on proficiency in SQL, Python, and PySpark.
• Strong understanding of data warehousing concepts and ETL processes.

Responsibilities

• Deliver scalable data engineering solutions for analytics and reporting.
• Build and maintain batch and distributed data pipelines using SQL, Python, and PySpark.
• Design and implement ETL workflows for efficient data ingestion, transformation, and movement.
• Migrate data from legacy platforms to Azure Databricks and modern cloud environments.
• Ensure data integrity, quality, and governance across datasets and pipelines.

Skills

SQL

Python

PySpark

Tools

Azure Databricks

Job description

CIBC is a leading North American bank, with a history of more than 150 years of living our purpose - to help make your ambition a reality. Client relationships are at the center of our strategy, and our growth is enabled by a highly engaged and connected global team. From digital banking to community impact, we’re proud to drive progress for our clients and our communities. Recognized for our culture, award-winning innovation and community investment, CIBC continues to evolve by putting people and progress at the centre of everything we do.

About CIBC India:

CIBC India is a technology and operations hub in Hyderabad, where you’ll be part of our highly engaged and global team, and play a central role in supporting our growth. Whether you’re driving innovation in digital banking or streamlining client onboarding, you’ll be part of a culture recognized for excellence and investment in people. At CIBC India, people and progress are at the center of what we do: you’ll develop skills, collaborate with industry leaders, and see your ideas realized in a culture that values progress and belonging. We provide cutting-edge resources, ongoing learning, and a supportive environment where people come first. If you’re ready to create meaningful change and build your future, CIBC India is where your ambition meets opportunity.

What CIBC India Offers:

At CIBC India, your goals are a priority. We start with your strengths and ambitions and strive to create opportunities to tap into your potential. We aspire to give you a career that goes well beyond your compensation.

We work to recognize you in meaningful, personalized ways including competitive fixed pay, performance-based incentive programs, a family-first benefits program, employer contributions for your retirement, attractive time off and leave offerings, wellbeing support, and MomentMakers, our social, points-based recognition program.

Our spaces and technological toolkit will make it simple to bring together great minds to create innovative solutions that make a difference for our clients worldwide

We cultivate a culture where you can express your ambition through initiatives like Purpose Day, a paid day off dedicated for you to use to invest in your growth and development.

What You’ll Be Doing (Position Summary):

As a Data Engineering Consultant, you will play a key role in designing, building, and modernizing data engineering solutions at CIBC. This role sits within the data engineering function and is focused on ETL development, pipeline engineering, data migration, and cloud based data platform enablement.

You will work closely with business and technology stakeholders to understand data requirements, translate them into scalable engineering solutions, and support the migration of legacy data assets into modern cloud environments such as Azure Databricks.

The primary focus of this role is on data engineering, ETL processes, pipeline development, and data warehousing, including building robust and scalable data pipelines using SQL, Python, and PySpark.

At CIBC India we enable the work environment most optimal for you to thrive in your role. Details on your work arrangement (including on-site and remote work) will be discussed at the time of your interview.

How You’ll Succeed:

• Deliver scalable and reliable data engineering solutions to support analytics, reporting, and downstream data consumption.
• Build, enhance, and maintain batch and/or distributed data pipelines using SQL, Python, and PySpark.
• Design and implement ETL workflows that ensure efficient ingestion, transformation, and movement of data across systems.
• Develop reusable and optimized pipeline components aligned with engineering best practices.
• Support migration of data from legacy platforms to Azure Databricks and modern cloud based environments.
• Analyze legacy data flows, transformation logic, and source-to-target mappings to enable smooth modernization.
• Rebuild and optimize legacy ETL processes using modern engineering frameworks and tools.
• Ensure data integrity, completeness, and consistency during migration activities.
• Apply strong understanding of data warehousing concepts to support curated, structured, and analytics-ready data layers.
• Perform data analysis, profiling, reconciliation, and validation to ensure quality and accuracy of delivered datasets.
• Follow established SDLC processes and contribute to development, testing, deployment, and support activities.
• Ensure solutions align with data governance, control, and quality standards.
• Document technical design, transformation logic, mappings, and operational processes as needed.
• Work with business, analytics, and technology teams to understand requirements and deliver effective data solutions.
• Communicate technical concepts, delivery status, and issues clearly with stakeholders.
• Identify opportunities to automate repetitive engineering tasks and streamline data workflows.
• Recommend improvements in ETL design, code efficiency, data quality, and operational support.
• Stay current with modern data engineering practices, cloud data platforms, and Databricks capabilities.

Who You Are:

• 7+ years of experience in data engineering, ETL development, or related data-focused technology roles
• Strong hands-on proficiency in SQL, Python, and PySpark
• Strong experience in building and maintaining data pipelines
• Solid understanding of ETL and data engineering concepts
• Strong understanding of data warehousing concepts
• Proven experience in migrating data from legacy platforms to Databricks
• Experience working with Azure Databricks
• Strong analytical, problem-solving, and data analysis skills
• Good understanding of SDLC processes
• Strong communication and collaboration skills
• Ability to work closely with stakeholders and translate requirements into engineering solutions

Preferred Candidate Profile:

• SQL/Python/PySpark-based engineering solutions
• Data warehousing and transformation workflows
• Data analysis and validation

Job Dimensions:

• Individual contributor role focused on delivering business reporting and analytics solutions that support business unit goals High interaction with business stakeholders and reporting consumers Strong emphasis on reporting outcomes, dashboard usability, data quality, and insight generation

Compliance Requirements:

• Comply with all applicable CIBC and Line of Business policies, standards, guidelines, and controls

Privacy:

By proceeding with the creation of a profile and submitting an application in response to this job posting, you acknowledge and agree that your personal data will be collected, used, retained and disclosed by CIBC India and its affiliates, as described in the Candidate Privacy Statement.