Advisor (Lead) Data Analyst (US Cit to pass clearance)

We are seeking to hire a Advisor (Lead) Data Analyst with expertise in Medicare / Pharmacy Benefits Management systems, 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:

The candidate is expected to lead a small team of data analysts or collaborate with other analysts and

be able to develop program specifications and mapping documents.   Perform analysis on data to

understand transformation requirements, work with ETL/Reporting/Conversion staff to ensure code has

been developed that meet the business requirements documented, test the interface/report to ensure

requirements are met and work with other team members. Determines best practices and provides

suggestions on how to improve current practices. Works with the development lead to get project tasks

assigned and completed on schedule. Has the capabilities to perform research and requirement

analysis, creation and design of mapping documents, and present findings to appropriate team

members, clients and vendors. 

Top 7 Skills:

1) Pharmacy Benefit Management knowledge

2) Healthcare/business knowledge in member, eligibility, TPL, claims processing, provider,

pharmacy claims

3) Good/Excellent SQL skills

4) Good Oral/Written communication skills

5) Data Mapping experience

6) Conversion/Interface/Reporting Experience

7) Management skills

Duties and Responsibilities

·        Works with the development lead to coordinate work assignments for projects

·        Works with project management to complete documentation requirements

·        Creates accurate mapping documents according to the mapping process.

·        Works toward delivering a solution to ETL/Reporting/Conversion for coding, by rapidly understanding which details about the mapping can be deferred.

·        Supports DSD creation and response. 

·        Presents analysis and design recommendations to lead MITA teams, customer and/or vendors into the acceptance of the design.

·        Supports the ETL/Reporting/Conversion developers based on the mappings created. 

·        Works closely with configuration team and DBAs to ensure synchronicity of configuration to interfaces and mappings.

·        Refines mapping documents, adding more detail and filling out deferred material as questions are resolved.

·        Uses SQL, data models, data element dictionary and schema to perform data and business analysis.

·        Creates unit test cases for area of responsibility.

·        Validates test plan results that satisfy the detailed design goals.

·        Updates technical specifications and mappings.

·        Supports Unit Testing, System Integration Testing, System Testing, and User Acceptance Testing.

Required Experience

·        Five or more years of experience supporting pharmacy benefit, claims administration, Medicaid, Medicare, healthcare payer, or another highly regulated healthcare environment.

·        Seven or more years of experience using SQL to analyze, validate, reconcile, transform, or troubleshoot complex relational data.

·        Experience supporting large-scale system implementation, modernization, conversion, or DDI program.

·        Demonstrated experience producing source-to-target mappings, interface specifications, data- analysis results, and test artifacts.

·        Experience authoring or maintaining ICDs, companion guides, and detailed mapping workbooks.

·        Experience supporting CMS or state certification activities.

·        Experience designing synthetic test data and complex end-to-end test scenarios.

·        Experience supporting production stabilization, defect triage, data remediation, and operational handoff.

·        Experience standardizing delivery practices across projects or mentoring other analysts.

·        Experience evaluating or incorporating AI-assisted analysis while retaining analyst review, traceability, and accountability.

Knowledge, Skills and Abilities

·        Project managements skills

·        Analytical and data analysis skills within a technical environment preferably SQL

·        Healthcare knowledge within a claims processing environment preferably in Medicaid

·        Excellent verbal and written communication skills

·        Maintain confidentiality and comply with Health Insurance Portability and Accountability Act (HIPAA)

·        Ability to establish and maintain positive and effective work relationships with coworkers, clients, members, providers and customers

·        Familiarity with DataBricks

·        ETL Gateway or comparable healthcare integration frameworks

·        Databricks or comparable data-engineering platforms

·        Azure DevOps

·        Application Lifecycle Management tools

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.