We are seeking to hire a Senior ETL Data Analyst with QNXT / schema and healthcare domain knowledge, to join our teams working on a new multi-year awards we have within several State Gov’t clients, modernizing their Medicare/Medicaid systems. These roles are 100% remote.
Being a US Cit is required for working on this program.
This position pays a strong salary package with full benefits (including choice of healthcare plans, dental, vision, life insurance, 3 weeks PTO, 11 Paid Federal Holidays, and a matching 401k).
An option for working on an hourly rate is also available for those not needing a full benefits package.
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.
If qualified and interested, please send an updated resume along with rate/salary requirement and we will follow up quickly to discuss further details and move forward with your interview process.
ec3 Federal Services is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. ec3 Federal Services is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment. All employment decisions at ec3 are based on business needs, job requirements and individual qualifications, without regard to race, color, religion or belief, national, social or ethnic origin, sex (including pregnancy), age, physical, mental or sensory disability, HIV Status, sexual orientation, gender identity and/or expression, marital, civil union or domestic partnership status, past or present military service, family medical history or genetic information, family or parental status, or any other status protected by the laws or regulations in the locations where we operate. ec3 Federal Services will not tolerate discrimination or harassment based on any of these characteristics.
