Data Architect

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 Data Architect will be an integral cog in the life cycle of the claims data process. The Data Architect will develop and maintain ETL Maps using Altova Mapforce, assist in preserving the quality and integrity of the enterprise data, collaborate with internal business users to triage data anomalies and coordinate with external clients to resolve any data quandaries. The Data Architect must analyze data and find data discrepancies using business rules.

Essential Duties and Responsibilities

• 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
• 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
• 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 Subject Matter Experts (SMEs) to understand immediate and upcoming data needs
• Serves as SME 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

Experience and Qualifications

• Bachelor’s degree or Associates degree in computer science or related field preferred
• Minimum 2-4 years experience
• Must have good understanding of Microsoft SQL Server 2012 and 2016
• Proficient in writing SQL queries and understanding data modals
• Must have experience in of the ETL tools preferably Altova Mapforce, Talend or Informatica
• Experience implementing API solutions in the healthcare industry
• Basic knowledge of software coding, concepts or HTML would be a plus.
• 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