**BAT is evolving at pace - truly like no other organization.**
**To achieve the ambition, we have set for ourselves, we are looking for colleagues who are ready to live our ethos every day. Come be a part of this journey!**
**BAT MEXICO** **IS LOOKING FOR A** **DATA ENGINEER (SQL)**
**SENIORITY LEVEL**:Junior Level
**FUNCTION**: Digital Business Solutions (DBS)
**LOCATION**:Monterrey
**ROLE POSITIONING AND OBJECTIVES**
This role is part of the DBS function.
The role is responsible for support the US team in data integration, data architecture and process optimization tasks.
**Reports to**:Data Engineer Lead
**Reporting Level**:Managerial
**Geographic Scope**:US
**WHAT YOU WILL BE ACCOUNTABLE FOR**
- Integrates end to end data pipelines to take data from data source to target data repositories ensuring the quality and consistency of data.
- Understand Data Architecture concepts.
- Drive performance analysis and optimization tasks over SQL database objects like Store Procedures and Views.
- Coordinates issue resolution with multi-functional teams and vendors.
- Serves as a productive project team member delivering high quality results for work you are doing.
- Assists the project manager by assisting sharing work plans, effort estimates and delivery timelines for work you're leading.
- Drive collaborative reviews of design, code, data, features implementation performed by other data engineers in support of maintaining data engineering standards.
**CAN THIS BE YOUR FUTURE ROLE?**
- Are you willing to develop your career in a fast paced global company?
**ESSENTIAL EXPERIENCE, SKILLS AND KNOWLEDGE**
- Bachelor's Degree or equivalent experience in Computer Science/Engineering or related.
- +2 years working experience preferred.
- Experience with partners and requirements gathering/implementation.
- Intermediate knowledge (as minimum) over SQL (CTEs, Historical data management, Store Procs, Views, Functions, Logs, etc).
- Experience developing extract, transform, load (ETL) pipelines using Databricks, PySpark and Cloud Storage.
- Experience with Python.
- Extensive experience with data engineering tools, languages, frameworks to mine, cleanse and explore data.
- Experience Control-Versioning coding such as Git.
- Experience with Cloud technologies (ex. Azure, AWS, GCP, Teradata, Snowflake).
- Advance English proficiency written and verbal.
**BENEFICIAL**
- Experience with Databricks: MachineLearning (MLFlow); SQL Warehousing / Delta tables; Unity Catalog; Event/Driver Logs analysis.
- PySpark RDDs (Resilient Distributed Dataset) and MLOPS (Azure DevOps).
- AWS Redshift, Teradata, Snowflake and Knowledge over Programming Object-Oriented concepts.
- Productionalize the full pipeline including and ETL workflows (e.g., training/test pipeline).
- Experience with orchestration toolsets (e.g. Airflow, Tidal).
**WE ARE BAT**
At BAT we are committed to our Purpose of creating A Better Tomorrow. This is what drives our people and our passion for innovation. **See what is possible for you at BAT.**
- Global Top Employer with 53,000 BAT people across more than 180 markets
- Brands sold in over 200 markets, made in 44 factories in 42 countries
- Newly established Tech Hubs building world-class capabilities for innovation in 4 strategic locations
- Diversity leader in the Financial Times and International Women's Day Best Practice winner
- Seal Award winner - one of 50 most sustainable companies
**BELONGING, ACHIEVING, TOGETHER**
Collaboration, diversity and teamwork underpin everything we do here at BAT. We know that collaborating with colleagues from different backgrounds is what makes us stronger and best prepared to meet our business goals. **Come bring your difference!