Job Title: Lead Data Engineer
Location: On-site
Employment Type: Full-time
Job Overview:
**Responsibilities**:
- Design and implement migration strategies to modernize legacy SQL databases to Azure PaaS (Azure SQL, Azure Managed Instance).
- Develop and optimize data architectures for scalable, high-performance solutions on Azure.
- Configure and manage Cosmos DB for NoSQL workloads, ensuring performance, consistency, and scalability.
- Implement and optimize Azure Data Lakes for large-scale data storage, processing, and analytics.
- Architect and implement data pipelines to integrate and transform data into enterprise-ready solutions using tools such as Azure Data Factory and Synapse Analytics.
- Provide expertise in database performance tuning, optimization, and monitoring for cloud-based environments.
- Design and manage end-to-end data workflows, including ingestion, transformation, and reporting layers.
- Collaborate with stakeholders to gather requirements and design data architectures that meet business needs.
- Ensure data security, compliance, and governance across all data solutions.
- Stay updated on emerging Azure services and tools, providing recommendations to enhance the organization's data architecture strategy.
**Qualifications**
- 7+ years in database architecture, data engineering, or a similar role.
- Extensive experience migrating legacy SQL databases (e.g., MS SQL Server, Oracle) to Azure PaaS solutions.




**Technical Skills**:
- Strong expertise in Azure SQL Database and Azure SQL Managed Instance.
- Hands-on experience with Azure Data Lake Storage for scalable data storage and analytics.
- Knowledge of modern data warehousing tools such as Azure Synapse Analytics, Snowflake, or Redshift.
- Expertise in data pipeline design using tools like Azure Data Factory and Databricks.
- Familiarity with database monitoring and performance tuning tools in Azure.
- Strong scripting and query optimization skills using T-SQL, Python, PowerShell.
- Knowledge on EDI /ECP protocol is desired.
Cloud Expertise:
Deep understanding of Azure cloud services, including networking, storage, and security
Pay: $60,000.00 - $85,000.00 per month
Application Question(s):
- How many years of working experience do you have with Data warehousing tools Azure synapse analytics or snowflake or Red Shift?
- How many years of working experience do you have with Data Pipeline tools Databricks or Azure Data factory?
- How many years of working experience do you have with Azure Data Lake Storage?
- How many years of working experience do you have with Cosmo DB, No SQL and RDBMS databases?
- How many years of working experience do you have with Data engineering or similar role?
- Are you ok with Work from office model?
- Are you ok to relocate to Guadalajara?
Work Location: In person

📌 Lead Data Engineer (Guadalajara)
🏢 Programming.Com
📍 Guadalajara