The Phia Group, LLC is a thriving, service-oriented company headquartered in Canton, Massachusetts. As consultants, we represent health plans nationwide, providing our clients with innovative cost-containment solutions through our unique service offerings. As a result of our most valuable resource, our talented and committed team, we continue to enjoy high levels of growth.

In addition to helping hard-working employees and their families access high-quality, affordable health care while enjoying unrivaled benefits for yourself, you will also enjoy being part of a team that has been recognized by The Boston Globe as a Top Place to Work. In its 14th annual employee-based survey, The Boston Globe determined that The Phia Group is one of the most rewarding, admired, and meaningful employment experiences in the Commonwealth of Massachusetts, as voted upon by the people who know them best – their employees.

The Data Engineer will develop new components using ETL tools (SQL Server, Altova, Informatica) that help build data pipelines using different data formats including EDI.

Essential Duties and Responsibilities include the following. Other duties may be assigned.

• Experience in building end to end fully automated solutions for data pipeline with traceability and monitoring.
• Expertise in development of relational database management objects - tables, schemas, indexes, materialized views, partitions, stored procedures, functions etc.
• Ability to solve complex technical problems, assimilate information rapidly, and work under time constraints
• Strong SQL capability for identifying and resolving data related issues
• Responsible for gathering and assessing business information needs and preparing requirements, driving requirements through to implementation
• Ability to lead and drive projects with less supervision.
• Knowledge of healthcare claims, eligibility data and ANSI X12 data structures.
• Ensure Data Quality and Data Integrity is maintained with standardized re-usable components.
• Manage and drive multiple projects to completion in all phases within company-specified deadlines
• Ability to Interface with clients and vendors as needed.
• Perform analysis to identify data anomalies and implement adequate and efficient solutions

Experience and Qualifications

• Bachelor’s Degree preferred
• 7+ years of experience working with databases and Data integration tools. Informatica and SQL experience a plus
• In-depth knowledge and technical understanding of the various segments of healthcare EDI files like 834, 835 and 837
• Experience using various tools to parse, interpret and modify above EDI files using available tools and EDI companion guides
• Experience in scripting tools like PowerShell and Python is required. Exposure in building RPA solutions is a plus.
• Strong communication skills; both written and verbal
• Possess strong project management, organizational, and customer service skills
• Comfortable working under minimal supervision
• Ability to handle multiple projects simultaneously
• Ability to work independently or in a team environment
• Proficient with Microsoft Office Suite applications (Word, Excel, PowerPoint, Access)
• Ability to complete a short interview work assignment to demonstrate EDI 837 parsing

The Phia Group’s Commitment to Diversity

The Phia Group is committed to creating a diverse environment and we are proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. The Phia Group is also committed to compliance with all fair employment practices regarding citizenship and immigration status.

Working Conditions / Physical Demands

Sitting at a workstation for prolonged periods of time. Extensive computer work. The workstation may be exposed to overhead fluorescent lighting and air conditioning. Fast-paced work environment. Operates office equipment including personal computers, copiers, and fax machines.

This job description is not intended to be and should not be construed as an all-inclusive list of all the responsibilities, skills, or working conditions associated with the position. While it is intended to accurately reflect the position’s activities and requirements, the company reserves the right to modify, add or remove duties and assign other duties as necessary.