Data integration Architect with IBM StreamSets and Salesforce

Job Description

LOCAL OHIO CANDIDATES

State of Ohio- Data Integration Architect with IBM StreamSets and Salesforce - 797734

100% REMOTE must report on-site for 1st day at Columbus, Ohio 43215

Interviews will be via Teams

The Technical Specialist 4 (TS4) contract resource will design and implement Agency data engineering solutions, including data platform evaluation, selection recommendations, data modeling, and enterprise data architecture development. This position will serve as a senior technical contributor responsible for shaping and advancing the Agencys data ecosystem through scalable, secure, and well-governed data design practices.

The TS4 will make technical decisions affecting configuration and implementation of data analytics environments, data platforms, integration systems, and environment-specific data storage solutions. The position will collaborate with IT Architecture staff, the Agency CIO, and IT Managers to design data solutions aligned with agency business needs, enterprise standards, and long-term architectural direction. The TS4 will assist in evaluating solution designs, contributing to business case analysis, and recommending IT architecture improvements.

This role will serve as a significant contributor to the Agencys data modeling and data architecture practices, including:

Designing and maintaining conceptual, logical, and physical data models supporting enterprise analytics and operational systems

Establishing and promoting data modeling standards, naming conventions, and design patterns

Contributing to the development and evolution of the Agencys enterprise data architecture roadmap

Supporting domain-driven and scalable data design approaches aligned with enterprise data platforms and data governance objectives

Providing architectural guidance to ensure data solutions are reusable, interoperable, and aligned with enterprise integration strategies

The TS4 will recommend technical strategy by defining tasks and leading technical discussions related to design, implementation, operation, optimization, and ongoing maintenance of data systems. The position will work closely with Enterprise partners to determine and configure integrations between agency systems and enterprise data lake, data quality, and data curation platforms.

It is critical that this position possess at least five (5) years of proven experience related to data integration, data cleansing, data classification, and data modeling. The TS4 will provide technical leadership and guidance to DODDs Data Management team by designing and implementing best-practice solutions for integrating agency and enterprise data platform environments.

Required Skills:

Experience with Salesforce platforms

Experience with Microsoft Environments including Azure and Dynamics

Experience with StreamSets data integration pipelines

Experience with Snowflake data platform

Experience with Tableau analytics integration

This is a remote position.

Full-time

Fully remote