Senior SQL ETL Data Warehouse DBA - Azure Hybrid

Zenfreed, LLC; Town of Lansing (NY); Hybrid; USD 120,000 - 160,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

Hybrid work model

Job summary

Zenfreed, LLC is hiring a Subject Matter Expert for CEPI SLDS data warehouse in Lansing, MI. The role focuses on data architecture, ETL modernization, and security-conscious data modeling across on-prem and cloud transitions.

Responsibilities include designing pipelines, optimizing databases, and guiding development teams to deliver accurate data assets with robust governance and testing.

Qualifications

• Top 3 skills needed: Azure Database services, SQL Data Modeling/structure, Extensive ETL development experience.
• 8-10 years: T-SQL expertise and SQL scripting capabilities.
• 5 years: PowerShell scripting experience and Agile/Scrum familiarity.
• Bachelor's Degree is required.

Responsibilities

• Designs, implements, and expands data pipelines with ETL processes.
• Prepare data, analyze, and generate data reports; troubleshoot ETL issues.
• Collaborate with developers and stakeholders to deliver high-quality data.
• Manage data analysis, dictionaries, models, and performance tuning.
• Know data storage tools and production utilities for data management.
• Coordinate physical DB changes; code, test, and implement DB objects.
• Set physical DB parameters; use SQL for DDL and DCL access control.
• Test, fix errors, and refine database changes.
• Enter SQL to create production databases and monitor performance.
• Direct programmers/analysts on DB changes and reviews.
• Assess user requests for new data elements and systems.
• Ensure data integrity and load/reorganize data as needed.
• Perform data modeling and prototyping; develop ETLs.
• Create logical/physical data models from requirements.
• Follow security recovery procedures and DR planning.

Skills

Azure DB services

SQL data modeling

ETL development

Education

Bachelor's Degree

Tools

SQL Server

SSRS

PowerShell

Job description

Zenfreed, LLC is hiring a Subject Matter Expert for CEPI SLDS data warehouse in Lansing, MI. The role focuses on data architecture, ETL modernization, and security-conscious data modeling across on-prem and cloud transitions.

Responsibilities include designing pipelines, optimizing databases, and guiding development teams to deliver accurate data assets with robust governance and testing.