Apply Now

Senior Database / Data Warehouse SME

Hybrid in Lansing, MI, US • Posted 2 days ago • Updated 2 days ago

Contract W2

Contract Independent

Contract Corp To Corp

12 Months

25% Travel Required

Hybrid

$55 - $60/hr

Fitment

Dice Job Match Score™

To see how well you match this job, please log in or create an account.

Once logged in, be sure to complete your profile to get the most accurate match score.

🔢 Crunching numbers...

Job Details

Skills

database
T-SQL
ETL development
PowerShell
Azure DevOps
Scrum/Agile
Microsoft SQL

Summary

Job Summary

The role will serve as the SME for the CEPI SLDS data warehouse, supporting a large SQL Server environment with multiple collection and analysis databases. The position focuses on Azure Database Services, SQL data modeling, extensive ETL development, data pipelines, database administration, performance tuning, security and migration of ETL processes from on-premises to cloud environments.

Top 3 Skills:

Azure Database Services
SQL Data Modeling / Database Structure
Extensive ETL Development

Required Experience:

12+ years overall database/data engineering experience.
8–10 years T-SQL experience.
6–8 years ETL development experience.
5 years PowerShell experience.
5 years Azure DevOps experience.
5 years Scrum/Agile experience.
Strong Microsoft SQL Server experience.
Strong logical and physical data modeling.
Data warehouse experience.
Azure database/cloud migration experience.
Data pipeline development and maintenance.
Database security and access control.
Backup, recovery and disaster recovery.
Performance tuning and database optimization.
Data analysis and reporting.
Strong troubleshooting and root-cause analysis.

Key Responsibilities:

Design, develop and maintain ETL/data pipelines.
Perform extraction, transformation and loading activities.
Develop data preparation jobs, data analysis and reporting solutions.
Troubleshoot ETL jobs and perform root-cause analysis.
Design and maintain logical and physical database models.
Develop data dictionaries and database structures.
Create and manage SQL database objects using DDL/DCL.
Perform database performance monitoring and tuning.
Manage database security and data integrity.
Develop and maintain ETL processes.
Support transition of ETL processes from on-premises to cloud servers.
Perform database backup and recovery activities.
Support disaster recovery procedures.
Coordinate database changes with application and development teams.
Work with business users to incorporate new data elements.
Support the CEPI SLDS data warehouse and CEDS standards.

Environment:

The CEPI database environment includes:

Multiple SQL Server instances
Development, QA/Testing, Pre-Release and Production environments
Multiple SQL Reporting Services servers
35+ collection databases
100+ analysis databases

Important:

Local candidates only.
Candidate must be located within 90–100 miles of Lansing, MI at the time of submission.
Must work onsite Wednesday and Thursday every week from Day 1.
Candidate must be available for a possible in-person second-round interview.
Candidate should be comfortable working independently as an SME.

Please send me your updated resume.

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.

Dice Id: nm13509
Position Id: 9136551
Posted 2 days ago

Contact the job poster

Nishant Hs

Recruiter @ COOLSOFT

View Profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Senior SQL Server / Azure Data Engineer

Hybrid in Lansing, Michigan

•

4d ago

Our client is looking for a Sr SQL Server/Azure Data Engineer to assist with the data warehouse system. This position requires considerable independent judgment directing and coordinating the appropriate data administration and management methods, practices, procedures and tools, to complete the required assignments. Expertise is required in Microsoft SQL Server database support, and professional knowledge on CEDS standard. This position is heavily involved with strategic and tactical informati

Third Party, Contract

Depends on Experience

Senior SQL Server Database Developer – Azure & ETL - Hybrid,In Person Interview, Local to MI candidates only.

Hybrid in Lansing, Michigan

•

4d ago

Title:Senior SQL Server Database Developer Azure & ETL - Hybrid,In Person Interview, Local to MI candidates only. Location:Lansing,MILength:Long termRestriction:w2 or c2cDescription:In Person Interview Very long term project; initial PO for 1 year and usually the project goes for 3-5 years with this customer HybridNeed 2-3 professional referencesLocal candidates only Job DescriptionThis position supports the Center for Educational Performance and Information (CEPI) database environment primar

Easy Apply

Contract

Depends on Experience

Senior Azure Database Engineer

Hybrid in Lansing, Michigan

•

4d ago

Job Title: Senior Azure Database Engineer Location: Lansing, MI, (Hybrid)-Onsite from day 1, two days a week. Required onsite days are Wednesdays and Thursdays Position Type: Contract Interview Mode: 1st round MS Teams & may be a 2nd round of interviews held in person Additional Requirements: References are required for this position. Please include a separate attachment with your submission that includes 2-3 professional references. Each reference should include the name, email, phone numb

Easy Apply

Contract, Third Party

$57 - $62

Direct Client: Senior SQL Server Database Architect @ Lansing, MI Hybrid Locals Only

Hybrid in Lansing, Michigan

•

3d ago

Senior SQL Server Database Architect Azure & ETL Lansing, MI Hybrid Locals Only 12 months Contract Looking for the candidates who can work without any visa sponsorship. Additional Requirements: - References are required for this position. Please include a separate attachment with your submission that includes 2-3 professional references. Each reference should include the name, email, phone number, and their position title/company name. - Interview Process: Virtual: Candidates should join

Easy Apply

Contract, Third Party

Depends on Experience

Search all similar jobs

More jobs at COOLSOFT in Lansing, MI