IT Data Integration Platform Lead Engineer II

WHAT YOU'LL DO Under the general supervision of local senior management and the Platform Engineer Chapter Lead in the Enterprise Platform Tribe, you will be working with key customers to deliver timely and accurate data in a secure manner. You are expected to provide guidance on proper integration design, ensure that our architectural guidelines are met, and the appropriate support model is in place for production deployments. 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 streaming, API consumption, replication, as well as extract and load techniques through scripting and/or tooling. You are good analysing performance bottlenecks and providing enhancement recommendations; you have a passion for customer service and a desire 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 own chapter and key stakeholders * Develop strategies for data integration in the Cloud (AWS/Azure) * Architect, design, and implement data pipelines to feed data models for subsequent consumption * Perform system analysis on data integrations, resolve performance, stability, and/or data quality issues * Develop and maintain architectural standards, best practices, and measure compliance YOU BRING (EXPERIENCE & QUALIFICATIONS) You bring to us experience in data model design, database development, and data integration technologies; both in IaaS and PaaS Cloud (AWS and/or Azure) environments. * Essential: Experience in loading data into warehouse/ ODS environment from diverse sources and formats * Essential: Experience in Oracle GoldenGate, Qlik Replicate, and/or Fivetran replication * Essential: Design strategies for new data integration 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: Ensure data quality and enforce SSOT policies * Essential: Experience in data modelling and relational database design * Essential: Experience in AWS and Azure data platforms and integration offerings * Preferred: Experience in MuleSoft API development * Preferred: Knowledge of ETL tools: dbt, Talend, Oracle Data Integrator * Preferred: Strong programming/ scripting skills (SQL, Python, Powershell, etc.) YOU'LL WORK WITH As part of the Enterprise Platforms Tribe, you don't have to fit into a mould at BCG-there isn't one. 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. ADDITIONAL INFORMATION Effective November 1, 2021, all new US hires must be fully vaccinated* or subject to a religious or medical exemption. *two weeks after receiving the final dose of a WHO-approved COVID19 vaccine

Requirements:

Boston Consulting Group