Senior SQL DBA & Data Warehouse Architect — Hybrid (Lansing)

Zenfreed, LLC; Lansing (MI); Sur place; USD 120 000 - 170 000; Plein temps

Résumé du poste

Zenfreed, LLC is seeking a Subject Matter Expert for CEPI SLDS data warehouse modernization. The role focuses on data administration, data modeling, and ETL processes using Microsoft SQL Server across development, QA, pre-release, and production environments.

You will lead design and implementation of data pipelines, ensure data integrity, and guide architectural standards. Onsite hybrid work in Lansing, MI with mandatory in-person days and security checks as part of the role.

Qualifications

• Top 3 skills needed: Azure Database services, SQL Data Modeling/structure, Extensive ETL development experience.
• Bachelor's Degree required with extensive data/BI background.
• 12+ years of experience in data engineering or related fields is preferred.

Responsabilités

• Designs, implements, and expands data pipelines with ETL activities.
• Prepares data, performs analysis, and generates data reports; troubleshoots ETL issues.
• Collaborates with developers, business teams to ensure high-quality data and provide support.
• Oversees data analysis, dictionaries, data models, and performance tuning.
• Coordinates physical changes to databases; codes, tests, and implements database objects.
• Ensures data integrity and supports ETL development lifecycle across environments.

Connaissances

Azure Database services

SQL Data Modeling/structure

ETL development

Formation

Bachelor's Degree

Outils

T-SQL

PowerShell

SQL Server

Scrum

Description du poste

Zenfreed, LLC is seeking a Subject Matter Expert for CEPI SLDS data warehouse modernization. The role focuses on data administration, data modeling, and ETL processes using Microsoft SQL Server across development, QA, pre-release, and production environments.

You will lead design and implementation of data pipelines, ensure data integrity, and guide architectural standards. Onsite hybrid work in Lansing, MI with mandatory in-person days and security checks as part of the role.