The Phia Group is comprised of The Phia Group, LLC and Phia Group Consulting, LLC (“PGC”), and is a service-oriented organization assisting employee health plans nationwide. We provide our clients with innovative cost-cutting solutions and constantly expanding service offerings. We continue to enjoy growth thanks to our most valuable resource – our talented and committed team.

The ETL Developer will assist with development and maintenance of ETL Maps using Altova Mapforce. The ETL Specialist must analyze data and find data discrepancies using business rules.

At The Phia Group, whose mission is to provide high quality yet affordable healthcare to American employees and their dependents, you can look forward to not only exceptional benefits for yourself but also being immersed in a company that has been named one of USA Today’s top workplaces for 2024. We believe that this distinction, which stems from the fourth annual survey co-sponsored by Energage and USA Today, reflects our unwavering commitment to upholding an internal culture of inclusivity, enjoyment, and empathy for our valued employees.

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

Develop ETL Maps in Altova for imports of client claim data Database and ETL performance tuning Design, implement and understand Dimensional Models and query tools Design and development of relational database management objects (tables, schemas, indexes, materialized views, partitions, stored procedures, macros, etc.) , database design principles, data administration standards, and information security terminology 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 Lead source system analysis and design, help to design and develop data loading processes Knowledge of claims or healthcare related data structures and entities Help implement best practices and robust ETL solutions, create various ETL jobs based on EDW environment Architecture and Data Models that got created Ensure Data Quality and Data Integrity is maintained Understand our data sources, current data environment, collaborate with BI team and business SME's to understand immediate and upcoming data needs Serves as Subject Matter Expert in data modeling concepts (star schema, snowflake schemas, normalized & de-normalized data models) to help build EDW, ODS and Data Marts Develops processes for capturing and maintaining metadata Experience with 837 and 835 EDI Health Care claims files Performs other duties as assigned.

Experience and Qualifications

Must have good understanding of Microsoft SQL Server 2008 and 2012 Proficient in writing SQL queries and understanding data modals Must have experience in of the ETL tools preferably Altova Mapforce or Informatica Experience implementing API solutions in the healthcare industry Knowledge of claims or healthcare related data structures and entities is desirable Excellent communication skills and customer service skills Good Team player with the ability to work well with others Bachelor’s degree or Associates degree in computer science or related field preferred. Minimum 2-4 years experience. Ability to read, write and speak the English Language Must have ability to define problems, collect data, establish facts, and draw valid conclusions

Working Conditions / Physical Demands

Sitting at workstation for prolong periods of time. Extensive computer work. Workstation may be exposed to overhead fluorescent lighting and air conditioning. Fast paced work environment. Operates office equipment including personal computer, 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 activities and requirements, the company reserves the right to modify, add or remove duties and assign other duties as necessary.

External and internal applicants, as well as position incumbents who become disabled as defined under the Americans with Disabilities Act, must be able to perform the essential job functions (as listed here) either unaided or with the assistance of a reasonable accommodation to be determined by management on a case by case basis.