Data Engineer
Key qualifications
- Strong knowledge of SQL (T-SQL is preferable).
- Experience with Azure (Azure Service Bus, ADF, Azure Function, SQL Managed Instance).
- Good knowledge of python.
- Good knowledge of any modern RDBMS (what are indexes, views, functions, triggers, etc)
- Proficient in exploring databases and identify data elements with minimal documentation.
- Experience with ETL tool (SSIS, ADF).
- Proficient in data modelling of DWH.
- Experience and understanding of testing, coding, design, documentation and change management procedures.
- Strong work ethic with a highly positive, hands-on, can-do attitude and flexible team player.
- Ability to manage tasks independently, take ownership of responsibilities and work with minimal supervision.
- High level of integrity, takes accountability of work and good attitude over teamwork; and Takes initiative to improve the current state of things and adaptable to embrace new changes.
Additionally
- Proficient in foundational data visualization concepts, ability to identify appropriate visual tools (charts) for dashboard development.
- Experience with Power BI or SQL Analysis Service (Tabular).
- Knowledge of DAX.
Your responsibility and scope
- Building the DWH for which all data is collected, organized, and analyzed
- Ingesting all data into this DWH
- Cleanse data ingested into DWH
- Prep data for analysis based on guidance from data modelers and data analysts/scientists
- Maintain and support these environments to ensure reliability and performance
- Perform ongoing monitoring of data pipelines and work with stakeholders to troubleshoot and performance tune.
- Create and maintain accurate and complete documentation of the DWH platform and the pipelines developed to ensure its currency.
- Maintain awareness of industry trends on regulatory compliance, emerging threats and appropriate steps to mitigate the risks; and
- Highlight any potential concerns/risks and proactively shares best risk management practices.
- Any other ad-hoc duties as assigned.
We offer
- Full-time, relocation to Mexico-City;
- Latest tech stack, high load distributed application development challenges;
- International team of experienced and talented professionals;
- Ability to become a Technical/Team leader in a fast growing team.