Senior Database Developer

We are seeking a Senior Database Developer with expertise in SQL Server development, ETL processes, and database optimization. The ideal candidate will have strong experience in data modeling and automated deployment processes.

Key Responsibilities

Design and develop SQL Server components including stored procedures, functions, views, and triggers to support ETL processes and overall database functionality

Create and maintain comprehensive data models and database designs, with a focus on performance optimization and efficiency

Implement automated database deployments using Azure CI/CD pipelines and DACPAC

Develop and maintain SSIS packages for ETL processes, ensuring optimal performance and reliability

Create automated validation scripts for data quality assurance in target facts and dimensions

Implement comprehensive audit tracking systems to monitor all phases of the ETL process

Develop and maintain detailed documentation of ETL processes, including process flow diagrams

Collaborate with business users, team members, and other developers to resolve data integration issues and improve system functionality

Technical Skills Required

SQL Server Development

ETL Process Design

SSIS Package Development

DACPAC Implementation

Data Modeling

Database Design

Process Documentation

Requirements

Extensive experience in database development and optimization

Proficiency in SQL Server and related technologies

Strong understanding of ETL processes and best practices

#J-18808-Ljbffr