Data Warehouse Developer/ Architect

This position functions as a senior information technology analyst responsible for developing, maintaining, and enhancing a variety of automated data warehouse applications on the State of Michigan’s Teradata Data Warehouse platform. The role represents the team and coordinates activities with other data warehouse teams on complex, multi-team projects. Additionally, the position works with other data warehouse developers to review, modify, or propose new data warehouse policies and practices. This role is part of the Michigan Department of Health and Human Services (DHHS) Data Warehouse Team.

Responsibilities

• Develop and maintain DHHS data warehouse ETL processes and queries using SQL and Business Intelligence tools.
• Collaborate with data warehouse developers to review and enhance existing policies and practices or propose new ones.
• Work independently with minimal direction on data warehouse BI applications, including ETL/data mart development, reporting, dashboards, and information analysis systems.
• Communicate effectively with programmers, analysts, supervisors, management, system users, operations, other State agencies, and the private sector.
• Meet with users to clarify requirements, define problems, and conceptualize development plans.
• Gather, correlate, and analyze facts; draw conclusions; define problems; and devise solutions or alternatives.
• Work with Data Modelers and developers to facilitate modifications of logical designs into physical designs suited to reporting needs.
• Design applications considering data reconciliation, query/reporting performance, and analytical business value.
• Present information to the Project Review Board, Project Sponsors, and Technical Review Board, providing clarification and answers to questions.
• Consult with agency clients to explain complex IT processes and solutions, maintaining effective communication plans regarding project metrics and reporting.
• Assist Architects or DBAs in drafting technical database models that comply with audit separation of duty requirements, capture data element requirements, and meet application needs.
• Review and approve updates to systems documentation.
• Analyze potential impacts of changes due to legislation, enhancement requests, or procedural changes, and inform management of risks.
• Provide technical expertise in IT project estimating and budgeting to DTMB AS PMO Managers and client agency managers.
• Serve as a team lead, 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 procedures and ensure proper change management for production system fixes.
• Review and approve test plans, incorporating all levels of security identified as system requirements.

Requirements

• Bachelor’s degree or equivalent technical study.
• 6+ years of experience creating Data Warehouse BI applications, including ETL/data mart development, reporting, dashboards, and information analysis systems.
• 2+ years of experience in Child Welfare Services, Juvenile Justice, Juvenile services, or related fields.

Skills

• Required: Proficiency in SQL and Business Intelligence tools; experience with relational databases.
• Preferred: Experience with SQL Assistant/Teradata Studio.
• Desired:
  • Experience with State of Michigan PMM/SUITE/Agile methodology.
  • End-user training experience.
  • Strong verbal and written communication skills.
  • Ability to work with Data Modelers and developers to design physical database structures.
  • Experience in disaster recovery planning and change management.

Benefits

• Long-term stability with multi-year opportunities and room for growth.
• Comprehensive health coverage for you and your family.
• 401(k) program for financial security.
• Green Card assistance for immediate processing, if required.