Data Analyst, Client Insights and Reporting
The Data Analyst, Client Insights and Reporting at Confidential Client is responsible for producing and automating client-facing reports and insights for medical communication digital programs. This role involves collaborating with business intelligence teams to enhance reporting capabilities, analyzing multi-source data to deliver actionable insights aligned with client KPIs, and supporting a high-growth analytics function within a hybrid work environment in New York.
About Careertakes
👉 Important disclosure: Careertakes is a third-party recruiting platform supporting this hiring process. If selected, you will be employed directly by our client, Media Production.
Applicants for this role may also receive access to additional matched opportunities through the Careertakes platform.
Role overview
This is a client-facing Data Analyst role focused on client insights and reporting for digital medical communications and marketing programs. You will join a growing Insights & Reporting function, help transition reporting in-house, increase automation, and deliver actionable dashboards and reports that support client KPIs and commercial teams. This position is based in New York, NY on a hybrid schedule (approximately 3 days/week in-office).
What You’ll Do
- Produce formatted weekly and monthly client reports aligned to client specifications and KPIs.
- Convert and combine data from multiple sources into standardized formats for reporting and analysis.
- Query and aggregate data (SQL / BigQuery) and transform datasets for downstream reporting.
- Build and maintain dashboards and visualizations (Looker, Tableau, Power BI) to surface actionable insights.
- Identify workflow steps ripe for automation; define requirements and partner with BI/development teams to implement automation.
- Perform reporting QA — identify outliers, data inconsistencies, and root causes; ensure accuracy and timeliness.
- Collaborate across Insights & Reporting, product, and client teams to maintain consistent SOPs and scalable processes.
- Use Python and other tools for analysis, ETL steps, and ad-hoc investigation to support client questions.
Qualifications
- BS or MS in a related field.
- ~3 years of relevant experience in analytics, business analytics, or product analytics.
- Strong SQL skills and hands-on experience with Google BigQuery.
- Proficiency in Python for data wrangling and analysis.
- Advanced Google Sheets / Excel (pivot tables, VLOOKUP, SUMIF/COUNTIFS, Power Query).
- Experience building and maintaining dashboards (Looker, Tableau, Power BI, or similar).
- Familiarity with Google Analytics and working with marketing/digital program data.
- Strong attention to detail, reporting QA experience, and ability to surface causes of extreme outliers.
- Excellent communication and collaboration skills; comfortable presenting insights to internal and client stakeholders.
- Curious problem-solver who asks the right questions and thinks creatively about data challenges.
What We Offer
- Competitive compensation — salary range: $70,000–$90,000 (salary will be commensurate with experience and qualifications).
- Hybrid work schedule with flexibility and a “work from anywhere” benefit for defined periods.
- Paid vacation, holidays, and sick time.
- Comprehensive medical, dental, and vision benefits.
- Competitive 401(k) options with generous company match.
- Life insurance, commuter benefits, employee referral awards, tuition reimbursement.
- Training and professional development opportunities.
- A collaborative, creative workplace and supportive team environment.
About the Confidential Client
Confidential Client is a specialist media and information organization operating in the Media Production industry, with a portfolio spanning healthcare professional content and business media. The client values high-quality content and data-driven products that help clients and audiences make better decisions. This role sits within a high-visibility Data, Analytics & Reporting area and is an opportunity to shape a fast-growing capability.
Equal Opportunity & Hiring Transparency
Careertakes and our client are Equal Opportunity Employers committed to building a diverse and inclusive workforce. We prohibit discrimination or harassment of any kind. To support a fair and efficient hiring process, AI tools may be used to assist with application review or resume screening. These tools do not replace human decision-making. Final hiring decisions are made by people.
If you have questions about how your data is used, please contact us directly.
Negotiate a higher salary! Check the salary ranges for this job type in your area.
View My Salary Range