Global IT Data Engineer Senior Manager
Key Skills for This Role
Full Job Posting
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'RE GOOD AT
- 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. Click here for more information on E-Verify.
Preferred Qualifications
- Bachelor’s degree in information science, data management, computer science, or related fields preferred.
- Ability to partner with product owners to identify requirements, define desired outcomes, and deliver trusted, valuable results.
- Demonstrably deep understanding of SQL (advanced level) and analytical data warehouses (Snowflake is preferred).
About Boston Consulting Group
BCG is a global consulting firm that partners with leaders in business and society to tackle their most important challenges. Learn more about BCG.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Boston Consulting Group
Commercial Development Senior Manager - Public Sector
London, GBR
Manager - BCG Vantage - Tech Capital in Principal Investors & Private Equity
Boston, USA
LAB Executive Placement & Career Services Senior Manager
London, GBR
Senior Associate, Experienced, Doha
, QAT
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 fo
Senior Associate, Experienced, UAE
, UAE
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 fo
London A-C Performance Partner Manager
London, GBR
Inverto | Business & Operations Senior Manager
Riyadh, KSA
Commercial Development Senior Manager - Public Sector
London, GBR
Manager - BCG Vantage - Tech Capital in Principal Investors & Private Equity
Boston, USA
LAB Executive Placement & Career Services Senior Manager
London, GBR
Manager-BCG Vantage, Risk & Compliance
Houston, USA
Senior Associate, Experienced, Doha
, QAT
Senior Associate, Experienced, UAE
, UAE
