Data Integration Analyst

MedOne; Iowa (LA); Remote; USD 70,000 - 95,000; Full time

Job summary

A leading company in pharmacy benefit management is seeking a Data Integration Analyst to handle complex data analysis and improve integration processes. This role involves strong collaboration with cross-functional teams and requires a Bachelor’s degree and 4+ years of experience in data integration, specifically within the healthcare sector. Competitive salary and benefits are offered, along with opportunities for professional growth in a vibrant work culture.

Benefits

Competitive salary and bonuses

Comprehensive health, dental, and vision insurance

401(k) with company match

Generous paid time off

Opportunities for professional growth

Qualifications

• 4+ years of professional experience in data integration or a related field.
• Extensive experience with SQL queries and complex data sets.
• Proven expertise in EDI management and data mapping.

Responsibilities

• Design and develop data integration processes using ETL tools.
• Monitor and evaluate existing integration workflows for optimization.
• Act as the leading point of contact for clients for reporting needs.

Skills

Data analysis

SQL

ETL processes

Automation

Communication

Education

Bachelor’s degree in Information Technology

Tools

SQL Server Integration Services (SSIS)

VisualCron

UiPath

Job description

Description

Position Overview:

The Data Services team is responsible for reviewing and validating, triaging, and resolving incoming requests from the business, external clients, and external vendors. The Data Integration Analyst will be responsible for complex data analysis and intricate documentation of procedural tasks. The position also performs routine duties independently, setting priorities and scheduling own work in accordance with department policies and procedures.

About MedOne:

MedOne is a full-service pharmacy benefit manager (PBM), serving clients and members nationwide. With a fully transparent, pass-through model, MedOne helps people conveniently access the most appropriate prescriptions at the most affordable price.

What You Will Do at MedOne:

• Design and develop data integration processes using ETL tools and technologies that meets business requirements.
• Implement data quality checks and validation processes to ensure data integrity.
• Analyze complex healthcare data sets to identify trends, patterns, and insights that drive informed decision-making and process improvements.
• Monitor and evaluate existing integration workflows, procedures, and systems to identify inefficiencies and opportunities for optimization, proposing and implementing innovative solutions.
• Lead and support cross-functional projects from initiation to completion, ensuring adherence to timelines and quality standards.
• Establish and maintain strong and collaborative internal relationships with account management, member advocate, pricing and clinical team, ensuring alignment and collaboration across departments.
• Foster and maintain strong, collaborative relationships with integration partners by ensuring clear communication, timely issue resolution, and alignment on shared goals, resulting in enhanced partner satisfaction and seamless system integration.
• Act as leading point of contact for internal and external clients for advanced analysis and reporting needs.
• Proactively identify and resolve data integration issues and provide timely support to resolve any data-related incidents.

What you will bring to MedOne:

• Bachelor’s degree in Information Technology, Computer Science or related fields.
• 4+ years of professional experience in data integration, ETL, or related field, preferably with a focus on healthcare data and HIPAA compliance
• Extensive experience designing, optimizing, and troubleshooting complex SQL queries across large datasets and diverse database systems.
• Experience with automation and scheduling tools such as VisualCron, JAMS, UiPath, or similar platforms to streamline workflows and enhance operational efficiency.
• Demonstrated expertise in designing, developing, and maintaining complex SSIS (SQL Server Integration Services) packages to support robust data integration and ETL processes.
• Proven experience in EDI management, including system configuration and data mapping.
• Solid communication skills at an internal and external level as well as a technical and executive level.
• Analytical and problem-solving ability to troubleshoot issues within multiple processes.
• Ability to manage multiple projects and collaborate with diverse stakeholders.

Why Join MedOne?

• Competitive salary and bonuses that reward your performance.
• Comprehensive health, dental, and vision insurance.
• 401(k) with company match to secure your future.
• Generous paid time off and holidays.
• Opportunities for professional growth and development.
• A vibrant and collaborative work culture.

Location: We have offices in either Dubuque, IA, or Kansas City, MO, or the position can be remote within the United States.

Employment Type: Full-Time, Hourly

Hours: Hours may vary within our normal business hours.

How to Apply: If you're enthusiastic about helping others and eager to join a dynamic team, we’d love to hear from you. Apply now and take the first step toward a rewarding career at MedOne! You can submit your application through our careers page.

MedOne is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Job Offers are contingent on passing a background check and drug screen.