Sr ETL Data Analyst with QNXT / healthcare domain experience

Job Description

Perform research and requirement analysis, creation and design of mapping documents, and present findings to appropriate team members, clients and vendors.

Determine best practices and provide suggestions on how to improve current practices.

The candidate needs to be able to develop program specifications and mapping documents based on business requirements identified.

Perform analysis on data to understand transformation requirements, work with ETL developers and other data analysts to ensure code has been developed that meet business requirements and tested to ensure functionality meets expectations.

Top 6 Skills

• QNXT/schema and healthcare data knowledge
• Healthcare/business knowledge in member, eligibility, TPL, claims/encounters processing (medical and pharmacy), financial, and provider domains
• Good/Excellent SQL skills
• Power BI/dashboard reporting experience
• Good Oral/Written communication skills
• Data Mapping and ETL experience
• Data validation and reconciliation experience

Duties and Responsibilities

• Create accurate source-to-target mapping documents, transformation rules, and ETL specifications to support reporting and analytics requirements.
• Work toward delivering initial data design and mapping specifications to ETL developers for coding and implementation.
• Support Detailed Solution Design (DSD) creation, review, and responses related to reporting data pipelines and solutions.
• Translate business and reporting requirements into ETL data requirements, transformation logic, facts, dimensions, aggregates, and reporting-ready datasets.
• Present data analysis, ETL design, mapping, and transformation recommendations to lead teams, customers, and/or vendors for review and acceptance of the design.
• Support ETL developers throughout development by providing clarification on data mappings, transformation rules, calculations, business rules, and reporting requirements.
• Work closely with reporting analysts, Power BI developers, data engineers, configuration teams, and DBAs to ensure alignment of source data, ETL transformations, data models, and reporting outputs.
• Refine mapping and ETL specification documents by adding detail and resolving outstanding data, transformation, and business-rule questions.
• Use SQL, data models, data dictionaries, schemas, and source system documentation to perform detailed data and business analysis.
• Perform data profiling and source data analysis to identify data quality issues, relationships, dependencies, and transformation requirements.
• Define and validate transformation logic required to create reporting facts, dimensions, measures, aggregates, and curated reporting datasets.
• Support development and validation of data pipelines from source through curated/Gold reporting layers and downstream reporting solutions.
• Perform data reconciliation and validation across source systems, ETL outputs, reporting datasets, and reports/dashboards.
• Create unit test cases for ETL mappings, transformations, and reporting data requirements within the assigned area of responsibility.
• Validate test results to ensure ETL processes and reporting datasets satisfy detailed design and business requirements.
• Update technical specifications, ETL mappings, data lineage, source-to-target mappings, and reporting data documentation.
• Support Unit Testing, System Integration Testing, System Testing, and User Acceptance Testing, including analysis and resolution of data-related defects.

Knowledge, Skills and Abilities

• Strong analytical and data analysis skills within a technical environment, with strong SQL skills.
• Healthcare knowledge within a claims processing environment, preferably Medicaid, MMIS. Pharmacy Benefit Management
• Knowledge of healthcare data domains including member, eligibility, TPL, medical and pharmacy claims/encounters, financial, and provider data.
• Experience analyzing and documenting source-to-target mappings, ETL transformation rules, and data lineage.
• Understanding of ETL/ELT processes, data integration, data transformation, and data validation concepts.
• Understanding of data warehouse and dimensional modeling concepts, including facts, dimensions, star schemas, measures, and aggregates.
• Experience with data profiling, data quality analysis, reconciliation, and root-cause analysis.
• Ability to translate reporting and business requirements into technical data and ETL requirements.
• Ability to validate data from source systems through transformed reporting datasets and final reports/dashboards.
• Experience working collaboratively with data engineers, ETL developers, reporting analysts, Power BI developers, DBAs, QA teams, and business SMEs.
• Excellent verbal and written communication skills, with the ability to communicate technical data concepts to business and client stakeholders.
• Maintain confidentiality and comply with Health Insurance Portability and Accountability Act (HIPAA) requirements.
• Ability to establish and maintain positive and effective working relationships with coworkers, clients, members, providers, and customers.
• Experience with Databricks and Power BI is preferred.
• Experience with cloud-based data platforms and modern ETL/ELT architectures is a plus.
• 5 years of healthcare business/data analytical experience.
• 3 years of technical/SQL experience.