Azure Data Engineer

Machine Learning Technologies, LLC; Grand Rapids (MI); On-site; USD 120,000 - 160,000; Full time

Job summary

Machine Learning Technologies, LLC in the United States is seeking a data engineer to design, implement, and optimize Azure-based data pipelines and lakes. You will build ETL/ELT workflows, transform data with SQL, Spark, and Mapping Data Flows, and ensure secure, governed access to cloud data platforms.

Collaboration with analysts and stakeholders is essential for delivering scalable analytics solutions. The role focuses on migrating on-premises data to Azure, maintaining data architecture

Qualifications

• Expertise with Azure Data Factory for pipeline development and maintenance.
• Experience with Azure Data Lake Storage and enterprise-scale data lakes.
• Experience developing ETL/ELT workflows ingesting from multiple sources.
• Knowledge of Mapping Data Flows, SQL, and Spark for data transformation.
• Experience with incremental loads, CDC, and data validation.
• Ability to troubleshoot and optimize data pipelines for performance.
• Familiarity with data modeling, warehousing, and cloud data security/governance.
• Experience supporting on-premises data migration to Azure cloud environments.

Responsibilities

• Design, develop, and maintain data pipelines using Azure Data Factory.
• Build and manage enterprise-scale data lakes using Azure Data Lake Storage.
• Develop ETL/ELT workflows to ingest data from multiple sources (DBs, APIs, files, cloud apps).
• Implement data transformation processes using Mapping Data Flows, SQL, and Spark.
• Monitor, troubleshoot, and optimize data pipelines for reliability and performance.
• Configure incremental loads, CDC, and data validation processes.
• Collaborate with analysts, stakeholders, and developers to understand data requirements.
• Design data models and support data warehousing solutions.
• Implement security, governance, and access controls for cloud data platforms.
• Create technical documentation and maintain data architecture standards.
• Support migration of on-premises data solutions to Azure cloud.

Skills

Azure Data Factory

Azure Data Lake Storage

ETL/ELT

Data pipelines

SQL

Spark

CDC

Data modeling

Data warehousing

Security & governance

Tools

Mapping Data Flows

Job description

This role focuses on developing reliable data pipelines, managing enterprise-scale data lakes, implementing ETL/ELT workflows, and supporting cloud-based analytics and data warehousing solutions.

The ideal candidate brings expertise in Azure Data Factory, Azure Data Lake Storage, data transformation technologies, and cloud data engineering practices.

Key Responsibilities:

• Design, develop, and maintain data pipelines using Azure Data Factory.
• Build and manage enterprise-scale data lakes using Azure Data Lake Storage.
• Develop ETL/ELT workflows to ingest data from multiple sources, including databases, APIs, flat files, and cloud applications.
• Implement data transformation processes using Mapping Data Flows, SQL, and Spark technologies.
• Monitor, troubleshoot, and optimize data pipelines for performance and reliability.
• Configure incremental data loads, Change Data Capture (CDC), and data validation processes.
• Collaborate with data analysts, business stakeholders, and development teams to understand data requirements.
• Design data models and support data warehousing solutions.
• Implement security, governance, and access controls for cloud data platforms.
• Create technical documentation and maintain data architecture standards.
• Support the migration of on-premises data solutions to Azure cloud environments.

Required Qualifications:

• Expertise in Azure Data Factory for data pipeline development and maintenance.
• Experience with Azure Data Lake Storage and enterprise-scale data lakes.
• Experience developing ETL/ELT workflows for data ingestion from multiple sources.
• Knowledge of Mapping Data Flows, SQL, and Spark technologies for data transformation.
• Experience with incremental data loads, Change Data Capture (CDC), and data validation.
• Ability to troubleshoot and optimize data pipelines for performance and reliability.
• Knowledge of data modeling, data warehousing, and cloud data platform security and governance.
• Experience supporting on-premises data migration to Azure cloud environments.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.