Job Description
Role Title: Microsoft Azure ETL & Reporting Developer
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:
- 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)
Job Tags
Full time, 3 days per week,