Hybrid Data Analyst: Client Insights & Automated 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

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,