Senior Data Analyst, Data Transfer Agreement, Gap Analysis, Data SQL Skills

RXinsider LTD.; United States; Hybrid; USD 100,000 - 150,000; Full time

Benefits offered by this job

Competitive pay structure

401(k) matching with immediate vesting

Medical, dental, vision, life, & short

Job summary

AssistRx, Inc. is seeking a Senior Data Analyst to own DTAs, lead gap analyses, and translate complex data findings into actionable insights for technical and executive audiences.

You will collaborate with legal, compliance, and IT to ensure data flows meet regulatory requirements and support data governance, reporting, and client success initiatives.

Qualifications

• Draft, review, and maintain Data Transfer Agreements (DTAs).
• Perform structured gap analyses between source and target systems.
• Translate business needs into data solutions for stakeholders.
• Demonstrate strong written and oral communication skills.
• Proficient in SQL queries and data reporting across Snowflake environments.
• Understand ETL/ELT processes and data governance.

Responsibilities

• Author, maintain, and update DTAs for clients and partners.
• Lead data gap analyses and surface remediation recommendations.
• Engage with clients during onboarding, reviews, and reporting.
• Write optimized SQL and design dashboards for stakeholders.
• Develop data documentation and runbooks for processes.
• Identify process improvements based on analyses.

Skills

DTA management

Gap analysis

Client engagement

Clear written communication

SQL & data warehousing

Data governance

Data visualization

Python or R

Education

BS in Computer Science / Information Systems / Mathematics / Statistics or related field

Tools

Snowflake

SQL Server

dbt

Tableau

Power BI

Looker

Python

R

Job description

KEY FOCUS AREAS

Data Transfer Agreements

Primary author and owner of DTAs — drafting, negotiating, and maintaining data-sharing agreements with clients and partners.

Gap Analysis

Lead systematic gap analysis between multiple systems to drive data quality and integration decisions. Provides understanding of impact analysis when changing source or target systems, both upstream and downstream.

Customer Engagement

Serve as a direct client-facing data resource — translating business needs into data solutions and communicating findings clearly to non-technical stakeholders.

Communication

Produce clear, accurate written deliverables (reports, documentation, DTA summaries) and lead stakeholder presentations and data reviews.

Data & SQL Skills

Own complex SQL queries, data modeling, and analytical reporting across Snowflake and connected data warehouse environments.

Summary

The Senior Data Analyst at AssistRx serves as a primary point of contact between client organizations and internal data systems. This role leads the full lifecycle of Data Transfer Agreement (DTA) documentation, conducts structured gap analyses between source and target data environments, and translates complex data findings into actionable insights for both technical and executive audiences. Strong written and verbal communication skills are essential, as this analyst will engage directly with customers on data governance, integration readiness, and reporting needs.

Duties & Responsibilities

Data Transfer Agreements (Primary Responsibility)

• Author, maintain, and update Data Transfer Agreements (DTAs) for all client and partner data-sharing arrangements.
• Collaborate with legal, compliance, and IT security to ensure DTAs reflect current data flows, retention policies, and regulatory requirements.
• Serve as subject matter expert on DTA scope during client onboarding and contract renewals.
• Track DTA revision history and surface expiration or gap alerts proactively.

Gap Analysis

• Lead structured gap analysis between presentation DB views, Scriptly schema, and source system data to identify coverage, mapping, and quality gaps.
• Produce clear gap analysis documentation with prioritized remediation recommendations for data engineering and product teams.
• Monitor ongoing gap metrics and communicate trends to stakeholders via dashboards and regular reports.
• Translate gap findings into actionable data quality requirements and DTA scope adjustments.

Customer & Stakeholder Engagement

• Serve as a direct customer-facing resource for data-related inquiries, onboarding, and ongoing reporting needs.
• Lead client-facing data reviews, walking stakeholders through findings, gaps, and resolution timelines.
• Build trusted relationships with customer data teams, acting as an interpreter between business requirements and technical data architecture.
• Gather and document client data requirements, translating them into analytical specifications and DTA updates.

Data Analysis & Reporting

