Stellar Professionals LLC
Stellar Professionals LLC

Data Warehouse Architect

Lansing, MI, US • Posted 5 hours ago • Updated 37 minutes ago
Contract Independent
Contract Corp To Corp
Contract W2
On-site
Company Branding Image
Fitment

Dice Job Match Score™

👤 Reviewing your profile...

Job Details

Skills

  • SQL
  • Architect
  • MDM
  • Data warehouse
  • Unix/Linux
  • ETL Development
  • IBM DataStage
  • Master Data Management
  • IBM Cloud Pak for Data (CP4D)
  • ETL Migration

Summary

We are seeking a senior-level Data Warehouse Architect / ETL Developer to spearhead a critical enterprise data modernization initiative. This contract role focuses on migrating mission-critical data pipelines from on-premise IBM DataStage to IBM Cloud Pak for Data (CP4D).

The ideal candidate will combine deep expertise in ETL architecture, parallel processing, and Linux environments with recent hands-on exposure to cloud data platforms to deliver reliable, secure, and scalable data solutions.

Location & Work Arrangement

  • City, State: Lansing, MI
  • Work Arrangement: Hybrid (Onsite 2 days per week from Day 1: Monday/Tuesday. No fully remote option).
  • Requirement: Local Michigan candidates only (Must reside in MI at the time of submission).
  • Interview Mode: In-Person Only (Interviews scheduled for July 20th and 21st).
  • Shift: EST.

Key Responsibilities

ETL Architecture & Migration

  • Design, enhance, and optimize complex ETL pipelines using IBM DataStage (parallel/server jobs and job sequencing).
  • Support the modernization and migration of on-premise jobs into IBM Cloud Pak for Data (CP4D), including code refactoring and validation.
  • Apply Master Data Management (MDM) principles to guarantee data quality, governance, and consistency across systems.

Automation & Environment Management

  • Write Unix/Linux shell scripts to manage file systems, monitor background processes, and troubleshoot runtime issues.
  • Utilize Python and XML to build automation into data transformations and end-to-end workflows.
  • Develop complex SQL queries for efficient data extraction, validation, and performance tuning across relational databases.

Collaboration & Delivery

  • Work closely with Data Architects, DBAs, and analysts within an Agile framework to support sprints and code deployments.
  • Perform root-cause analysis on pipeline failures and ensure absolute compliance with data security standards.

Required Skills & Experience

Skill Category

Requirement

Years of Exp.

ETL Development

Advanced pipeline design and tuning using IBM DataStage.

5+ Years

Cloud Platform

Direct exposure to IBM Cloud Pak for Data (CP4D).

1+ Year

OS & Scripting

Infrastructure management within Unix / Linux environments.

5+ Years

Data Governance

Core experience with Master Data Management (MDM).

3+ Years

Preferred Qualifications

  • Public Sector: Prior experience working within local, state, or federal government agencies.
  • Modern Tooling: Hands-on experience refactoring legacy data sequences into modern cloud workflows.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91138038
  • Position Id: 2026-11765
  • Posted 5 hours ago

Company Info

About Stellar Professionals LLC

Stellar Professionals LLC stands out in the industry, offering a distinctive fusion of over 15 years of seasoned Staffing professionals and a vibrant community of over 150,000 LinkedIn followers. Our AGILE Staffing services are tailored to assist businesses in finding the ideal talent for their projects. In contrast, our Client Acquisition Services are focused on securing more public/private sector projects. Our disruptive approach to staffing and business consulting, encapsulated in our motto 'Agility and Excellence,' truly sets us apart. Contact us today to explore how we can transform your business. Stellar Professionals has a proven track record of success, offering comprehensive capabilities and profound industry knowledge to help you tackle your organization's most intricate issues.

Since our establishment, we have consistently broadened our client base, with a burgeoning roster of returning and new clients each year. This steady expansion is a testament to the value and caliber of our services, instilling unwavering confidence in our potential clients. ​ Many remarkable people want to do something significant but different. With over 15 years of experience in the Talent Acquisition and Staffing industry, we found that Staffing agencies spend a lot of money on Business Development and recruitment activities with low ROI. Therefore, we at Stellar Professionals LLC develop an innovative, cost-effective solution to help you build great Business partnerships and increase revenue.

Stellar Professionals LLC is currently accepting resumes for a variety of positions. Please review the database of positions that we are seeking to fill and contact us for additional information about any specific opportunity.

About_Company_OneAbout_Company_Two
Go to company profile
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Senior Teradata Platform Administrator / Data Warehouse Architect

Lansing, Michigan

•

Today

Easy Apply

Contract, Third Party

Senior IBM MDM & Integration Support Developer

Lansing, Michigan

•

Today

Easy Apply

Third Party, Contract

Search all similar jobs
More jobs at Stellar Professionals LLC in Lansing, MI