Finance Transformation Program – IT Data Engineer Full Time

Boston Consulting Group
WHAT YOU’LL DOWe are making a significant investment in our Finance platform to support our new age finance capabilities. You will work closely with finance business stakeholders, SAP ERP implementation team and BCG data platform team in this role.
Under the general supervision of Finance transformation team and Data architecture lead you will be working with SAP ERP (Finance) team, IT team & business users to deliver timely and accurate data in a secure manner. You are expected to provide design guidance & build proper data integration routines, ETL jobs and ensure that our architectural guidelines are met.
YOUR RESPONSIBILITIES

• Bring a data-driven approach to decision making, both in day-to-day management and in making strategic trade-offs
• Implement data orchestration pipelines, data sourcing, cleansing, and augmentation and quality control processes (such as SAP S4 to Snowflake)
• 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
• Deploying Data routines in production, production support, release management
• Supporting data architects in designing data architectures
• Work in Agile Methodologies Sprint, Scrums, leveraging Dev-sec-Ops principles
• Work with stakeholders to gather requirements and designing the build
• Contributing to overall solution, integration, and enterprise architectures
• Develop strategies for data integration in the Cloud (AWS/Azure)

YOU’RE GOOD AT

• Eliciting business and non-functional requirements, perform gap analysis and feasibility checks, write clear and comprehensive specifications and end-user documentation, configure changes, and work with other team members to develop and execute comprehensive test plans.
• 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 analyzing 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.
• 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
• An understanding of “big picture” business requirements that drive architecture and design decisions.

YOU BRING (EXPERIENCE & QUALIFICATIONS)

• BS/BA in software engineering, data science, computer science, applied mathematics, or equivalent experience
• Deep understanding of relational and warehousing database technology, working with at least one of the major databases platforms (Snowflake, Oracle, SQLServer, Teradata, MySQL, Postgres)
• 3+ years of experience working on large scale, full lifecycle data implementation projects (Data Lake, EDW)
• 3+ Working with Data integration & streaming technologies such as Qlik, Fivetran, SAP DI
• Working experience with SAP S4 & SAP DI with Snowflake is preferred
• Strong knowledge of performant SQL syntax, semantics and CPSs managed versions usage, and deep understanding of relational database technology
• Hands-on RDBMS experience (data modeling, analysis, programming, stored procedures)
• Expertise in developing ETL/ELT workflows with one or more of the following:
  • Python
  • Airflow
  • Scala
  • Java

YOU’LL WORK WITHBCG s information technology group collaboratively delivers the latest digital technologies that enable our consultants to lead and our business to grow. For our IT jobs, we seek individuals with expertise in the areas of IT infrastructure, application development, business systems, collaborative and social technologies, information security, and project leadership