Data Integration Specialist

Council on Aging (COA); Ohio; Remote; USD 75,000 - 105,000; Full time

Job summary

A leading organization in the field of aging services is seeking a Data Integration Specialist to enhance data sharing with external partners while ensuring compliance with healthcare standards. This remote role, which requires candidates to reside in Ohio, Kentucky, or Indiana, focuses on seamless data integration and collaboration with various healthcare entities. Ideal candidates will possess robust SQL skills and familiarity with interoperability in healthcare. Join COA to make a difference while enjoying professional growth opportunities.

Benefits

Flexible hours

Professional development opportunities

Health, dental and vision care

10 paid holidays plus 2 floating holidays

Generous paid time off

Pension plan with company contribution

Pet Insurance

Employee assistance program

Qualifications

• 3+ years of experience in data integration or ETL roles.
• Experience in healthcare IT is a plus.
• Familiarity with secure file transfer protocols.

Responsibilities

• Design and maintain data pipelines using SFTP.
• Collaborate with MCOs to align data formats.
• Document integration workflows and compliance processes.

Skills

SQL

Data integration

Health data standards (FHIR, HL7)

Communication

Education

Bachelor’s degree in Information Systems or Computer Science

Tools

Microsoft Dynamics CRM

SQL Server

Job description

3 days ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

Pay found in job post

Retrieved from the description.

Base pay range

$75,000.00/yr - $105,000.00/yr

Status: Full-time (37.5 hours/week)

Pay Range: $75,000 - $105,000

Work Location: Remote but must live in Ohio, Kentucky, or Indiana and have the ability to travel within the state of Ohio up to 10%.

Job Summary:

The Data Integration Specialist plays a critical role in supporting the secure and accurate exchange of data between our Microsoft Dynamics CRM system and external partners, including Managed Care Organizations (MCOs) and the Ohio Department of Medicaid. This position is part of a statewide initiative to streamline data sharing across Area Agencies on Aging and ensure compliance with healthcare data standards.

The ideal candidate will have strong SQL and data integration skills, experience with SFTP-based file transfers, and a working knowledge of healthcare interoperability standards such as FHIR and HL7. This role requires excellent communication skills, as it involves collaboration with both internal teams and external healthcare partners.

Essential Functions:

Data Integration and Operations

• Design, implement, and maintain data pipelines from Microsoft Dynamics CRM (SQL Server) to external partners using secure file transfer protocols (SFTP).
• Develop and optimize SQL queries for data extraction, transformation, and validation.
• Automate file generation and delivery processes to support recurring data exchanges.
• Ensure data accuracy, integrity, and compliance with healthcare data standards.
  
  
  

Healthcare Interoperability and Compliance

• Collaborate with MCOs and state agencies to align data formats and exchange protocols.
• Interpret and map data to healthcare standards such as FHIR and HL7 v2/v3.
• Support compliance with Medicaid and HIPAA requirements in all data exchange processes.
  
  
  

Project and Stakeholder Coordination

• Participate in planning and rollout meetings with internal teams, MCOs, and state partners.
• Document integration workflows, data mappings, and interface specifications.
• Track project milestones and support cross-functional communication.
  
  
  

Technical Documentation and Support

• Maintain clear, up-to-date documentation for all integration processes.
• Assist in creating SOPs, data dictionaries, and compliance documentation.
• Provide technical support for integration-related issues and enhancements.
  
  
  

Required Education, Licensing & Certifications:

• Bachelor’s degree in Information Systems, Computer Science, or Associate’s degree and equivalent experience.
  
  
  

Experience:

• 3+ years of experience in data integration, ETL, or database development roles.
• Experience in healthcare IT or the public sector is a plus.
• Familiarity with Microsoft Dynamics CRM data structures (direct experience preferred).
• Experience with secure file transfer protocols (SFTP, FTPS) and batch data processing.
  
  
  

Skills & Abilities:

• Strong proficiency in SQL Server (T-SQL, stored procedure, views).
• Knowledge of HIPAA, CMS interoperability rules, or other healthcare compliance frameworks.
• Understanding of healthcare data standards such as FHIR and HL7 v2/v3.
• Excellent communication and documentation skills.
• Ability to manage multiple priorities in a collaborative, fast-paced environment.
  
  
  

Benefits:

• Flexible hours
• Opportunities for professional development
• Opportunities to advocate and participate in community events for the older adult and disabled population
• Business casual work environment
• Health, dental and vision care
• Health savings account
• 10 paid holidays, plus 2 floating holidays
• Generous paid time off
• Pension plan with annual 6% company contribution
• Pet Insurance
• Employee assistance program
• More!
  
  
  

Council on Aging is proud to be an equal opportunity employer. Council on Aging considers qualified applicants without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

APPLY NOW!

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Individual and Family Services

Referrals increase your chances of interviewing at Council on Aging (COA) by 2x

Cleveland, OH $120,000 - $240,000 16 hours ago

Contract Senior Quality Analyst - Data Migration

Virginia, OH $53,100 - $106,300 1 month ago

Cincinnati, OH $100,000 - $200,000 1 year ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.