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 and analysis to support decision making. To date, the team has launched and operationalized several global scale products and dashboards, enhancing how our leaders engage in information to manage the business.

　　The Data Engineer Manager role will be an integral part of an Agile team focused on delivering best in class business intelligence. Under the general supervision of senior management and the Data Integration 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 integration design ensuring that our 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 Integration chapter in proof-of-concept activities related to Data Ingestion and Integration.

　　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 supervision

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

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

　　Develop internal network with senior leaders within the chapter and key stakeholders in the product portfolio.

　　Develop strategies for data ingestion in Snowflake using FiveTran, Python, Snowpipes, AWS lambda and glue, Qlik Replicate

　　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

　　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

　　Leverages network effectively across functions, offices, regions and/or externally (existing network within BCG will be helpful)

　　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 and willingness to work on Agile methodology is a must.

　　Strong Organizational skills 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.

　　YOU BRING (EXPERIENCE & QUALIFICATIONS)

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

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

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

　　Essential: Experience in Fivetran, DBT and Qlik Replicate

　　Essential: Strong programming/ scripting skills in SQL and Python

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

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

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

　　Essential: Develop metrics that illuminate the flow of data across the organization

　　Essential: Experience in data modelling and relational database design

　　Preferred: Experience in AWS data platforms and integration offerings

　　Preferred: Knowledge of ETL tools: Talend

　　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 Product Engineering Group, you will work closely with a cross functional team that is collaborative, passionate and that holds themselves to a high standard. Your stakeholders are incredibly intelligent and analytical, make business decisions with a global lens.