Data Analyst

Job Description

1. SQL / SSIS Depth

• Build and maintain ETL processes with SSIS (including Data Flow Tasks, Lookups, Merge Joins, Conditional Splits).
• Handle large datasets (millions of records) from multiple heterogeneous data sources (e.g., QNXT, Salesforce, Oracle, SQL Server).
• Implement performance tuning strategies (e.g., indexing, parallel processing, optimized joins).
• Deliver solutions that improve data pipeline performance, accuracy, and maintainability.

2. Cross-Functional Solutioning

• Conduct thorough impact assessments across interconnected systems and domains.
• Collaborate effectively with business SMEs and technical stakeholders from multiple teams.
• Map data flows and dependencies between systems like QNXT, Salesforce, Simplify, and internal applications.
• Design scalable solutions that support both existing and new business rules (e.g., 834 and 837 EDI processing, provider hierarchy logic).

3. TDD & Transformation Logic

• Develop comprehensive TDDs with source-to-target mappings, business rules, and transformation logic.
• Collaborate with business analysts, QA, and developers to ensure accuracy and alignment.
• Maintain documentation in shared repositories (e.g., Confluence, SharePoint, Git).
• Support traceability from requirements to implementation to testing.

4. Communication & Development Strength

• Translate technical concepts (e.g., data integration issues, transformation logic, system limitations) into business-friendly language.
• Use visuals (e.g., process flows, sample data) to aid understanding.
• Participate in and lead cross-functional meetings and solution walkthroughs.
• Facilitate collaboration between dev teams and business units (e.g., Salesforce integration with QNXT).

Qualifications

USC/GC/H4EAD
Minimum 3-5 years of data analytics and experience. Proficiency in SQL queries and reporting in Health Care domain

Work Location: Sacramento, CA

Technology Talent Network is an Equal Opportunity Employer M/F/V/D