Description

You will own the design and development of data warehouse and BI applications, bridging ETL development with business intelligence reporting.

This role is on-site.

Responsibilities

• Develop and maintain ETL processes, data marts, and reporting dashboards using SQL and Snowflake.
• Collaborate with data modelers to translate logical designs into physical database structures optimized for reporting performance.
• Consult with agency clients to define problems, conceptualize development plans, and explain complex IT solutions.
• Lead code development efforts, providing technical guidance and reviewing test plans for security and quality.
• Evaluate and implement changes to IT solutions based on legislative updates, enhancement requests, and process changes.

Required Skills

• 6+ years of experience creating Data Warehouse BI applications, including ETL/data mart development.
• Strong proficiency in SQL and experience with BI applications.
• Hands-on experience with Snowflake and Databricks.
• Familiarity with SQL Assistant/Teradata Studio.
• Experience with Agile methodology and State of Michigan PMM/SUITE.
• Ability to work independently and communicate effectively with programmers, analysts, and management.
• Bachelor’s degree or equivalent technical study.

Preferred Skills

• 2+ years of experience in Child Welfare Services, Juvenile Justice, or related public sector domains.
• Experience providing end-user training and facilitating project review board presentations.

Key Skills

Education

Bachelor's degree