15 days ago
Gurgaon, IndiaStaff+
Responsibilities
- Design, document, and build data pipelines and transformations feeding Snowflake data models.
- Own entity definitions, relationships, documentation, data models, data mapping, and source-system analysis.
- Develop automated tests and manual testing approaches to ensure data correctness and completeness.
- Translate functional requirements into build specifications and own solution design and technical architecture.
- Serve as the day-to-day technical leader for the data engineering team and review team members’ work.
- Drive technical planning, delivery, measurement, operations, and support for delivered data assets.
- Partner with product owners, functional teams, enterprise data platform, architecture, infrastructure, and security teams.
Requirements
- Bachelor’s degree or an equivalent combination of education and experience; a degree in information science, data management, computer science, or a related field is preferred.
- At least 5 years of IT or engineering experience focused on data warehousing, analytics, or data engineering.
- Required hands-on experience developing with dbt.
- Required hands-on experience with Snowflake or another modern analytical data warehouse.
- Experience designing and building SCDs, CDC pipelines, and DQ/DV frameworks.
- Experience designing data models for analytical and operational workloads, including dimensional modeling and data vault concepts.
- Advanced SQL and SQL database design experience.
- Familiarity with Python, especially PySpark, AWS Glue, AWS cloud, Jira, and Confluence.
- Experience working with cross-functional teams using Scrum methodologies.
- Strong written, oral communication, presentation, analytical, and technical specification skills.
- Experience designing processes that promote engineering excellence and efficiency and an interest in AI-assisted engineering practices.
Benefits
- BCG provides a collaborative environment focused on connection, mentorship, teamwork, and professional development.
- The role generally requires working from a BCG office or in person with clients around 50% of working time, depending on business needs and local policies.
- BCG is an Equal Opportunity Employer and an E-Verify employer.
About BCG
Boston Consulting Group provides management consulting, technology, and design services to large enterprises, governments, and nonprofits, helping with strategy, digital transformation, and operations. The firm works on a project-based, fee-for-service model and also incubates products and ventures through BCG X. Founded in 1963 and headquartered in Boston, it is a global partnership with offices worldwide.