Data Analyst

Technology Talent Network LLC; Virginia; Sur place; USD 85 000 - 120 000; Plein temps

Résumé du poste

Technology Talent Network is seeking a data-focused ETL Developer in Virginia to build and optimize SSIS-based ETL workflows for healthcare data, integrating sources such as QNXT and Salesforce.

The role requires 3–5 years of data analytics experience, strong SQL skills, and collaboration with cross-functional teams, with on-site work in Glen Allen, VA.

Qualifications

• 3–5 years of data analytics experience in healthcare domain.
• Proficiency in SQL queries and health care reporting.
• Experience with large datasets from multiple sources (QNXT, Salesforce, Oracle).

Responsabilités

• Build and maintain ETL processes with SSIS and SQL Server.
• Handle large datasets from SQL Server, QNXT, Salesforce, Oracle.
• Design scalable data integration solutions with robust testing.
• Collaborate across business SMEs and technical stakeholders.

Connaissances

SQL

SSIS

ETL

Outils

QNXT

Salesforce

Oracle

SQL Server

Description du poste

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: Glen Allen VA

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

Company Description

Awesome company with great references and growth opportunity. Customized Payroll Structure
1 on 1 guidance available in person
full learning support available