Bain & Company Inc

Data Engineer, TSG Data and Analytics (ND)

Job Location India-New Delhi
Job ID
2021-5993
Posted Date
9/23/2021
Category
Hidden (8730)
Type
Regular Full-Time

The company is aggressively transforming into a 21st century data-driven organization for its internal customers. We are adding to a growing Data Engineering team that will be responsible for building data pipelines and leveraging Data Ops. The team will develop data pipelines, take data analytics prototype models to production, monitor operations, and standup the necessary infrastructure in Azure to perform these functions.  Data engineering solutions created by the team are primarily enterprise-scale browser based or mobile applications developed with current Microsoft development languages and technologies, with a global internal user base and integration points with one or more other internal Bain systems.

The Data Engineer will be part of the IT Data and Analytics Team (Bain’s internal team of data engineering, analytics, and data architecture). This position will work closely with other team members of the Agile Scrum Data Engineering team to deliver valuable data sets to the business

 

Who we are looking for:

Regardless of an individual’s background, the successful candidate will be

  • Collaborative – knows how to work with and through others to drive results and make change happen in the pursuit of world-class customer user experiences
  • Entrepreneurial, proactive, and productive – knows how to prioritize what needs to be done and rallies colleagues to get things accomplished; “roll up the sleeves” type of attitude
  • Bright – both insightful and creative, strong problem-solving skills, and pragmatic “real-world” sense of what is actually “do-able”. Able to harness knowledge and expertise of the best industry content to support analytics at Bain
  • Articulate and compelling – engaging and concise in oral and written communication skills with interpersonal “presence”; adaptable across executive, technical and Bain audiences
  • Energetic, with drive, enthusiasm, and natural skills in relationship development – well-connected, with an extensive network of potentially relevant relationships
  • An Inspirational Leader - track record of working with high-performing, service-oriented team members, and motivating and developing colleagues above and below their own tenure
  • A great colleague and teammate - passionate about the task at hand and fun to be around; someone with whom Bainies go out of their way to work

Build data pipelines

  • Work as a member of a scrum team, developing and updating data engineering pipelines, primarily using Talend and Microsoft cloud and hosted services, T-SQL, and other ETL tools and technologies
  • Design and build robust, scalable, and maintainable data ingestion ETL/ELT pipelines based on guidance from the Product Owner and Data Architect
  • Choose appropriate data models and ensure that ingested data is high quality
  • Write high quality code that has high test coverage
  • Participate in code reviews to help improve code quality
  • Coordinate with QA Specialist to ensure data quality meets acceptance criteria before delivery to internal customer
  • Participate scrum team ceremonies, including backlog refinement and understanding requirements, sprint planning, daily standups, sprint reviews, and retrospectives

 

Understand business data objectives

  • Coordinate with business to understand data requirements for data analytics projects within the broader business context
  • Develop a deep understanding of the ingested data from a business perspective
  • Work with data architect and product owner to understand the data schema and the nature of data flow within the enterprise
  • Collaborate with Data Architect to keep data dictionaries up to date

 

Knowledge and best practices

  • Maintain current personal knowledge of existing and potential Data Engineering tools and technology
  • Contribute to codifying best practices that help with incremental delivery and continuous integration

  • Bachelor's degree in MIS or Computer Science or equivalent work experience
  • 3-6 years of experience in a Data Engineer role
  • At least 3 years of experience in extracting data using REST APIs and from databases (MSSQL, Azure SQL)
  • At least 3 years of experience in deploying pipelines using Data Ops, preferably Azure DevOps
  • Minimum of 3 years’ experience in advanced data processing and software development is desired.
  • High proficiency in SQL Server, SSAS, SSRS, including authoring views and stored procedures and building data models. Stored procedure experience should include writing, debugging, and optimizing complex procedures.
  • High proficiency working with Data Pipeline tools like Talend, SSIS, and Azure Data Factory
  • Attention to detail and aptitude for analytical problem resolution
  • Ability to work independently and with teams on complex problems
  • Strong verbal and written communication skills
  • High performance and standards as demonstrated by academic or previous job experience
  • Knowledge of shell scripting, Python, SQL, Azure, or AWS
  • Understanding of Scrum Agile Methodology with experience in working in sprints delivering user stories
  • Understanding of agile tools such as Azure Dev Ops, Jira, etc.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed