Sr. SQL Analyst

  • Full-time

Company Description

About Moxie

Moxie is a modern marketing solutions agency that expertly leverages the value of data, content and technology to help our clients grow. We push the boundaries of what's possible to outperform the competition in the areas of strategy, creative, social marketing, media, analytics and technology development. Founded in 2000, Moxie has 300+ talented employees in Atlanta, Los Angeles, New York and Pittsburgh. Owned by global media giant Zenith — part of the Publicis Groupe — Moxie is able to quickly leverage cross-company areas of enterprise, talent, experience, resources and tools. Moxie's client roster includes Verizon Wireless, Verizon FiOS, Delta, Porsche, Ocean Spray, Wells Fargo, The Coca-Cola Company, and Ainsworth Pet Nutrition.

Job Description

This position will work in one of the largest and richest client datasets to uncover key insights that will shape overall communication and customer relationship strategy.  This position will bridge the gap between advanced technical knowledge (SQL, Teradata, big data platforms) and business acumen to not only pull data, but also understand and translate it into insight.  This is not a DBA position but rather an analyst with technical chops.

A person who is successful in this position is a storyteller with natural curiosity and understand complex data structures while still having a pulse on the business.  They will be comfortable telling the stories they uncover to key client stakeholders.

Primary Responsibilities include working closely with strategy and experience leads on variety of research and analysis tasks, defining cross-channel/cross-platform solutions, contributing to opportunity sizing and business case development, articulating business and functional requirements, engaging in strategic storytelling to align and inspire a wide range of internal and external stakeholders.

 

KEY RESPONSIBILITIES

  • Leveraging SQL/Teradata, this position will work in the client’s Enterprise Data warehouse to understand key customer behaviors and trends and translate those findings into strategic insights and visualizations using tableau and other visualization tools

  • Translate data through storytelling and data visualizations to communicate findings

  • Work closely with team members from various disciplines (CX, Strategy, Account Management, Behavioral Science, Emerging Trends) within the agency and the client to optimize and coordinate campaign strategies

Qualifications

Basic Qualifications

  • Intermediate/Advanced expertise in SQL and/or Teradata

  • Intermediate/Advanced expertise of Tableau

  • Understanding of email and other forms of digital data (e.g. site app etc…)

  • Advanced business acumen.  Being able to translate complex data into strategic insights

  • Demonstrable knowledge of analytics platforms and other business intelligence tools

  • Understanding of database concepts including normalization, and data integrity

 

Preferred Qualifications

  • Statistical tools (such as R, SPSS, SAS) and techniques e.g. segmentation, response modeling and lifetime value experience a plus

     

Experience

  • 2-4+ years of experience working in large datasets extracting insight (digital click stream and/or email data preferred)

 

Education

  • Bachelors

  • Masters/ MBA Preferred

Additional Information

All your information will be kept confidential according to EEO guidelines.

Privacy Policy