Description

This role involves designing and building data warehouse and BI solutions.

Responsibilities

• Develop Data Warehouse and BI applications, including ETL and data mart creation.
• Design applications considering data reconciliation, query performance, and analytical value.
• Lead code development, advising and guiding other development staff as a team resource.
• Gather, review, and analyze potential impacts of system changes and report risks to management.
• Perform disaster recovery planning and ensure proper change management for production fixes.

Required Skills

• 6+ years creating Data Warehouse BI applications, including ETL/data mart development.
• Proficiency in Snowflake and Databricks.
• Strong SQL experience.
• Experience with Agile methodology.
• Ability to work cross-functionally between ETL and BI tasks.
• Bachelor's degree or equivalent technical study.
• 2+ years experience in Child Welfare Services, Juvenile Justice, or related services.
• Experience with Data Modeling and facilitating logical to physical design conversion.
• Ability to meet with users to define problems and conceptualize development plans.

Preferred Skills

• Experience with State of Michigan PMM/SUITE.
• End-user training experience.

Key Skills

Education

Bachelor's degree