Data Analyst- Erwin
Data Analyst- Erwin
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Job Title: Senior Systems Analyst (Data Analyst- Erwin)
Location: Remote
Job Type: W2
Experience Level: Mid-Senior Level
*****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.
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
Bachelors or Masters 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.
Data Analyst,data warehousing,healthcare payer sector,data architecture,clinical data ecosystem,data integrity,ETL Processes,data governance,DB2,Ab Initio,Cognos,Tableau,Erwin
Employment Type
Full Time
