Reports To: Data Science Manager

Profile: Works within the Data Science Department to support Account Management in understanding and using analytics to manage client campaigns. Forecasts, models and identifies variables that could significantly impact media plans. Utilizes statistical and visualization tools to bring meaning to campaign result data. Keeps project scope, timeline, resources and functionality definition and status updated, communicated and vetted with stakeholders and realistic given business objectives and constraints.

Qualifications:

Bachelor’s degree in Statistics, Math or other relevant degree or additional experience

2 years experience in Data Science or Data Analytics including database and attribution skills

2 years advertising agency experience

Knowledge of Tableau or similar visualization software, SQL, Python, R and IBM SPSS desirable.

Role Accountabilities

Develop standardized reporting platform utilizing Tableau in conjunction with Business Intelligence, Media and Account Management stakeholders

Oversee development of SQL tables, views, queries and stored procedures to be used for visualization and analysis within Data Science as well as company wide

Research the impact and learnings of media variables on results and provide data management optimization for extraction, transfer and load (ETL)

Ensure Attribution data QA and attribution updates, reporting tasks are completed on time in alignment with client needs, most notably ANGI Home Services

Responsibilities:

Gather requirements and work with Account Management to produce analysis as requested and ongoing

Create forecast models as needed and provide guidance on forecasting and analysis to find statistically significant correlations to be utilized for media planning or creative optimization

Build Tableau dashboards to meet account management and data science needs from the SQL data source to the finished product

Design, create, maintain, and update end-use reports, visualizations, and data-product components, including dashboard templates for Account and Client reporting.

Present analysis internally and to clients

Create Macros for reporting efficiency

Helps to administer necessary SQL databases, tables, views, queries, stored procedures, functions, and other items to be used for visualization, analytics, and intelligence insights for employees across departments.

Develop internal training documentation and continuing development for Tableau

QA attribution presentations and results