Apply Now

Data Warehouse Sr. ETL/BI Developer

Lansing, MI, US • Posted 1 day ago • Updated 37 minutes ago

Full Time

On-site

Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

Analytical Skill
Effective Communication
Technical Drafting
Database
Auditing
System Documentation
Project Estimation
Budget
Team Leadership
Management
Disaster Recovery
Change Management
Test Plans
Testing
Data Warehouse
Business Intelligence
Extract
Transform
Load
Data Marts
Reporting
Dashboard
Data Analysis
Marketing Intelligence
MI
SQL
Teradata
Agile
PMM
End-user Training
Physical Data Model
Translation

Summary

About the Role

Stafford Gray is seeking a senior-level Data Warehouse ETL/BI Developer to join an established data warehouse team supporting a large state government health and human services program. This is a hands-on role for someone who can develop, maintain, and enhance automated data warehouse applications on an enterprise Teradata platform, while coordinating with other data warehouse teams on complex, multi-team projects and helping shape data warehouse policies and practices going forward.
Responsibilities

Develop, maintain, and enhance data warehouse ETL processes, data marts, reporting, and dashboards
Coordinate team activities and represent the team on complex, multi-team data warehouse projects
Review existing data warehouse policies and practices, and propose modifications or new practices as needed
Meet with business users for clarification and elaboration to define problems and conceptualize development plans
Recognize, gather, correlate, and analyze facts; draw conclusions; define problems; devise solutions and recommendations
Work with data modelers and developers to translate logical designs into physical designs suited to reporting needs
Design applications considering data reconciliation to source systems, query/reporting performance, and analytical business value
Present gathered information to project review boards, project sponsors, and technical review boards as needed
Consult with client agency stakeholders to explain complex IT processes and solutions; maintain effective communication on project-level metrics and reporting
Assist architects/DBAs in drafting technical database models that comply with audit separation-of-duty requirements, capture data element requirements, and best meet application needs
Review and approve updates to systems documentation
Gather, review, and analyze potential impacts of proposed changes (legislative, enhancement requests, process changes) and communicate risk to management and client agency
Provide technical expertise in IT project estimating and budgeting
Serve as a team lead and resource, directing code development and providing guidance to other development staff
Evaluate and identify opportunities for programming process or tools standardization
Perform disaster recovery planning and implementation
Provide input to change management procedures for production system fixes
Review and approve test plans, incorporating required security levels into testing

Requirements
Required Qualifications

Bachelor's degree or equivalent technical study
6+ years creating Data Warehouse BI applications, including ETL/data mart development, reporting, dashboards, and other information analysis and delivery systems
2+ years of experience in Child Welfare Services, Juvenile Justice, Juvenile Services, or other related human services experience
Must live within 90 miles of Lansing, MI (48933) at time of submission

Preferred Qualifications

SQL Assistant / Teradata Studio experience
Ability to work independently with minimal direction
Experience with State government Agile/PMM-style project methodology
End-user training experience
Experience working with data modelers and developers on logical-to-physical design translation

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: 80184850
Position Id: 7ea6ae09040eb6af21251cfb6f813eb1
Posted 1 day ago

Create job alert

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

Hybrid in Lansing, Michigan

•

Yesterday

Data Warehouse Sr. ETL/BI Developer Lansing, MI Hybrid only preferred One Year Contract Looking for the candidates who can work without any visa sponsorship. Prescreening questions: Prescreening questions are attached, please attach the candidate's answer to these in your submission References: Manager has requested 2 professional references, please attach to submission in a separate document Interview process: Virtual, should only be 1 round, will be a mix of technical and behavioral questi

Easy Apply

Contract, Third Party

Depends on Experience

Data Warehouse Sr. ETL/BI

Lansing, Michigan

•

Today

Job Title: Senior Data Warehouse ETL/BI Developer Location: Lansing, MI Duration: 12 Months Job ID: 164528 Job Description We are seeking an experienced Senior Data Warehouse ETL/BI Developer to design, develop, maintain, and enhance enterprise data warehouse and business intelligence solutions. The ideal candidate will have strong hands-on experience with ETL development, SQL, Teradata, relational databases, data marts, reporting, dashboards, and data warehouse technologies. This individual w

Easy Apply

Full-time, Part-time, Third Party, Contract

Data Warehouse Architect

Hybrid in Lansing, Michigan

•

5d ago

We are seeking an experienced Senior Data Warehouse Architect to design, maintain, and enhance enterprise data warehouse solutions on a Teradata platform. Location: Lansing, MI (Must reside within 90 miles) Work Arrangement: Hybrid (On-site mandatory every Wed & Thu) Interview Process: Single-round virtual interview (Technical + Behavioral) Key Responsibilities & Highlights Architect and build Data Warehouse BI applications, ETL pipelines, data marts, and interactive dashb

Easy Apply

Third Party, Contract

$83 - $93

Data Warehouse Architect 5

Hybrid in Lansing, Michigan

•

Today

MDHHS - Data Warehouse Sr. ETL/BI DeveloperPosition Details The position functions as a senior information technology analyst responsible for developing, maintaining, and enhancing a variety of automated data warehouse applications located on the State of Michigan s Teradata Data Warehouse platform. The position will represent the team and coordinate team activities with other data warehouse teams on complex, multi-team projects. In addition, the position will work with other data warehouse deve

Easy Apply

Contract

Depends on Experience

Search all similar jobs

More jobs at Stafford Gray in Lansing, MI

Data Warehouse Sr. ETL/BI Developer

Dice Job Match Score™

Job Details

Skills

Summary

Similar Jobs