Senior Systems Analyst (Data Analyst)

Job Title: Senior Systems Analyst (Data Analyst)

Location: Remote

Job Type: Full Time

Experience Level: Mid-Senior Level

Maximum Rate 52 On W2

*****NO C2C ONLY ON OUR W2*****

-

Position Overview

We are seeking a highly skilled and experienced Senior Systems Analyst (Data Analyst) to support data analysis and architecture initiatives within a healthcare payer clinical data ecosystem.

This role requires a detail-oriented, proactive professional with a strong background in data management, data warehousing, and healthcare analytics.



Key Responsibilities

Data Analysis & Design: Contribute to the design, modeling, implementation, and maintenance of data solutions within the clinical data ecosystem.

ETL Process Understanding: Interpret ETL terminologies and processes including jobs, Psets, graphs, schedules, and job series (100, 300, 500).

Data Modeling: Follow data model standards and understand entity-relationship (ER) modeling using tools like Erwin.

PHI/PII Data Handling: Ensure compliance with data privacy standards by preventing exposure to PHI/PII and applying data masking techniques.

SA Deliverables: Create and maintain key deliverables such as Source-to-Target (S2T) mappings, Data Element Dictionaries (DED), Functional Requirement Specifications (FRS), data models, design documents, and impact analyses.

Performance Optimization: Optimize performance through index creation, efficient SQL writing, and process design.

Database Fundamentals: Understand database structures and schema design.

SQL Development: Write and optimize SQL queries using commands like ALTER, CREATE, CTE, GROUP BY, etc.

Healthcare Claims Knowledge: Understand medical and pharmacy claims processing, including adjudication, denial/payment logic, claim types, and their relationship with Other Party Liability (OPL) data.

Stakeholder Collaboration: Work with business stakeholders and cross-functional teams to translate business needs into functional and technical specifications.

Communication: Clearly communicate technical concepts to non-technical stakeholders.



Required Skills & Qualifications

Technical Skills

Proficiency in dimensional modeling, SQL, and data warehousing concepts.

Experience with DB2, ETL tools (Ab Initio), and reporting tools (Cognos, Tableau).

Familiarity with data modeling tools like Erwin.

Strong understanding of ETL processes, data governance, and metadata management.

Knowledge of healthcare payer systems, including claims and clinical decision support.



Soft Skills

Strong analytical and problem-solving abilities.

Excellent verbal and written communication skills.

Ability to work independently and collaboratively in a team environment.



Education & Experience

Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.

7 10 years of experience in systems analysis, with a focus on data warehousing in the healthcare payer sector.