Sr. Analyst, Data & Analytics

Quigley-Simpson & Heppelwhite•New York, NY

2d•Remote

About The Position

Quigley-Simpson seeks a Senior Analyst, Data & Analytics, to research, analyze, and report on omnichannel media, including market trends, competitors, customers, and campaign performance. The candidate should have marketing analytics experience across multiple channels and knowledge of aligning KPIs with the purchase funnel. Proficiency in rules-based attribution models and SQL for database exploration is required. The Senior Analyst will collaborate with multidisciplinary teams in a fast-paced environment to deliver analytics solutions to clients.

Requirements

4-5+ years professional experience
2+ years working in a client-focused environment such as an ad agency or adjacent business
Experience with paid media ecosystem—customer journey/marketing funnels, retargeting audiences, etc.
Proven analytics background: ideally focused on campaign performance analytics. Big plus: demonstrated knowledge of A/B, MVT, and other forms of testing
2+ years of experience working with a data visualization tool and experience designing dashboards for different stakeholders with different needs and goals. Experience with Tableau/Power BI (or similar tools, e.g., Spotfire a big plus)
Experience with web analytics platforms and using them to analyze paths to conversion and to generate insights around the impact of marketing
Experience providing analysis and insights for one or more of the following: web and search traffic; email messaging statistics; social media trends; and offline media impact
Experience conducting ROI analysis, making optimization recommendations and developing key insights for online and/or offline advertising
Working knowledge in SQL and one of these programming languages: Python or R (SQL tests will be administered to all candidates)
Ability to troubleshoot data issues
Knowledge of Brand Impact measurement
Experience with reporting automation
Has successfully managed projects through partnerships with cross-functional teams, both internal and external
Ability to diplomatically work with a wide range of personalities
Highly detail-oriented and organized with the ability to multi-task and work in a very fast-paced environment

Responsibilities

Mentor junior analysts
Manage assigned client engagements and workloads
Manage data visualization platforms, including managing the API connections and offline data inputs, updating data models as needs change, establishing templates and best practices for the organization
Understand and help define the Key Performance Indicators (KPIs) of campaigns and marketing activities and derive relevant metrics, targets, and data collection strategies
Devise and own analytics and reporting processes, including requirements-gathering in collaboration with internal stakeholders
Execute data visualization and dashboards in Tableau
Function as a liaison between account teams and technical resources to translate business needs into data infrastructure and reporting approach
Analyze collected data and present results, including hypothesis development
Perform analytical “deep dives” as needed
Monitor and provide optimizations recommendations for omnichannel campaigns
Design and conduct A/B testing and make recommendations for optimization
Ability to learn new techniques, concepts, and information quickly
Supportive of teammates and respectful
Emotional maturity with day-to-day client and internal interactions
Open-minded to new ideas and an appetite for learning
Adaptable with an appetite for innovation and operational efficiency