Global IT Data Engineer Senior Specialist

WHAT YOU'LL DO
Be part of a team that is transforming BCG into a bionic company! We are building a centralized Business Intelligence & Analytics function that will simplify and automate information delivery-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 next wave of digital reporting is underway which will help to unlock further value for BCG functions and leadership with best-in-class business intelligence and analytics.

The Global IT Data Engineer Senior Specialist works as an integral part of an Agile team delivering scalable digital reporting solutions for global stakeholders. This role will help design optimal solutions to support and operate the Finance data warehouse-employing best practices for data modelling, scalable Extract-Load-Transform jobs and data pipelines for Tableau dashboards.

YOU'RE GOOD AT
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:
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
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

YOU BRING (EXPERIENCE & QUALIFICATIONS)

BS/BA degree, preferably in computer science or related field; or business administration or mathematics. Experience in data analysis and database architecture, maintenance, and support.
5+ years IT experience, including 3+ years in ELT/Data Integration for BI.
Advanced 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.
Expert level proficiency with industry standard ELT tools is a plus, such as ODI, Talend or other (Topology, template-driven code generation, CDC, Metadata, and Web Services).
Hands-on implementation experience with Data Warehousing including design, modelling, testing, security, administration and optimization.
Experience in all aspects of Agile SDLC, and end to end participation in a project lifecycle.
Reporting tool experience Tableau, OBIEE, SAP BO is a plus.
* Exposure to python is a plus.

YOU'LL WORK WITH
BCG'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.