Lead Data Engineer in Bain & Company México

Bain & Company is the management consulting firm that the world’s business leaders come to
when they want results. Bain advises clients on strategy, operations, information technology,
organization, private equity, digital transformation and strategy, and mergers and acquisition,
developing practical insights that clients act on and transferring skills that make change stick.
The firm aligns its incentives with clients by linking its fees to their results. Bain clients have
outperformed the stock market 4 to 1. Founded in 1973, Bain has 58 offices in 37 countries, and
its deep expertise and client roster cross every industry and economic sector.

The primary tasks of this role revolve around core product development, including working as part of a cross-functional Agile development team to understand the business context and product domain.

Essential Functions:

- Product Development, Deployment, Support, and Maintenance 80%
• Own the end-to-end data model/schema design, implementation, and support
• Work with the Next Gen team’s Senior Architects and Engineering Managers to validate designs, discuss trade-offs and benefits of various approaches, and ensure long-term scalability and performance over time as data volumes and user concurrency grows with product adoption
• Ensure data models follow all Next Gen and industry-standard best practices related to data security, normalization, naming conventions, primary/foreign key relationships, indexing, constraints, and other considerations
• Create approved and agreed-upon data models using DDL scripting to ensure repeatability and consistency, maintain scripts in a version control system
• Collaborate with Next Gen’s Product Visualization Engineering team on defining the optimal data structures for BI tools to leverage the data, which could include custom views, materialized views, user defined functions/procedures, or optimized SQL
• Work to procure required data from client systems using a variety of protocols including APIs, direct database connections, SFTP, cloud, flat files, and others
• Use industry-leading data/ETL tools for data preparation including data validation, cleansing, joins/mergers, and reformatting into product required schemas for import
• Provide 3rd level technical support as needed when issues arise

- Misc. 20%
• Keep up-to-date on various technologies related to data architecture and engineering
• Participate on technical discovery, POCs, and innovation work streams to validate new tools, technologies, and designs
• Training, professional development, internal meetings, team building events/outings, etc. 20%

• Bachelor of Science degree in Computer Science, Applied Mathematics, Engineering, or any other technology-related field preferred, or strong relevant work experience
• 5+ years of relevant work experience with a data-engineering focus in a fast-paced, complex business setting
• Strong experience with traditional relational database management systems (e.g., SQL Server, MySQL, PostgreSQL, Oracle) and SQL skills (DML & DDL)
• Strong relational data modelling and design skills (tables, relationships, PK/FK, constraints/indexes)
• Strong experience creating custom user defined functions, procedures, views, materialized views, and optimized SQL
• Ability to troubleshoot slow performing queries, examining indexes, and running explain plans
• Experience with leading data preparation and analytics tools – Alteryx and Alteryx Server , Talend, Tableau Prep)
• Experience designing, implementing, and supporting end-to-end automated data
  pipelines using enterprise tooling, cloud-native services, or custom coding/development
• Experience working with version control systems (e.g., Git)

Other relevant skills

• Strong communication and presentation skills, including documenting complex
  data flows and processes for long-term support and maintenance
• Must be result-driven, be an analytical and creative thinker, be self-motivated and
  proactive, be highly organised and demonstrated ability to stay calm and composed in a
  fast moving environment
• Entrepreneurial spirit, innovative mind-set, willing to try new things, think outside
  the box, test and learn attitude

• Python coding and development experience
• Experience with enterprise cloud-based data ingestion and transformation technologies (e.g., Talend, SnapLogic, Informatica, Alteryx Server)
• Experience with cloud-native data services (e.g., AWS Glue, Azure Data Factory)
• Experience with NoSQL databases (e.g., MongoDB, AWS DynamoDB) and cloud-native data warehouses (Snowflake, AWS Redshift, Azure Synapse)
• Experience with enterprise BI platforms (e.g., Tableau, Power BI, Qlik, Domo Looker)