Senior Lead ETL Developer

Senior Lead ETL Developer

Lansing Michigan 48933

Assignment duration: Initial 6-month contract with a possibility of extension

Interview Process: In-person interview at 400 S Pine St, Lansing, MI with the management team

Hybrid Work Schedule

Required onsite days- Mondays and Tuesdays

Remote eligible days- Wednesdays, Thursdays, and Fridays

The resource must meet these requirements from the beginning

Candidates must be local to the Lansing, Michigan area (within 120 miles) at time of submission. This requirement is non-negotiable

References are required with your submission that includes 2-3 professional references. Each reference should include the name, email, phone number, and their position title/company name.

Top Skills & Years of Experience:

• 5+ years of hands-on experience with IBM Cloud Pak for Data

• 5+ years of hands-on experience with IBM Knowledge Catalog, including enabling and supporting the migration of existing IBM DataStage workloads to Cloud Pak for Data

• 5+ years of hands-on experience with IBM Manta

• Experience defining and enforcing data architecture standards, patterns, and best practices

• Ability to translate business requirements into scalable data architecture solutions

• Experience working in large, complex, enterprise environments with multiple data sources

• Strong understanding of data quality, data consistency, and data lifecycle management

• Excellent communication skills, with the ability to collaborate across business, analytics, and IT teams

Job Responsibilities:

This position will serve as an ETL Developer responsible for supporting Master Data

Management (MDM) initiatives and the Information Services environments for the State of

Michigan enterprise and the Center for Shared Solutions.

The position develops Information Services needs as well as evaluating, recommending and

supporting technological solutions and Data Management architecture and software. They work

closely with agency customers and IT teams to turn data into critical information and knowledge

that can be used to make sound business decisions. It is essential that the ETL developer build

an understanding of the business at a level of detail that enables them to identify and address

critical business issues. They manage data that is accurate, congruent and reliable, and ensure

the information is easily available to users for direct consumption or integration with other

systems.

The ETL developer educates and trains clients to use the data as an analytical tool, displaying

the information in new forms and content for the purpose of analysis and option exploration. The

ETL developer works with clients to determine business requirements, priorities, define key

performance indicators (KPI), and develop Data Warehouse (DW) and Data Management

strategy.

This includes working with business and IT development teams to design and implement

enterprise data lakes, data marts, data warehouses and design and implement dashboards,

alerts, and business analytics solutions and reports.

Required Qualifications:

• 5+ years of hands ‑ on experience with IBM Cloud Pak for Data

• 5+ years of hands ‑ on experience with IBM Knowledge Catalog, including enabling and

supporting the migration of existing IBM DataStage workloads to Cloud Pak for Data

• 5+ years of hands ‑ on experience with IBM Manta

• Experience defining and enforcing data architecture standards, patterns, and best

practices

• Ability to translate business requirements into scalable data architecture solutions

• Experience working in large, complex, enterprise environments with multiple data

sources

• Strong understanding of data quality, data consistency, and data lifecycle management

• Excellent communication skills, with the ability to collaborate across business, analytics,

and IT teams

Preferred Qualifications

• • Previous State of Michigan experience