Job DescriptionJob Description
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: Irvine, CA
Technology Talent Network is an Equal Opportunity Employer M/F/V/D
Company 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
Read Less