DESCRIPTION:
Duties: Synthesize information from data platforms, competitors and brand tracking, third party data, testing, analytic products, product features/baskets, and customer journeys into information that can be easily interpreted by broad business audiences. Develop commentary for dashboards and reports that highlight insights as a cohesive and actionable story. Maintain efficiency by partnering with the Technology team to improve systems and processes. Monitor dashboard and report usage and refine or decommission as appropriate. Provide Marketing teams with business and consumer insights to further define and refine target audience segments and expectations. Maintain a forward looking perspective on the media/consumer data landscape.
QUALIFICATIONS:
Minimum education and experience required: Master's degree in Business Administration, Analytics, Statistics, or related field of study plus 3 years of experience in the job offered or as a Quant Analytics, Reporting and Data Delivery, Data Analytics & Metrics Reporting, or related occupation.
Skills Required: This position requires experience with the following: Performance measurement in the financial services industry and translating quantitative information into actionable insights for both analytic and non- analytic staff; Designing and developing interactive Excel and PowerPoint reports with advanced functionalities including vlookup, index match, data analysis add-ons, pivots, VBA and VBScript; Developing and maintaining dynamic and interactive dashboards using Tableau or Qlik Sense and leveraging advanced visualization, ETL automation and ODBC connector; Automating the production of recurring-reports and dashboards using ETL techniques, SQL and Robotic Process Automation techniques such as UiPath; Performing data manipulation, data structuring, data design flow and query optimization using programming language such as Python and SQL using CTE, Windows functions, and DynamicSQL; Utilizing advanced techniques to process large data sets using data containers, multithreading, and multiprocessing in PySpark; Performing statistical analysis using machine learning methods including logistic regression, multivariate regression, classification techniques, attribution, cohort analysis, associative rule mining and predictive modeling.
Job Location: 383 Madison Avenue, New York, NY 10179.
Full-Time. Salary: $125,133 - $150,000 per year.