Job Description
Job 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: Northern VA (Remote)
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 available
Company Description
Awesome company with great references and growth opportunity. Customized Payroll Structure\r\n1 on 1 guidance available in person\r\nfull learning support available