Join BCG's Data Team as a Graduate Trainee- Data Engineer and be part of transforming the company into a bionic organization. You will design and implement data pipelines, CICD, and Data Operations for global stakeholders, ensuring optimal solutions for different business domains. Ideal candidates have experience in data warehousing, data modeling, ETL/ELT techniques, and strong analytical abilities.
WHAT YOU'LL DO
Be part of a team that is transforming BCG into a bionic company! BCG Data Team plays a crucial role in the smooth operations of BCG globally. Their responsibility includes developing and managing BCG's internal data platform, which is a collaborative effort of members from different locations like Boston, London, Munich, and New Delhi. The team sets the standards and guidelines for BCG's internal data architecture, data pipeline, governance, integration, and security framework. By providing a centralized data platform, the team enables advanced operational insights and analytics for BCG stakeholders. BCG is currently seeking a driven, passionate, and curious Data Engineer to join the team to continue meeting the evolving IT needs of the company. The selected candidate will work with cross-functional teams to design and implement code pipelines, CICD, and Data Operations for BCG.
The Graduate Trainee- Data Engineer works as an integral part of an Agile team delivering scalable digital data solutions for global stakeholders. This role will help design optimal solutions to support and operate the data products across different business domains like Finance, Worker, Supplier etc.—employing best practices for data modeling, scalable Extract-Load-Transform jobs, and data pipelines for consumption of downstream systems.
YOU'RE GOOD AT
You have experience in data warehousing, data modeling, and the building of data engineering pipelines. You are well versed in data engineering methods, such as ETL and ELT techniques through scripting and/or tooling. You are good in analyzing 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.
- Strong analytical abilities and creative problem-solving
- Ability to work independently with general direction and flexibility in a fast-paced environment.
- Good organization and excellent communication skills across cultures
- Flexibility to multi-task on different projects in a fast-paced organization
- Comfort with ambiguity and willingness to embrace an iterative process.
- Ability to frame issues at conceptual level and collaborate to resolve them.
- Integrity and a positive attitude, especially while handling stressful situations.
- Work with project stakeholders (technical as well as end users) to understand business requirements and implement database solutions for diverse problems.
- Research viable technical and/or non-technical solutions, evaluate new technology, and advocate, influence, and build consensus for innovations that satisfy business needs.
- This position will involve close collaboration with an Agile team to build, operate, and maintain data pipelines and conformed data dimensions for Finance-focused data assets. The successful candidate will demonstrate.
YOU BRING (EXPERIENCE & QUALIFICATIONS)
- BS/BA degree, preferably in computer science or related field; or business administration or mathematics.
- Good understanding of database and data warehousing concepts.
- Strong background in SQL (e.g. SQL Server and/or Oracle, including T-SQL and/or PL/SQL), MV’s, and analytic functions.
- Familiarity with cloud data warehouse platforms such as Snowflake, developing data pipelines in DBT (Data Build Tool); or other development tools, languages, and frameworks is a plus.
- Proficiency with industry-standard ELT tools is a plus, such as ODI, Talend or others is a plus.
- Hands-on implementation experience with Data Warehousing including design, modeling, testing, security, administration, and optimization.
- Understanding of Agile methodology and tools like confluence and JIRA would be a plus.
- Good to have strong programming/ scripting skills (Python, PowerShell, etc.) and orchestration of data pipelines like Airflow, Control-M, Autosys etc.