Azure Data Engineer

Sutherland; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

A leading company is seeking a Data Engineer to build scalable data pipelines and optimize ETL processes in Azure cloud environments. The ideal candidate will have strong expertise in Azure Data Factory, Databricks, and Python, along with experience in big data processing and data governance. This role involves collaborating with analysts and scientists to ensure data quality and usability.

Qualifications

• Strong experience in Azure Data Factory, Databricks, and Azure Synapse.
• Proficiency in Python for data processing and automation.
• Advanced knowledge of SQL for data manipulation.

Responsibilities

• Develop robust ETL pipelines using ADF, Databricks, and Python.
• Design logical and physical data models for structured data.
• Implement data validation and security measures.

Skills

Azure Data Factory

Databricks

Python

SQL

Apache Spark

Data Governance

Performance Optimization

Job description

Job Title: Data Engineer

Job Summary:

Are you passionate about building scalable data pipelines, optimizing ETL processes, and designing efficient data models? We are looking for a Databricks Data Engineer to join our team and play a key role in managing and transforming data in Azure cloud environments.

In this role, you will work with Azure Data Factory (ADF), Databricks, Python, and SQL to develop robust data ingestion and transformation workflows. Youll also be responsible for integrating, ,optimizing performance, and ensuring data quality & governance. If you have strong experience in big data processing, distributed computing (Spark), and data modeling, wed love to hear from you!

Key Responsibilities:

1. Develop & Optimize ETL Pipelines:

• Build robust and scalable data pipelines using ADF, Databricks, and Python for data ingestion, transformation, and loading.

2. Data Modeling & Systematic Layer Modeling:

• Design logical, physical, and systematic data models for structured and unstructured data.

3. Database Management:

• Develop and optimize SQL queries, stored procedures, and indexing strategies to enhance performance.

4. Big Data Processing:

• Work with Azure Databricks for distributed computing, Spark for large-scale processing, and Delta Lake for optimized storage.

5. Data Quality & Governance:

• Implement data validation, lineage tracking, and security measures for high-quality, compliant data.

6. Collaboration:

• Work closely with business analysts, data scientists, and DevOps teams to ensure data availability and usability.

7. Testing and Debugging:

• Write unit tests and perform debugging to ensure the Implementation is robust and error-free.
• Conduct performance optimization and security audits.

Required Skills and Qualifications:

1. Azure Cloud Expertise:

• Strong experience in Azure Data Factory (ADF), Databricks, and Azure Synapse.

Programming:

• Proficiency in Python for data processing, automation, and scripting.

SQL & Database Skills:

• Advanced knowledge of SQL, T-SQL, or PL/SQL for data manipulation.

Data Modeling:

• Hands-on experience in dimensional modeling, systematic layer modeling, and entity-relationship modeling.

Big Data Frameworks:

• Strong understanding of Apache Spark, Delta Lake, and distributed computing.

Performance Optimization:

• Expertise in query optimization, indexing, and performance tuning.

Data Governance & Security:

• Knowledge of RBAC, encryption, and data privacy standards.

Preferred Qualifications:

1. Experience with CI/CD for data pipelines using Azure DevOps.
2. Knowledge of Kafka/Event Hub for real-time data processing.
3. Experience with Power BI/Tableau for data visualization (not mandatory but a plus).