Azure Data Engineer
Description
Experience: 8+ years
Please note: This is an independent contractor position with a maximum monthly compensation of USD $3,400. No additional benefits are included.
Job Description
• We are seeking an experienced Data Engineer based in Mexico to join our nearshore cloud and data engineering team. In this role, you will architect, build, and maintain both batch and real-time data pipelines alongside Master Data Management (MDM) solutions within an Azure environment to support US-based business operations.
Key Responsibilities:
• Batch & Streaming Pipelines: Design, develop, and optimize scalable ETL/ELT workflows using Azure Databricks, Azure Data Factory, and Informatica, alongside real-time data ingestion pipelines using Apache Kafka.
• Master Data Management (MDM): Implement and maintain MDM workflows, data models, and match/merge logic to establish a reliable single source of truth across enterprise systems.
• Azure Lakehouse Management: Manage and optimize data storage, partitioning, and transformation layers within ADLS Gen2 and Delta Lake to ensure high performance and cost efficiency.
• SQL & Performance Tuning: Write complex SQL queries, perform deep data analysis, and troubleshoot bottlenecks across streaming and batch workloads.
Mandatory Skills:
• Azure Data Ecosystem: Hands-on experience building and managing cloud data solutions using Azure services such as Azure Data Lake Storage (ADLS Gen2), Azure Data Factory (ADF), and Azure Synapse Analytics.
• Databricks & Spark: Strong proficiency in Azure Databricks using PySpark, Spark SQL, and Delta Lake for scalable data processing and lakehouse architecture.
• Real-Time Streaming (Kafka): Practical experience designing, building, and troubleshooting real-time event streaming pipelines using Apache Kafka (or Azure Event Hubs for Kafka).
• Informatica & MDM: Proven experience with Informatica (IICS / PowerCenter) and Master Data Management (MDM) concepts, including data modeling, match/merge rules, and golden record creation.
• Advanced SQL: Expert-level SQL skills for complex querying, data transformation, profiling, and performance tuning across relational and cloud data warehouses.
Desired Skills
• DevOps & Orchestration: Experience with CI/CD pipelines (Azure DevOps, GitHub Actions), Infrastructure as Code (Terraform/ARM), and workflow orchestration tools.
• Programming & Scripting: Proficiency in Python or Scala beyond PySpark for automation, API integrations, and custom data processing.
• Data Governance & Security: Familiarity with Unity Catalog, Microsoft Purview, RBAC security models, and data privacy compliance standards.
• Certifications: Microsoft Certified: Azure Data Engineer Associate, Databricks Certified Data Engineer, or Informatica certifications.
Skills
- Analytics
- API
- Automation
- Azure
- Azure Data Factory
- Azure DevOps
- Azure Synapse
- CI/CD
- Cloud
- Data Engineering
- Data Governance
- Data Ingestion
- Data Lake
- Data Modeling
- Data Pipelines
- Databricks
- Delta Lake
- DevOps
- ELT
- ETL
- GitHub
- GitHub Actions
- Infrastructure as Code
- Kafka
- Lakehouse
- Master Data Management
- MDM
- Microsoft Purview
- PySpark
- Python
- RBAC
- Scala
- Spark
- SQL
- Terraform
- Unity
- Unity Catalog
- Workflow Orchestration
Sign in to read and join the discussion.