Role: Data Science & Analytics - Other
Industry Type: Management Consulting
Department: Data Science & Analytics
Employment Type: Full Time, Permanent
Role Category: Data Science & Analytics - Other
UG: Any Graduate
PG: Any Postgraduate
Boston Consulting Group partners with leaders in business and society to tackle their most important challenges and capture their greatest opportunities. BCG was the pioneer in business strategy when it was founded in 1963. Today, we help clients with total transformation-inspiring complex change, enabling organizations to grow, building competitive advantage, and driving bottom-line impact. To succeed, organizations must blend digital and human capabilities. Our diverse, global teams bring deep industry and functional expertise and a range of perspectives to spark change. BCG delivers solutions through leading-edge management consulting along with technology and design, corporate and digital ventures and business purpose. We work in a uniquely collaborative model across the firm and throughout all levels of the client organization, generating results that allow our clients to thrive. What Youll 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 analytics and AI to support decision making. To date, the team has launched and operationalized several global scale data products, enhancing how our leaders engage in information to manage the business. The Senior Manager - Data Engineer role will be an integral part of an Agile team focused on delivering best in class data engineering practices. Under the general supervision of senior management and the Data Ingestion & Analyst 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 data ingestion and integration design, ensuring that our enterprise 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 Ingestion chapter in people management and proof-of-concept activities related to Data Ingestion and Integration. What Youll Bring Minimum of a Bachelors degree in Computer science, Engineering or a similar field 7-9+ years of Data Ingestion, Integration and ETL relevant experience. Essential: Experience in loading data into warehouse/ ODS environment from diverse sources and formats Essential: Experience in AWS Glue, DBT and Fivetran Essential: Strong programming/ scripting skills in Python and SQL Essential: Experience working with APIs, Semi-Structured and Unstructured datasets. Essential: Lead R&D efforts to find solutions for data integration requirements not addressed by existing technology standards Essential: Develop metrics that showcase the flow of data across the organization Essential: Experience in data modelling and relational database design Essential: Experience in data platforms: Snowflake, Oracle, SQL Server, PostgreSQL, and MySQL Essential: Design strategies for new data ingestion requests, including logical and physical data modelling Preferred: Experience in AWS data platforms and integration offerings Who Youll 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 IT Data Product Engineering Group, you will work closely with a cross functional teams. Your stakeholders are incredibly intelligent and analytical, make business decisions with a global lens. Additional info 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 a