IT Senior Manager - Data Engineer

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

Be part of a team that is transforming BCGs Data Landscape! We are building a centralized Data Lake that will simplify and automate information delivery— further providing advanced insights analytics and AI to support decision making. To date, the team has launched and operationalized several global scale data products, enhancing how our leaders engage in information to manage the business.

The Senior Manager - Data Engineer role will be an integral part of an Agile team focused on delivering best in class data engineering practices. Under the general supervision of senior management and the Data Ingestion & Analyst Chapter Lead in the Enterprise Data Product Portfolio, you will be working with key customers to deliver timely and accurate data ingestion pipelines in a secure manner. You are expected to provide guidance on proper data ingestion and integration design, ensuring that our enterprise architectural guidelines are met, and the appropriate support model is in place for production deployments. This role will work in a multi-functional agile squad and support the product owner. You will also be supporting the Chapter Lead and other team members of the Data Ingestion chapter in people management and proof-of-concept activities related to Data Ingestion and Integration.

What You'll Bring

Minimum of a Bachelor's degree in Computer science, Engineering or a similar field

• 7-9+ years of Data Ingestion, Integration and ETL relevant experience.

• Essential: Experience in loading data into warehouse/ ODS environment from diverse sources and formats

• Essential: Experience in AWS Glue, DBT and Fivetran

• Essential: Strong programming/ scripting skills in Python and SQL

• Essential: Experience working with APIs, Semi-Structured and Unstructured datasets.

• Essential: Lead R&D efforts to find solutions for data integration requirements not addressed by existing technology standards

• Essential: Develop metrics that showcase the flow of data across the organization

• Essential: Experience in data modelling and relational database design

• Essential: Experience in data platforms: Snowflake, Oracle, SQL Server, PostgreSQL, and MySQL

• Essential: Design strategies for new data ingestion requests, including logical and physical data modelling

• Preferred: Experience in AWS data platforms and integration offerings

Who You'll Work With

As part of the Enterprise Data Product Portfolio, we seek people with strong drive, relentless curiosity, desire to create their own path, ability to work collaboratively, and the passion and leadership to make an impact. You’ll collaborate on challenging projects with team members from many backgrounds and disciplines, increasing your understanding of complex business problems from diverse perspectives and developing new skills and experience to help you at every stage of your career. You’ll be able to experience business on a genuinely global scale and learn how to bring together people from different cultures to uncover insights that challenge the status quo. As a member of the IT Data Product Engineering Group, you will work closely with a cross functional teams. Your stakeholders are incredibly intelligent and analytical, make business decisions with a global lens.

Additional info

YOU’RE GOOD AT

You have experience in data warehousing, data modelling, and the building of data integration pipelines. You are well versed in data ingestion methods, such as extract and load techniques through scripting and/or tooling, streaming, API consumption and replication. You are good in analysing performance bottlenecks and providing enhancement recommendations; you have a passion for customer service and a desire to learn and grow as a professional and a technologist.

Viewed as subject matter expert for stakeholders, possessing in-depth knowledge and specialized technical skill set

• Able to work independently with minimal to no supervision.

• Proactively identify and independently solve non-routine problems by applying expertise.

• Perform research of viable technical and/or non-technical solutions

• Develop strategies for data ingestion (from multiple sources) into Snowflake using FiveTran, AWS Glue, Python, Snowpipes, snowtasks etc.

• Design and implement data pipelines to feed data models for subsequent consumption.

• Actively monitor and resolve user support issues, working closely with your functional squad and other squads as part of the chapter.

• Develop and maintain architectural standards, best practices, and measure compliance

• ETL and datawarehousing concepts

Communication, interpersonal and teaming skills

• Works positively and collaboratively with others and within team; builds strong and lasting relationships.

• Working and partnering with remote team members in different time zones

• Adapts style to changing situations and audiences with tact, poise, and patience. Demonstrates persistence to drive change. Contributes to a positive and productive work environment.

• Experience on data visualization and / or ability to present data analytics in an insightful manner for the leadership will be an added plus

Work Management, organization, and planning.

• Must be able to perform successfully in a fast-paced, intellectually intense, service-oriented environment.

• Familiarity on Agile methodology is a must.

• Strong organizational, people, and process management skills

• Ability to contribute to multiple work streams at once and prioritize efforts accordingly.

• Demonstrated ability to drive projects to scheduled conclusion

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.