Job Details

PSR Associates is a consulting and talent solutions firm that connects qualified IT professionals with great opportunities. Whether you're looking for a contract or permanent position, we can help you find the right fit for your skills and experience. We have a team of experienced recruiters whoknow the IT industry inside and out, and we work with you every step of the way to ensure a smooth and successful transition. PSR Connecting Talent, Crafting Success.

Data Warehouse Architect (ETL Developer)

We are seeking a Data Warehouse Architect (ETL Developer) to join our team . The selected candidate will work a hybrid schedule consisting of two (2) days onsite each week (Mondays and Tuesdays) in Lansing, MI, and three (3) days remotely.

Job Responsibilities:

This position will serve as an ETL Developer responsible for supporting Master Data Management (MDM) initiatives and the Information Services environments.

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

• Previous State of Michigan experience