Lead Data Integration Specialist

TPAC Underwriters, Incorporated
27 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 110K

Job location

Remote

Tech stack

Databases
Data Files
Data Integration
Database Queries
Microsoft SQL Server
Power BI
Data Streaming
Vba Programming Language
Tools for Reporting

Job description

As a Lead Data Integration Specialist, you'll manage and optimize health plan data flow, ensuring seamless integration across systems (TPA, PBM, Stop loss, PPO, etc.). You'll implement, test, monitor, and maintain data exchanges for accurate transmission. Additionally, you'll produce, automate, and distribute plan experience reports, analyze business processes, identify improvements, and develop solutions to enhance efficiency and effectiveness. Captrue strives for excellence and efficiency in everything we do - from serving our customers to working with plan partners across the industry. Success in this role will be heavily supported with some of the newest industry-leading technologies and software available in the TPA market and a simplified strategic partnership approach (fewer vendors, optimized outcomes)., · Maintain: Configure & build upon custom built interfaces in VBA Software.

· Coordinate: Respond to EDI file errors and work with partners and vendors to resolve the issues.

· Project Management: Assist in the planning, execution, and monitoring of projects to ensure they meet business objectives and are delivered on time and within budget.

· Leadership: This position has a Data Integration Specialist reporting to it.

Requirements

· Bachelors degree or equivalent work experience

· 5-7 years of working with data file integrations, preferably in VBA Software (Health Payer Platform)

· 3+ years of working with MSSQL database(s) & writing SQL Queries, preferably in VBA Software

· 3+ years of experience working with EDI in the x12 health payer format (278, 834, 835, 837) · Understanding of reporting tools like Bold Reports / PowerBI / VBAdvanced Reporting

· Knowledge of HIPAA regulations and a commitment to maintaining compliance with privacy & security standards.

Benefits & conditions

Tuition reimbursement, Parental leave, 401(k), Health insurance, 401(k) matching, Paid time off, Life insurance, * 401(k)

  • 401(k) matching
  • Health insurance
  • Life insurance
  • Paid time off
  • Parental leave
  • Tuition reimbursement

About the company

Captrue Benefits is a third-party administrator located in Minneapolis, Minnesota. Captrue Benefit's mission is to change the way healthcare is financed, disclosed and delivered. We need people who value honesty and transparency; people who take ownership and responsibility of whatever they are doing. We seek individuals who value all people and interact with humility and respect; people who like to dig deep into issues, who are curious and who understand life is about more than work. If you believe in our mission and share our Core Values, then we would like to talk about how we can make a positive impact together.

Apply for this position