Zenfreed

16 jobs near Columbus, OH

Will need to be onsite from day 1, two days a week. (Monday/Tuesday) About Zenfreed At Zenfreed, we are more than an IT company. We bridge the gap between people wanting to do the work they were ...

Will need to be onsite from day 1, two days a week. (Required onsite days are currently Tuesdays and Wednesdays but this is subject to change.) About Zenfreed At Zenfreed, we are more than an IT ...

Business Analyst

Lansing, MI · On-site

$51 - $64/hr

About Zenfreed At Zenfreed, we are more than an IT company. We bridge the gap between people wanting to do the work they were meant to do and organizations needing the right talent. We are dedicated ...

About Zenfreed At Zenfreed, we are more than an IT company. We bridge the gap between people wanting to do the work they were meant to do and organizations needing the right talent. We are dedicated ...

This position is for a Senior Project Manager (PM3) to assist the State of Michigan Project Management Office supporting Michigan Department of Treasury with a multi-year high priority project. This ...

The Michigan Department of Education (MDE) is seeking a Senior Business Analyst to support the Office of Educational Supports (OES) in enhancing and maintaining the Consolidated Application within ...

Business Process Reengineering

Lansing, MI · On-site

$61K - $83K/yr

The Michigan Department of Education (MDE) is seeking a Senior Business Process Reengineer to support the Office of Educational Supports (OES) in enhancing and maintaining the Consolidated ...

This position functions as a Salesforce Application Architect within the Michigan Department of Health and Human Services (MDHHS), supporting the modernization and ongoing operations of critical ...

Will need to be onsite from day 1, two days a week. (Tuesday/Wednesday) About Zenfreed At Zenfreed, we are more than an IT company. We bridge the gap between people wanting to do the work they were ...

The ETL Developer is responsible for designing, developing, and maintaining high-quality data integration solutions using IBM DataStage and related technologies. This role supports both on-premise ...

The state maintains an enterprise data warehouse built on the Teradata ecosystem. The Enterprise Data Warehouse (EDW) service offered by DTMB provides customers with the ability to conduct high ...

This position is the recognized resource responsible for the development of radio programming files for distribution and installation into Michigan Public Safety Communications System (MPSCS) radios ...

This position is for a Senior Project Manager (PM3) to assist the State of Michigan Project Management Office supporting Michigan Department of Treasury with a multi-year high priority project. This ...

... Zenfreed, we are more than an IT company. We bridge the gap between people wanting to do the work they were meant to do and organizations needing the right talent. We are dedicated to building a ...

Data Warehouse Architect

Zenfreed, LLC

Lansing, MI

$66 - $82/hr

Full-time

Medical, Dental, Vision

Posted 17 days ago


Job description

The ETL Developer is responsible for designing, developing, and maintaining high-quality data integration solutions using IBM DataStage and related technologies.
This role supports both on-premise and cloud environments, contributes to enterprise data modernization efforts, and plays a key role in migrating DataStage workloads to IBM Cloud Pak for Data (CP4D). The developer will collaborate with technical and business teams to deliver reliable, scalable, and secure data pipelines aligned with organizational objectives

Job Duties
  • Develop, enhance, and optimize ETL pipelines using IBM DataStage, including parallel and server jobs, job sequencing, and performance tuning.
  • Support the migration of on-premise DataStage jobs to IBM Cloud Pak for Data (CP4D), including code refactoring, testing, validation, and workflow modernization.
  • Use Python and XML to automate processes, perform data transformations, and integrate automation into ETL workflows.
  • Work extensively in Linux/Unix environments to write shell scripts, manage file systems, monitor processes, and troubleshoot runtime issues.
  • Apply Master Data Management (MDM) principles to ensure data quality, governance, and consistency across enterprise systems.
  • Develop complex SQL queries for data extraction, transformation, validation, and performance improvement across relational database platforms.
  • Work within Agile teams to support sprint activities, deployments, documentation, and continuous improvement practices.
  • Collaborate with data architects, analysts, DBAs, and business users to ensure successful and accurate delivery of data solutions.
  • Troubleshoot ETL issues, perform root-cause analysis, recommend improvements, and ensure adherence to data standards and security policies.



Requirements
5+ years:
  • Experience ETL (IBM DataStage)
  • Experience with Unix/Linux
3+ years:
  • Experience with Master Data Management
1+ years:
  • Exposure to Cloud Pak for data

Desired Skills
  • Previous Government experience
Minimum Education
  • None

Location
  • Local candidates ONLY candidates must be located in Michigan at time of submission
  • Position is a hybrid schedule with NO REMOTE ONLY OPTION. Will need to be onsite from day 1, two days a week. (Monday/Tuesday)
  • Working hours Monday-Friday, approximately 8:00 a.m. to 5:00 p.m.
Additional Requirements
  • Must be authorized to work in the United States; We are unable to offer sponsorships at this time
  • Must undergo a background check and drug screening for employment.

Employment Terms
  • This is a W2 position
  • 40 hrs per week
  • HYBRID schedule - NO REMOTE ONLY OPTION. Will need to be onsite from day 1, two days a week. (Monday/Tuesday)

About Zenfreed

At Zenfreed, we are more than an IT company. We bridge the gap between people wanting to do the work they were meant to do and organizations needing the right talent.

We are dedicated to building a diverse, inclusive and authentic workplace, so if you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for this or other roles.



Benefits
We understand a comprehensive benefits package is crucial to employment satisfaction. We offer medical, dental and vision coverage options for all employees.