Data Analyst

Tech Talent is a fast-growing IT company. We Provide IT services to support clients in solving their business problems and increasing their operational efficiency by integrating and leveraging the existing and new systems. We combine our in-depth domain knowledge with expertise in cutting-edge information technology to deliver high-impact solutions that add value to the bottom-line of our clients. We also have strong domain expertise in Health care, Insurance, and Financial verticals

Location: Newyork City NY

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: Newyork City NY

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