Azure Data Engineer

Advantmed; United States; Remote; USD 80,000 - 130,000; Full time

Job summary

An established industry player is looking for a Senior Data Engineer to join their innovative team. In this role, you will build a robust data platform on Azure Cloud, focusing on designing and managing data pipelines, ensuring data quality, and leveraging cloud technologies for scalable data processing. You will collaborate with data architects and analysts to create efficient data workflows and enhance the overall data platform. If you are passionate about data engineering and eager to contribute to cutting-edge projects, this opportunity is perfect for you.

Qualifications

• 5+ years of experience in data engineering or similar roles.
• Strong experience with Azure services and data processing.

Responsibilities

• Develop and maintain data ingestion pipelines using Azure tools.
• Design ETL/ELT workflows for data transformation and storage.

Skills

Azure Data Factory

Databricks

Azure Synapse Analytics

Python

SQL

Spark

ETL/ELT processes

Data modeling

Data warehousing

REST APIs

Education

Bachelors degree in Computer Science

5+ years of experience in data engineering

Tools

Azure Data Factory

Databricks

Azure Functions

Logic Apps

Azure DevOps

Terraform

Power BI

Job description

Senior Data Engineer

Job Description

We are seeking a talented and experienced Senior Data Engineer to join our team and contribute to building a robust data platform on Azure Cloud. The ideal candidate will have hands-on experience designing and managing data pipelines, ensuring data quality, and leveraging cloud technologies for scalable and efficient data processing. The Data Engineer will design, develop, and maintain scalable data pipelines and systems to support the ingestion, transformation, and analysis of large datasets. The role requires a deep understanding of data workflows, cloud platforms (Azure), and strong problem-solving skills to ensure efficient and reliable data delivery.

Key Responsibilities

1. Data Ingestion and Integration:
   • Develop and maintain data ingestion pipelines using tools like Azure Data Factory, Databricks, and Azure Event Hubs.
   • Integrate data from various sources, including APIs, databases, file systems, and streaming data.
2. ETL/ELT Development:
   • Design and implement ETL/ELT workflows to transform and prepare data for analysis and storage in the data lake or data warehouse.
   • Automate and optimize data processing workflows for performance and scalability.
3. Data Modeling and Storage:
   • Design data models for efficient storage and retrieval in Azure Data Lake Storage and Azure Synapse Analytics.
   • Implement best practices for partitioning, indexing, and versioning in data lakes and warehouses.
4. Quality Assurance:
   • Implement data validation, monitoring, and reconciliation processes to ensure data accuracy and consistency.
   • Troubleshoot and resolve issues in data pipelines to ensure seamless operation.
5. Collaboration and Documentation:
   • Work closely with data architects, analysts, and other stakeholders to understand requirements and translate them into technical solutions.
   • Document processes, workflows, and system configurations for maintenance and onboarding purposes.
6. Cloud Services and Infrastructure:
   • Leverage Azure services like Azure Data Factory, Databricks, Azure Functions, and Logic Apps to create scalable and cost-effective solutions.
   • Monitor and optimize Azure resources for performance and cost management.
7. Security and Governance:
   • Ensure data pipelines comply with organizational security and governance policies.
   • Implement security protocols using Azure IAM, encryption, and Azure Key Vault.
8. Continuous Improvement:
   • Monitor existing pipelines and suggest improvements for better efficiency, reliability, and scalability.
   • Stay updated on emerging technologies and recommend enhancements to the data platform.

Skills

• Strong experience with Azure Data Factory, Databricks, and Azure Synapse Analytics.
• Proficiency in Python, SQL, and Spark.
• Hands-on experience with ETL/ELT processes and frameworks.
• Knowledge of data modeling, data warehousing, and data lake architectures.
• Familiarity with REST APIs, streaming data (Kafka, Event Hubs), and batch processing.

Good To Have:

• Experience with tools like Azure Purview, Delta Lake, or similar governance frameworks.
• Understanding of CI/CD pipelines and DevOps tools like Azure DevOps or Terraform.
• Familiarity with data visualization tools like Power BI.

Competency

• Analytical Thinking
• Clear and effective communication
• Time Management
• Team Collaboration
• Technical Proficiency
• Supervising Others
• Problem Solving
• Risk Management
• Organizing & Task Management
• Creativity/innovation
• Honesty/Integrity

Education:

• Bachelors degree in Computer Science, Data Science, or a related field.
• 5+ years of experience in a data engineering or similar role.