More jobs:
Data Warehouse Sr. ETL/BI Developer
Job in
Lansing, Ingham County, Michigan, 48900, USA
Listed on 2026-08-17
Listing for:
Stafford Gray
Full Time
position Listed on 2026-08-17
Job specializations:
-
IT/Tech
Data Warehousing, Data Engineering, Data Analyst
Job Description & How to Apply Below
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
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
- 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
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×