Data Analyst, Client Insights and Reporting

Data Analyst, Client Insights and Reporting Haymarket’s Medical Communication Group is looking for a talented Data Analyst, Client Insights and Reporting to join our growing team. We recognize individual talent and skill; we encourage personal and professional development; and we reward success. If you believe that you have the talent, enthusiasm, and spirit and can match the exacting standards set by our employees, then we’d be delighted to welcome you to the team.

This position is located in our New York, NY office on a hybrid work schedule; three (3) days in office depending on business needs.

Job Overview:

The Data Analyst, who will report to the Director, Client Insights and Reporting, will be responsible for delivering client-facing insights and reports for Medical Communication custom digital programs for our clients. In the short term, this role will be focused on transitioning existing report generation in-house with an eye towards enhanced automation. Over time, working with the larger Insights and Reporting team, there will be an opportunity to inform and evolve the offering based on changing client needs and enhanced technology.

Data, Analytics and Reporting are high profile areas within Haymarket. This is an opportunity for the right candidate to contribute to a high growth area of the business.

Responsibilities:

Production of several types of formatted weekly / monthly reports for clients based on specifications provided by client

Work with Business Intelligence / Development teams as needed to facilitate addition of new data points to existing reports as requested by clients

Work collaboratively with other members of the Client Insights and Reporting team to maintain consistent SOPs across different business units

Identify points in workflow that would be best served through automation Define requirements needed to automate 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 considering client KPI’sUse dashboards within data visualization tools to provide actionable data for marketing and sales teams

Skills and Requirements:

BS/MS degree in related field Ideally three (3) years of relevant experience in a data role: business analytics or product analytics (software)
Advanced Google Sheets / Excel skills:
Pivot Tables, VLOOKUP, Sum If, Count Ifs, etc;
Power Query Experience in creating and maintaining reports and dashboards (Looker, Tableau, Power BI, etc)
Proficiency in SQL and Python Knowledge and hands-on experience with Google Big Query, Google Analytics End-to-end experience with data, including querying, formatting, aggregation, and analysis

Experience in combining data of various formats into a single format

Strong reporting and QA skills with the ability to collect and organize data with attention to detail and accuracy, such as the ability to identify extreme outliers and understand their cause

Yearn to ask questions to gain a better understanding of a concept or the data Ability to think creatively about challenging problems

Must be a strong collaborator and communicator

What We Offer:

A competitive compensation package

The salary range for this position is $70K–$90K. Compensation will be commensurate with experience, skill level, functional and/or industry knowledge, education level, certifications, as well as other qualifications.

Paid annual vacation, holiday and sick time off Comprehensive health plans including medical, dental and vision

Competitive 401(k) investment options and generous company matching program

Life insurance

Commuter benefits

Employee referral awards

Tuition reimbursement

Work from anywhere option to ensure work life balance…