• Write optimized SQL queries (Snowflake/SQL Server) for complex data extraction, transformation, and validation across the integrated data environment.
• Design and maintain reporting solutions and dashboards for client and internal stakeholders.
• Interpret data, formulate findings, and deliver concise, well-structured reports and presentations.
• Validate data quality by filtering, cleansing, and cross-referencing datasets against known schema mappings.
• Apply statistical techniques to analyze trends, outliers, and performance indicators.

Process & Documentation

• Develop and maintain data documentation including data dictionaries, field-level lineage maps, and integration runbooks.
• Identify and propose process improvement opportunities based on gap analysis and customer feedback.
• Support continuous improvement of data collection, mapping, and quality control workflows.

Preferred

• Familiarity with healthcare or specialty pharmacy data environments (hub services, patient support, and copay programs).
• Experience with dbt, data warehouse modeling, or column-level data lineage tools.
• Knowledge of HIPAA, data privacy regulations, and data governance frameworks relevant to healthcare data sharing.
• Experience with data visualization and reporting tools (Tableau, Power BI, Looker, or equivalent).
• Experience with Python or R for data analysis and automation.

Core Competencies

Written Communication

Produces clear, accurate, well-structured documents including DTAs, gap analyses, and stakeholder reports. Edits for precision and adapts writing style to audience.

Oral Communication

Leads client-facing data reviews and internal presentations with clarity and confidence. Listens actively, responds to questions, and adjusts explanations for technical and non-technical audiences.

Customer Focus

Builds trusted relationships with client data teams. Understands customer data needs and translates them into actionable requirements and documentation.

Analytical Thinking

Synthesizes complex, multi-system data to identify gaps, inconsistencies, and opportunities. Uses both quantitative methods and domain expertise to reach sound conclusions.

Attention to Detail

Maintains accuracy across DTA documentation, SQL logic, and gap analysis outputs. Proactively catches errors before they reach stakeholders.

Initiative

Proactively identifies data gaps, expiring agreements, and process improvement opportunities without waiting to be directed.

Adaptability

Adjusts analytical approach and communication style as data environments, client needs, and priorities evolve.

Teamwork

Collaborates with legal, engineering, product, and client-success teams to deliver integrated data solutions and compliant data agreements.

Ethics & Confidentiality

Handles sensitive client data with integrity. Upholds data governance policies and treats DTA obligations as binding commitments.

Technical Skills

Continuously develops expertise in SQL, data warehousing, schema mapping, and data governance tooling. Shares knowledge with team members.

Work Environment

• This position operates in a professional office or remote environment.
• Continual computer use; standard office lighting and ergonomic workspace.
• Occasional evening or weekend work may be required to meet project deadlines.
• Domestic travel may be required for client engagements.

The above describes the general content and requirements for this position. It is not an exhaustive statement of duties. Management reserves the right to assign or reassign responsibilities at any time. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

Acknowledgement

I have read and understand the responsibilities of this position and agree that I am able to perform the essential duties described above.

Requirements

Required

• BS in Computer Science, Information Systems, Mathematics, Statistics, or related field.
• 5+ years of experience in a data analyst role with direct client or customer-facing responsibilities.
• Demonstrated experience drafting, reviewing, or maintaining Data Transfer Agreements or similar data governance documents.
• Intermediate-level SQL (Snowflake preferred); comfortable writing complex multi-CTE queries and aggregations across large datasets.
• Strong experience conducting gap analysis between source and target data systems, with formal documentation of findings.
• Excellent written and verbal communication skills — able to produce clear, executive-ready reports and lead client-facing data discussions.
• Understanding of ETL or ELT processes.

Benefits

• Supportive, progressive, fast-paced environment
• Competitive pay structure
• Matching 401(k) with immediate vesting
• Medical, dental, vision, life, & short-term disability insurance

AssistRx, Inc. is proud to be an Equal Opportunity Employer. All qualified applicants will receive consideration without regard to race, religion, color, sex (including pregnancy, gender identity, and sexual orientation), parental status, national origin, age, disability, family medical history or genetic information, political affiliation, military service, or other non-merit based factors, or any other protected categories protected by federal, state, or local laws.

All offers of employment with AssistRx are conditional based on the successful completion of a pre-employment background check.

In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire. Sponsorship and/or work authorization is not available for this position.

AssistRx does not accept unsolicited resumes from search firms or any other vendor services. Any unsolicited resumes will be considered property of AssistRx and no fee will be paid in the event of a hire