Data Warehouse Architect (Hybrid- Lansing, MI) || Locals Preferred

DMS Vision•Frisco, AL

1d•Hybrid

About The Position

The Data Warehouse Architect supports the Child Welfare Data Warehouse team in developing federal reporting, ad hoc reporting, ETL processes, and Business Objects reports that support the application, including NYTD, AFCARS, and NCANDS. The role also supports other projects requiring ETL to help the Department and end users access data and work productively. The architect works with State and contract staff and operational SACWIS/CCWIS system developers to ensure the operational database supports the data needs of the Child Welfare Data Warehouse and enables regular data extraction. The role designs and loads warehouse database models to support DHHS reporting and analytics, and adapts warehouse resources as the operational system evolves. It also helps State and contract staff understand decisions and impacts related to warehouse models so they can support and extend them by the end of the contract. The position performs application development for business intelligence applications and integrates warehouse resources into other DHHS applications. Responsibilities include building reporting, dashboards, analysis, visualization, and data-delivery solutions; developing ETL systems that move data from operational systems into a cleansed, consolidated warehouse; and collaborating with DBAs, data management staff, federal reporting team members, and end-user query developers. The architect works with agency requesters to define data needs and implement query solutions, provides technical support, and develops and presents training on Teradata and BI development tools. The role also provides one-on-one assistance to developers and end users with federal data reporting needs. The environment includes Teradata Cloud version 17.20 on a shared platform with other State of Michigan departments, and Business Objects XI 4.2 SP4 on a Windows 2012 virtual platform. The role is hybrid in Lansing, Michigan, with two days per week onsite. The stated duration is six or more months.

Requirements

Bachelor's degree required.
At least 3 years of experience with Teradata Cloud.
At least 3 years of experience with Business Objects XI and/or Power BI.
At least 3 years of experience performing ETL processes.

Responsibilities

Coordinate with State and contract staff and operational SACWIS/CCWIS developers to ensure the operational database supports Child Welfare Data Warehouse needs and regular data extraction.
Design and load the Child Welfare Data Warehouse database model to support DHHS reporting and analytics.
Make changes to the Child Welfare Data Warehouse as the operational SACWIS/CCWIS system evolves.
Ensure State and contract staff understand decisions and impacts related to supporting and enhancing DHHS Data Warehouse models, and can support and extend those models.
Develop business intelligence applications and integrate data warehouse resources into other DHHS applications.
Create warehouse-based reporting, dashboards, information analysis, visualizations, and delivery systems.
Build ETL systems to move data from operational systems into a cleansed, consolidated data warehouse.
Collaborate with federal reporting team members and end-user query developers to design and improve database queries.
Work with agency requesters to define data needs and develop and implement query solutions.
Provide training and technical support to DTMB developers and end-user query developers.
Develop and present training classes on using Teradata and BI development tools to create reporting solutions.
Provide one-on-one assistance to developers and end users with federal data reporting needs.
Provide database expertise to application developers in collaboration with DBAs and other data management staff.