Lead Data Engineer/Data Architect

We are looking for DB developer who wants to Lead Data migration portion in various big modernization projects. Knowledge on different DBMS and experience with wide variety of platforms is highly desirable. Individual should be able to come up with data migration approach and must understand the ins and outs of database physical and logical replications, clustering, mirroring, and high availability. Analytic skill in solving problems of building robust and efficient data processing routines both on premise and in cloud is a must.

Must have

• Strong expertise in designing and implementing data models, including conceptual, logical, and physical data models, to support efficient data storage and retrieval.
• Strong knowledge of Microsoft Azure, including Azure Data Lake Storage, Azure Synapse Analytics, Azure Data Factory, and Azure Databricks, for building scalable and reliable data solutions.
• Proficiency in distributed computing frameworks such as Apache Spark for processing and analyzing large-scale datasets.
• Extensive experience with building robust and scalable ETL/ELT pipelines to extract, transform, and load data from various sources into data lakes or data warehouses.
• Ability to integrate data from disparate sources, including databases, APIs, and external data providers, using appropriate techniques such as API integration or message queuing.
• Proficiency in designing and implementing data warehousing solutions, including dimensional modeling, star schemas, and data aggregation techniques.
• Experience with Azure Cosmos DB, Azure Analysis Services, and Informix.
• Experience with Python and Python-based ETL tools.
• Experience with shell scripting in Bash, Unix or windows shell is preferable.

Nice to have

• Experience with Elasticsearch
• Familiarity with containerization and orchestration technologies (Docker, Kubernetes).
• Troubleshooting and Performance Tuning: Ability to identify and resolve performance bottlenecks in data processing workflows and optimize data pipelines for efficient data ingestion and analysis.
• Collaboration and Communication: Strong interpersonal skills to collaborate effectively with stakeholders, data engineers, data scientists, and other cross-functional teams.

Remote Mexico