Data Analyst, Client Insights & Reporting

Haymarket Media US•New York, NY

1d•$70,000 - $90,000•Hybrid

About The Position

Haymarket’s Medical Communication Group is seeking a Data Analyst, Client Insights and Reporting to deliver client-facing insights and reports for custom digital programs. The role initially focuses on bringing existing report generation in-house and identifying opportunities for enhanced automation. In collaboration with the wider Insights and Reporting team, the analyst will also help evolve the offering in response to client needs and technology improvements. The position reports to the Director, Client Insights and Reporting and is based in the New York, NY office on a hybrid schedule, with three days in the office depending on business needs. The role involves producing and maintaining client reports and dashboards, working with data from multiple sources, and turning analysis into actionable insights for marketing and sales teams. The analyst will collaborate with Business Intelligence and Development teams and colleagues across business units to support client requests, reporting standards, and workflow improvements.

Requirements

Bachelor’s or master’s degree in a related field.
Ideally, three years of relevant experience in a data role, such as business analytics or software product analytics.
Advanced Google Sheets or Excel skills, including Pivot Tables, VLOOKUP, SumIf, CountIfs, and Power Query.
Experience creating and maintaining reports and dashboards using tools such as Looker, Tableau, or Power BI.
Proficiency in SQL and Python.
Knowledge of and hands-on experience with Google BigQuery and Google Analytics.
End-to-end data experience, including querying, formatting, aggregation, and analysis.
Experience combining data in various formats into a single format.
Strong reporting and quality assurance skills, including attention to detail and accuracy, identifying extreme outliers, and understanding their causes.
Curiosity and willingness to ask questions to better understand concepts and data.
Ability to think creatively about challenging problems.
Strong collaboration and communication skills.

Responsibilities

Produce formatted weekly and monthly client reports based on client specifications.
Work with Business Intelligence and Development teams as needed to add requested data points to existing reports.
Collaborate with the Client Insights and Reporting team to maintain consistent standard operating procedures across business units.
Identify workflow steps that would benefit from automation.
Define requirements for automating reports or report-generation workflow steps.
Collect and interpret data from multiple sources, analyze results, and provide ongoing insights.
Define and develop reporting insights that take client KPIs into account.
Use dashboards in data visualization tools to provide actionable data for marketing and sales teams.