Apply on Employer Site

State of Michigan · 21 hours ago

ITPA12 - Data Warehouse ETL Developer

Lansing, MI

Full-time

Hybrid

Mid, Senior Level

2+ years exp

The State of Michigan's Department of Technology, Management and Budget supports various state agency operations. They are seeking a Senior Information Technology Analyst to develop and enhance automated data warehouse ETL applications, coordinate team activities, and master relevant business practices.

GovernmentOffice AdministrationSocial Media

No H1B

Responsibilities

Developing, maintaining and enhancing a variety of automated data warehouse ETL applications located on the State of Michigan’s Teradata Data Warehouse platform

Represent the team and coordinate team activities with other data warehouse teams on complex, multi-team projects

Coordinate and develop test plans and strategies for various types (i.e. integration, system, user acceptance)

Master knowledge of the business practices, workflows, performance indicators, and predictive factors related to Eligibility areas of MDHHS to best serve our customers

Coordinate other testing resources to execute the approved plans, testing approach and testing scripts during a release phase

Work with other data warehouse developers to review existing data warehouse policies and practices, modify work items as needed, or propose new ones

Qualification

Data Warehouse ETLTeradataPERLPythonUnix ScriptingAzure DevOpsAgile ProgrammingTesting CoordinationBusiness KnowledgeTeam Collaboration

Required

Possession of a Bachelor's degree with 21 semester (32 term) credits in one or a combination of the following: computer science, data processing, computer information systems, data communications, networking, systems analysis, computer programming, information assurance, IT project management or mathematics

Two years of professional experience equivalent to an Information Technology Infrastructure or Programmer/Analyst P11

Possession of an associate's degree with 16 semester (24 term) credits in computer science, information assurance, data processing, computer information, data communications, networking, systems analysis, computer programming, IT project management, or mathematics and two years of experience as an application programmer, computer operator, or information technology technician; or two years (4,160 hours) of experience as an Information Technology Student Assistant may be substituted for the education requirement

Educational level typically acquired through completion of high school and four years of experience as an application programmer, computer operator, information technology technician, or four years (8,320 hours) of experience as an Information Technology Student Assistant may be substituted for the education requirement

Relevant experience and/or education referred to in the supplemental questions must be documented in the resume, transcript and/or application to allow for accurate screening

Attach a resume identifying specific experience and dates of employment. Dates of employment should include month and year and hours per week

Attach a cover letter

If applicable, attach a copy of an official transcript(s). We accept scanned copies of official transcripts. We do not accept web-based, internet, or copies of unofficial transcripts. Official transcripts provide the name of the institution, confirmation that a degree was awarded and on what date, and the registrar's signature

In accordance with federal law, all new employees must provide proof of eligibility to work in the United States within three business days of beginning employment. If selected for employment, you must be able to submit proof of your legal right to work in the United States