Data Analyst

Job Description 1. SQL / SSIS DepthBuild 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 SolutioningConduct 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 LogicDevelop 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 StrengthTranslate 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).QualificationsUSC/GC/H4EADMinimum 3-5 years of data analytics and experience. Proficiency in SQL queries and reporting in Health Care domainWork Location: Irvine, CA Technology Talent Network is an Equal Opportunity Employer M/F/V/DCompany DescriptionAwesome company with great references and growth opportunity. Customized Payroll Structure 1 on 1 guidance available in person full learning support availableCompany DescriptionAwesome company with great references and growth opportunity. Customized Payroll Structure\r\n1 on 1 guidance available in person\r\nfull learning support available