Microsoft Azure ETL & Reporting Developer- Onsite- Hanover, MD- Hybrid- Full time

Overview

Hybrid
Depends on Experience
Full Time
No Travel Required

Skills

power automate
azure devops
ETL

Job Details

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 and 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 effectively.

Required Skills

  • Microsoft Azure Synapse Analytics Advanced
    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.

  • Azure DevOps (Pipeline Development & Automation) Intermediate
    Experience building, configuring, and maintaining deployment pipelines for code and ETL automation.

  • Microsoft Power Automate Intermediate
    Ability to develop and implement workflow automations to streamline data and reporting processes.

  • Microsoft SQL Server (Database Objects) Advanced
    Strong skills in creating, modifying, and managing tables, views, and stored procedures, especially in lower environments.

  • ETL Job Monitoring & Troubleshooting Advanced
    Proven ability to proactively monitor, diagnose, and resolve ETL and data pipeline issues.

  • Data Quality & Process Efficiency Intermediate
    Understanding and application of best practices for data integrity and process optimization.

  • Stakeholder Collaboration & Documentation Intermediate
    Effective communication and collaboration with business and technical stakeholders; ability to document technical processes clearly.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.