Senior Associate – Visualization CoE (Data Engineer)
bain
Job Description
- Responsible for end-to-end handling of the entire process, i.e., requirement gathering, data cleaning, processing and automation
- Design, build, and maintain infrastructure and systems that enable the Extraction, Transformation, and Storage of large datasets for analysis
- Work with Bain team or end-clients as an expert on specific platform/tool/language (Snowflake/Azure/AWS/Python/SQL etc.) in individual capacity or lead teams of analysts and associates to design and deliver impactful insights
- Gather requirements and business process knowledge in order to transform the data in a way that’s geared towards the needs of end users
- Ensure that the data architecture is scalable and maintainable
- Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions
- Apply knowledge of data analysis tools like SnowPark, Azure Data Bricks, AWS Athena, Alteryx, etc. to support case teams with analysis of KPIs
- Solve complex custom visualization and analysis issues, providing thought leadership and business judgment
- Prepare documentation for further reference
- The working style of the team would be to support product development; hence the pipelines and algorithm built should be scalable and automated
- Manage internal and external stakeholders, across instruments and workstreams to provide expertise in data management and tool expertise
- Work under the guidance of a Team Manager / Sr. Team Manager, playing a key role in driving the team’s overall answer and final materials, client communication, work planning, and team management
- May also take responsibility for assigning work streams to Analysts & Associates, monitor and balance workload; Provides tool based technical expertise to the junior team members when required
- Deploy Data engineering solutions using CI/CD pipelines (GitHub, Cloud servers using Snowflake/Azure/AWS)
- Lead client/ case team calls and effectively communicate data, knowledge, insights and actionable next steps to the case team; relay implications to his/her own internal team
- Keep abreast of new and current statistical, database and data warehousing tools & techniques
- Recognize team’s development needs and consistently provide responsible feedback in all interactions via conducting performance discussions, writing reviews for appraisal etc.
- Assist on other team management activities (e.g. recruiting, training, etc.)