Data Engineer – Azure/ETL

About the RoleThis is an independent contractor opportunity for professionals based in Mexico.Auxis is seeking an experienced Data Engineer – Azure/ETL to support a Data Lake project for one of our international clients.The ideal candidate will have strong hands-on experience designing, developing, and maintaining production ETL/ELT pipelines using Microsoft Azure technologies.This position focuses on data engineering, data integration, and data transformation, rather than cloud infrastructure or application development.
Key ResponsibilitiesDesign, develop, and maintain scalable ETL/ELT pipelines to support business intelligence, analytics, and reporting requirements.Build and maintain data integration solutions using Azure Data Factory and Azure Data Lake Storage.Develop and optimize SQL queries, stored procedures, and database objects.Use Python to support data ingestion, transformation, validation, and automation.Integrate data from relational databases, REST APIs, flat files, SFTP, and enterprise applications.Monitor and troubleshoot production data pipelines, resolving processing failures and data quality issues.Implement incremental data loading, data validation, and error-handling mechanisms.Support data warehouse and lakehouse solutions, including dimensional modeling and data transformations.Collaborate with business stakeholders and technical teams to understand data requirements.Maintain technical documentation and participate in testing, deployment, code reviews, and Agile development activities.
Required QualificationsAdvanced English proficiency (written and verbal), with the ability to communicate effectively with US-based teams and stakeholders.Bachelor's degree in Computer Science, Engineering, Information Systems, Data Science, Mathematics, or a related technical field.3+ years of hands-on experience in Data Engineering, particularly building and supporting ETL/ELT pipelines.Strong experience with Azure Data Factory (ADF), including pipelines, datasets, linked services, triggers, parameters, monitoring, and error handling.Advanced SQL skills, including complex joins, CTEs, window functions, stored procedures, and query optimization.Proficiency in Python for data engineering, including ingestion, transformation, validation, and automation.Hands-on experience with Azure Data Lake Storage Gen2 (ADLS) and data formats such as Parquet, CSV, and JSON.Experience integrating multiple data sources, including databases, APIs, flat files, and enterprise systems.Solid understanding of ETL/ELT concepts, incremental loading, Change Data Capture (CDC), data quality, and pipeline dependencies.Experience with data warehousing, lakehouse architectures, and dimensional data modeling.Experience monitoring, troubleshooting, and maintaining production data pipelines.Familiarity with Git, Azure DevOps, or equivalent version control and deployment practices.
Preferred QualificationsExperience with Microsoft Fabric, including OneLake, Lakehouse, notebooks, pipelines, or Warehouses.Experience with Azure Databricks or PySpark.Familiarity with Azure Synapse Analytics.Understanding of Power BI and semantic models.
About AuxisAuxis is a consulting and outsourcing firm that helps organizations improve their performance through technology, business transformation, and operational excellence.Join our team and contribute to innovative data engineering initiatives supporting international business operations.