Who you will work with
This role is based out of the Visualization Centre of Excellence (CoE) at the BCN. Visualization CoE works closely with global Bain case teams, Bain Partners and end-clients providing them data analytics and business intelligence support using advanced data analysis and visualization tools (e.g., SQL, Python, Azure, AWS, Tableau, PowerBI, Alteryx etc.). The CoE is a one-stop shop for all case requests related to converting data into insightful visualizations tools (e.g., survey analytics, leadership KPI dashboards, etc).
What you’ll do
- Responsible for designing, building, and maintaining 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 (Azure/AWS/Python/SQL etc.) in individual capacity or lead teams of analysts to design and deliver impactful insights
- Support project lead in end-to-end handling of the entire process, i.e., requirement gathering, data cleaning, processing and automation
- Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions
- Ensure that data architecture is scalable and maintainable
- Apply knowledge of data analysis tools like Azure Data Bricks, AWS Athena, Alteryx, etc. to support case teams with analysis of KPIs
- 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
- Support case leads in managing internal and external stakeholders, across instruments and workstreams to provide expertise in data management and tool expertise
- Work under the guidance of a Team Lead / 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, monitor workload; Provides tool based technical expertise to the junior team members when required
- May deploy Data engineering solutions using CI/CD pipelines (GitHub, Cloud servers using Azure/AWS)
- May lead client/ case team calls and 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
About you
- Candidate should be a Graduate/Post-Graduate from top-tier College with strong academic records and with 3-5 years of relevant work experience in areas related to Data Management, Business Intelligence or Business Analytics. Hands-on experience in data handling and ETL workstreams
- Concentration in a quantitative discipline such as Statistics, Mathematics, Engineering, Computer Science, Econometrics, Business Analytics, or Market Research is strongly preferred
- Minimum 2+ years of experience in Database development on Cloud based platforms such as AWS/Azure
- Working Experience with Python and Advanced SQL queries, Stored procedures, query performance tuning, index maintenance, etc.,
- Experience of data modeling, data warehousing principles
- Experience on ETL tools in anyone of the tools like Azure Datafactory, Databricks, AWS Glue etc.
- Experience in reading data from different data sources including on premise data servers, cloud services and several file formats
- Understanding of database architecture
- Ability to prioritize projects, manage multiple competing priorities and drive projects to completion under tight deadlines
- Should be a motivated and collaborative team player, who is a role-model and at-cause individual within the team and office
- Excellent oral and written communication skills including the ability to communicate effectively with both technical and non-technical senior stakeholders
- Ability to prioritize projects, manage multiple competing priorities and drive projects to completion under tight deadlines
Good to Have:
- Exposure to CI/CD pipelines: GitHub, Docker, and containerization is a plus
- Candidates with advanced certifications in AWS and Azure will be preferred
- Experience on Snowflake/GCP is a plus
