Global IT Data Engineer Senior Manager

Boston Consulting Group (BCG); Gurugram District; Hybrid; INR 1,800,000 - 2,800,000; Full time

Job summary

Boston Consulting Group seeks a Data Engineer to design, implement, and maintain data pipelines feeding Snowflake data models. You will own the data model, translate requirements into build specs, and lead technical direction for the data engineering team.

The role requires 5+ years in data warehousing/engineering, hands-on dbt and Snowflake experience, and strong SQL/data modeling skills. Hybrid office presence in India with client engagements may be required.

Qualifications

• Bachelor’s degree in information science, data management, computer science, or related fields preferred.
• 5+ years IT/engineering experience with data warehousing, analytics, or data engineering.
• Hands-on experience developing with dbt is required.
• Hands-on experience with Snowflake or other modern analytical data warehouses is required.
• Experience designing and building SCDs, CDC pipelines, and DQ/DV frameworks.

Responsibilities

• Design, document, and build the data pipelines and transformations to feed data models in Snowflake.
• Own and maintain the overall data model: entity definitions, relationships, and documentation.
• Develop automated tests and manual testing approaches to ensure correctness and completeness of the data.
• Be accountable for data mapping and source system analysis (supported by data analysts).
• Be accountable for translating functional requirements into build specifications.
• Be accountable for solution design and technical architecture.
• Be the day-to-day technical leader for the data engineering team.
• Review work from other team members to ensure quality standards are met and provide feedback for growth.
• Help drive technical planning, delivery, measurement, operations, and support for the assets the team delivers and maintains.

Skills

dbt

Snowflake

SQL

Python

ETL pipelines

Data warehousing

Data modeling

Education

Bachelor’s degree in CS/IS/CA

Tools

Snowflake

dbt

AWS Glue

Jira

Confluence

Job description

Who We Are

Boston Consulting Group partners with leaders in business and society to tackle their most important challenges and capture their greatest opportunities. BCG was the pioneer in business strategy when it was founded in 1963. Today, we help clients with total transformation-inspiring complex change, enabling organizations to grow, building competitive advantage, and driving bottom-line impact.

To succeed, organizations must blend digital and human capabilities. Our diverse, global teams bring deep industry and functional expertise and a range of perspectives to spark change. BCG delivers solutions through leading-edge management consulting along with technology and design, corporate and digital ventures—and business purpose. We work in a uniquely collaborative model across the firm and throughout all levels of the client organization, generating results that allow our clients to thrive.

What You'll Do

• Design, document, and build the data pipelines and transformations to feed data models in Snowflake.
• Own and maintain the overall data model: entity definitions, relationships, and documentation.
• Develop automated tests and manual testing approaches to ensure correctness and completeness of the data.
• Be accountable for data mapping and source system analysis (supported by data analysts).
• Be accountable for translating functional requirements into build specifications.
• Be accountable for solution design and technical architecture.
• Be the day-to-day technical leader for the data engineering team.
• Review work from other team members to ensure quality standards are met and provide feedback for growth.
• Help drive technical planning, delivery, measurement, operations, and support for the assets the team delivers and maintains.

What You'll Bring

• Bachelor’s degree or equivalent combination of education and experience. Bachelor’s degree in information science, data management, computer science, or related fields preferred.
• 5+ years of IT/engineering experience with a major focus on data warehousing, analytics, or data engineering.
• Hands-on experience developing with dbt is required.
• Hands-on experience with Snowflake or other modern analytical data warehouses is required.
• Experience designing and building SCDs, CDC pipelines, and DQ/DV frameworks.
• Experience designing and building data models for analytical and operational workloads and familiarity with concepts like dimensional modeling and data vault.
• Experience working with agile methodologies (Scrum) with cross-functional teams.
• Excellent written and oral communication and presentation skills to present architecture, features, and solution recommendations.

Who You'll Work With

• Functional product portfolio technical leaders, product owners, and functional area teams working across software development, SaaS, AI, and data.
• Enterprise data platform, enterprise architecture, infrastructure, and security teams.

Additional info

• You have extensive experience in data warehousing, data modeling, and building and maintaining data pipelines. You are well-versed in modern data tooling like dbt, Fivetran, Snowflake, and AWS Glue. You have a strong ability to transform functional requirements and the outputs of business analysis into technical specifications and build requirements. You enjoy ensuring that each new thing that is implemented builds the platform’s overall capabilities and reusability.
• Strong analytical skills related to working with structured, semi-structured, and unstructured datasets.
• Ability to partner with product owners to identify requirements, define desired outcomes, and deliver trusted, valuable results.
• Experience designing and building processes to promote engineering excellence and efficiency.
• Demonstrably deep understanding of SQL (advanced level) and analytical data warehouses (Snowflake is preferred).
• Hands-on experience with SQL database design, developing with dbt, and familiarity with Python (especially pyspark), AWS Glue, and AWS cloud.
• Familiarity with Jira and Confluence.
• Eagerness to continually keep up with advancements in data engineering and AI-assisted engineering practices.

At BCG, our people and relationships are at the heart of everything we do. We believe that in-person collaboration plays an important role in our culture, mentorship, and professional development.

For this role, you will generally be expected to work from a BCG office or in person with clients on a regular basis (typically around 50% of working time), depending on business needs and in line with local policies and practices.

We aim to provide a dynamic and collaborative environment that fosters connection and teamwork.

Boston Consulting Group is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, age, religion, sex, sexual orientation, gender identity / expression, national origin, disability, protected veteran status, or any other characteristic protected under national, provincial, or local law, where applicable, and those with criminal histories will be considered in a manner consistent with applicable state and local laws.

BCG is an E - Verify Employer.