Senior Data Business Systems Analyst

About the Role

Sr. Data BSA
Client - AmeriHealth
Location 2 days/week - Newtown Square, PA
Duration - 6 month
Work Status - USC
Compensation - $70/hr C2C

Overview:
The Senior Data/Business Systems Analyst will play a key role in driving data-focused initiatives within the healthcare payor domain. This role requires deep technofunctional expertise across payor data, including claims, population health, and industry data standards. The analyst will work extensively with SQL, Oracle, and modern data platforms to evaluate incoming data files, support ingestion processes, and develop clear functional requirements across the full SDLC and Agile lifecyclefrom concept and design through testing and deployment. Success in this role requires strong analytical capabilities and substantial experience within the healthcare insurance sector.
Position Description:
50% Create Documentation like Functional specifications and creating source to target mappings
50% Advanced SQL skills for data analysis and profiling
Validate payer data, including claims, membership, provider, and clinical datasets.
Work with data governance and business teams to resolve data quality issues.
Participates in estimation efforts to formulate and define the scope of IS team deliverables.
Participates in the change management process playing a lead role as needed.
Resolves conflicting/competing needs from different areas of the business, tactfully, and in a way that satisfies all parties.
Required Skills
5+ years healthcare payer or payor experience (member, claims, provider, etc.) in a technofunctional role. Solid understanding of data governance practices, PII compliance, and data quality frameworks. Understand how processing of data happens in healthcare (could be FACETS, could be PII, EDI transactions, any of the healthcare data flow processes).
Experience creating Source-to-Target mapping
Data Analytics experience with large data sets. Data Profiling, Analysis
Knowledge of standard industry deliverables such as RTMs, FMEAs, and business process maps.
Build the bridge between IT and the customer. Translate the IT technical requirements to the business.
In depth understanding of ETL technologies from a BSA perspective.
Understand the data on the business side of things. Very well versed on the business side
Any Cloud experience - we are on Azure (preferred), but AWS and Google Cloud Platform are also acceptable
Understand the IT change process and SDLC methodologies (Agile, Scrum, Waterfall) - how does a code get deployed. Analytics will just build and push to production - but IT has a very specific change process to follow.
Great attitude
8+ years of professional experience focused on business/data analysis, project leadership, and process optimization.
Very strong SQL expertise with the ability to design and optimize complex queries a must
Familiarity with BI/reporting tools such as Power BI or Tableau for validating reporting outputs a must
Understanding of data governance platforms (e.g., Collibra, IDQ, Informatica, or similar).
Deal with challenging stakeholders - this is a business facing role.
Bonus Skills:
Azure Data Factory
Advanced proficiency with Azure Databricks (Delta Lake, Delta Live Tables, Unity Catalog)
Snowflake

Key Responsibilities & Skills

• Healthcare Payer Data Analysis
• Claims, Membership & Provider Data Expertise
• Advanced SQL Query Design & Optimization
• Source-to-Target Mapping Development
• Functional Specification Authoring
• Data Governance & PII Compliance
• Data Profiling & Quality Assurance
• ETL Process Design (BSA perspective)
• Change Management Leadership
• Stakeholder Coordination & Conflict Resolution
• SDLC & Agile Lifecycle Management
• Business Process Mapping (RTM/FMEA)
• Cloud Data Platform Knowledge (Azure/AWS/Google Cloud Platform)
• BI Validation (Power BI / Tableau)

Technical Skills

• SQL / Oracle
• Azure Data Factory / Azure Databricks
• Snowflake
• Power BI / Tableau
• Collibra / Informatica IDQ
• AWS / Google Cloud Platform
• ETL Platforms
• Data Modeling

Education

Bachelor's Degree in Health Informatics, Business Administration, Computer Science, Data Analytics, Health Information Management. Preferred: Master's in Health Informatics, MBA, Master's in Data Science, Master's in Public Health (MPH).

Industry Experience

• Healthcare Payor / Insurance
• Claims Processing
• Population Health Data
• Healthcare Data Standards (EDI / HIPAA)
• Cloud Data Platforms