Data Analyst, Client Insights & Reporting

Haymarket-Media-1; City of Niagara Falls (NY); Hybrid; USD 70,000 - 90,000; Full time

Benefits offered by this job

Competitive compensation package

Health plans (medical, dental, vision)

401(k) with company match

Paid time off (vacation, holidays, etc

Work from anywhere option

Three Week Work from Anywhere benefit

Job summary

Haymarket Media, Inc. is seeking a Data Analyst, Client Insights & Reporting to deliver client-facing insights and reports for medical communications programs.

The role involves transitioning reports in-house with automation goals, and working with the larger Insights and Reporting team to evolve offerings based on client needs and technology. Located in New York, NY with a hybrid schedule (3 days in office), this position emphasizes data delivery, KPI alignment, and collaboration across BI,

Qualifications

• BS/MS degree in a related field.
• Ideally 3+ years in a data role (business analytics or product analytics).
• Advanced Google Sheets / Excel skills: Pivot Tables, VLOOKUP, SumIf, CountIfs, 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 data experience: querying, formatting, aggregation, analysis.
• Experience in combining data from various formats into a single format.

Responsibilities

• Produce weekly/monthly client reports based on specifications.
• Collaborate with BI/Dev teams to add data points to reports.
• Maintain SOPs across business units with the team.
• Identify opportunities to automate reporting steps.
• Define requirements to automate reports or steps in the workflow.
• Collect and interpret data from multiple sources; analyze results for insights.
• Define and develop reporting insights considering client KPIs.

Skills

SQL

Python

Data analysis

Excel

Education

BS/MS degree in related field

Tools

Looker

Tableau

Power BI

Google BigQuery

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Data Analyst, Client Insights & Reporting

Haylo Dat Full Time Regular New York, NY, US

2 days ago Requisition ID: 2099

Salary Range: $70,000.00 To $90,000.00 Annually

Data Analyst, Client Insights & 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’s

• Use 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, SumIf, CountIfs, 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

• Training opportunities through industry-recognized programs

• A creative and passionate workplace and a fun, collaborative team environment

• Three Week Work from Anywhere benefit, to ensure work life balance

About Haymarket:

Haymarket Media, Inc. is an award-winning specialist content and information company. With more than 30 market-leading media brands, Haymarket offers unmatched expertise and insight through balanced, relevant, original content across a spectrum of media channels. Haymarket is home to highly regarded health care professional brands such as The Clinical Advisor, Dermatology Advisor, and MPR (Medical Professionals Reference) among a portfolio of HCP-focused, specialty-specific websites, as well as the esteemed business media titles including PRWeek, MM+M (Medical Marketing and Media), Campaign and McKnight’s Long-Term Care News.

Haymarket Media, Inc. is the US division of Haymarket Media Group. Haymarket Media Group is a privately-owned media, data and information company, shaping a better future with remarkable content for specialist audiences across the world. The company has 1,300 employees across offices in the UK, US, Canada, Hong Kong, Singapore, India, Germany and the Netherlands. Haymarket's portfolio consists of more than 70 market-leading brands including Campaign, Third Sector, What Car?, MyCME and Asian Investor. Through live, digital, print, education, data, tech services, video and audio, Haymarket's brands inspire, inform and empower clients and communities internationally. As a Certified B Corporation, we're proud to be part of a community of companies working together for change, and taking part in collective action to advocate for a shared goal of a global economy that benefits people and the planet.

An equal opportunity employer, Haymarket Media does not discriminate in hiring or terms and conditions of employment because of an individual's race, color, religion, gender, gender identity, national origin, citizenship, age, disability, sexual orientation, marital status, or any other protected category recognized by state, federal, or local laws.

You can view our open positions on our website US careers section: www.Haymarket.com

California Applicants may view Haymarket Media, Inc.'s Privacy Statement for California Residents here .