Data Analyst

The Senior Data Analyst 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.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

• BS in Computer Science, Information Systems, Mathematics, Statistics, or related field.
• 5+ years of experience in a Data Analyst/ Technical Business Analyst role with direct client or customer-facing responsibilities.
• 1+ year of experience drafting, reviewing, or maintaining Data Transfer Agreements or similar data governance documents.
• Intermediate-level SQL Server, or Oracle, Snowflake HIGHLY 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.

Healthcare or specialty Pharma experience
• 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.

Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.