Microsoft Azure ETL & Reporting Developer

Apexon; Hanover (MD); On-site; USD 120,000 - 125,000; Full time

Job summary

A leading IT services provider in Hanover, MD, seeks an ETL Developer at the mid-senior level to maintain and enhance ETL pipelines using Azure Synapse Analytics. The role involves designing and developing new ETL processes, collaborating with stakeholders, and ensuring data quality. A full-time position with a compensation range of $120,000 to $125,000 per year is offered.

Qualifications

• Ability to design, develop, and maintain ETL pipelines.
• Expertise in troubleshooting ETL workflows for data warehousing.
• Experience in building and maintaining deployment pipelines.

Responsibilities

• Maintain and enhance ETL pipelines using Azure Synapse Analytics.
• Design and develop new ETL pipelines for data import and transformation.
• Collaborate with stakeholders to document ETL processes.

Skills

ETL Process Design & Optimization

Expertise in building ETL workflows

Experience with Azure DevOps pipelines

Microsoft SQL Server

Microsoft Power Automate

Data Quality & Process Efficiency

Job description

Overview

This range is provided by Apexon. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$120,000.00/yr - $125,000.00/yr

Location - On-site 3 days per week. Hanover, MD.

Duration: Full-time with Apexon

Role Description

• Maintain, modify, and enhance ETL pipelines using Microsoft Azure Synapse Analytics.
• Design, develop, and optimize new ETL pipelines for importing and transforming data from source systems into the Data Warehouse application.
• Build Azure DevOps pipelines for code deployment and automation of ETL processes.
• Develop and implement workflow automations using Microsoft Power Automate to streamline data and reporting operations.
• Work with Microsoft SQL Server databases, including creating, modifying database objects such as tables, views, and stored procedures in lower environments
• Monitor, troubleshoot, and resolve ETL job issues, ensuring data quality and process efficiency.
• Collaborate with stakeholders to understand data requirements and document ETL processes.

Required Skills

• Ability to independently design, develop, and maintain complex ETL pipelines
• ETL Process Design & Optimization: Advanced
• Expertise in building, optimizing, and troubleshooting ETL workflows for data warehousing
• Experience building, configuring, and maintaining deployment pipelines for code and ETL automation
• Microsoft Power Automate: Intermediate
• Microsoft SQL Server (Database Objects): Advanced
• ETL Job Monitoring & Troubleshooting: Advanced
• Data Quality & Process Efficiency: Intermediate
• Stakeholder Collaboration & Documentation: Intermediate

Seniority level

Mid-Senior level

Employment type

Full-time

Job function

Analyst

Industries

IT Services and IT Consulting