Sr. Analyst, Data & Analytics Job at Quigley-Simpson & Heppelwhite in Los Angele

Candidates must live in CA, CO, FL, IL, MA, MI, MN, NC, NY TRI-STATE, OR, TN, TX, WASummary:

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.

Core Accountabilities:

• 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

Required Skills/Experience:

• 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

#LI-JM1

#LI-Remote