(ETL,SQL with Teradata)Programmer Analyst 6--Hybrid

110539---Lansing, MI - IT - DTMB - Agency Services - DHHS - (ETL,SQL with Teradata)Programmer Analyst 6

Position: (ETL,SQL with Teradata)Programmer Analyst 6

Location: Lansing, MI

Interview Process: Virtual Interview via MS Teams video. Please use a laptop and be prepared to share a screen if asked. Use of headphones is strongly discouraged. A screenshot photo of the candidate will be required for any Teams interviews as well as a vendor present at the beginning of interview to validate the candidate.
Duration: 1 year with possible extension.
Remote or On-site: Candidates MUST be local. Will need to be onsite starting day 1 for hybrid work schedule. NO REMOTE ONLY OPTION.

JOB DESCRIPTION:

DTMB DHHS

Programmer Analyst 6

Candidates in this position will perform application development tasks in support of building business intelligence (BI) applications and with the integration of data warehouse resources into other MDHHS applications. In addition, this candidate will provide database expertise to other application developers in close collaboration with analysts, database administrators (DBAs), and other data management staff. This will include tasks such as:

- Create data warehouse-based applications include reports, dashboards, and other information analysis and delivery systems.

- Extract, transform, and load (ETL) systems to move data from various operational systems in which it is collected to a cleansed and consolidated data warehouse.

- SQL development.

- Work with data warehouse analysts, developers, and end user query developers to design and optimize database queries.

- Train other analysts and developers in how to write efficient queries and develop Business Objects reports.

- Candidates for this position will be expected to work with agency requestors to define and develop new queries and provide training and technical support to DTMB analysts and developers and end user query developers. These tasks may include:

o Work with end user requestors to understand their data needs and create and implement technology solutions to those meet those needs.

o Develop and present training classes for end user developers to help learn how to effectively use the data warehouse platform and the BI tools available to support their own data needs.

o Develop and present training classes for DTMB analysts and developers to help them better understand how to use the BI development tools to create and implement solutions using the data warehouse.

o Provide one on one support for developers and end users to assist them in accomplishing their data reporting needs.

Required skills:

- Teradata Utilities Experience

- ETL (Extract, Transform, and Load) Experience

- SQL (Structured Query Language) Assistant Experience

- Teradata Version 13 or 14 Experience

- PL/SQL Experience

- SQL and Performance Tuning Training

- Business Objects Report Development Experience

- Business Analyst Experience

- Public Assistance Eligibility and Benefit Determination knowledge

CLIENT SKILL MATRIX:

Top Skills Candidate Years of Experience:

- Teradata Utilities Experience
- ETL (Extract, Transform, and Load) Experience
- SQL (Structured Query Language) Assistant Experience
- Teradata Version 13 or 14 Experience
- PL/SQL Experience

Skills : - Teradata Utilities Experience - ETL (Extract,Transform