Data Analyst, Client Insights & Reporting

Haymarket Media•New York, NY

13h•Hybrid

About The Position

Haymarket’s Medical Communication Group is seeking a Data Analyst to deliver client-facing insights and reports for custom digital programs. Reporting to the Director, Client Insights and Reporting, the role will initially focus on bringing existing report generation in-house and identifying opportunities for automation. Over time, the analyst will work with the wider Insights and Reporting team to evolve the offering in response to client needs and technology. The position is based in the New York, NY office with a hybrid schedule, typically three days in the office depending on business needs.

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, with attention to detail and accuracy when collecting and organizing data, including identifying extreme outliers and understanding their causes.
Curiosity and a 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 to facilitate adding data points to reports as requested by clients.
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 steps in the report-generation workflow.
Collect and interpret data from multiple sources, analyze results, and provide ongoing insights.
Define and develop reporting insights based on client KPIs.
Use dashboards in data visualization tools to provide actionable data for marketing and sales teams.