Overview
Ad Results Media is seeking a BI developer to work within our Analytics department. This individual will report to the head of analytics and be will both be involved in analytics as well as support of the client services team. This role will be involved in supporting client analytic needs, developing client reporting tools as well as ad-hoc analytic projects. We are seeking a self-motivated, detail-oriented person who enjoys thinking through and creating solutions for complex problems. This person enjoys working in a fast-paced environment and wants to help build and shape the analytics department for an established yet growing, organization.
Responsibilities
- Work with media team on developing and maintaining weekly client reporting
- Work with analytics team on developing customer and industry level insights on the podcast space
- Working with client teams to address the analytical needs of our clients
- Perform quantitative and qualitative analysis of marketing programs for optimization opportunities and be comfortable communicating recommendations to internal stakeholders and clients
- Researching trends in Podcast and the digital marketing space to help management team set strategic priorities
- Creating user-friendly models / tools that can be standardized across the organization
- Acting as a firm expert on modelling and reporting tools
- Work with analytics, client and accounting teams on insuring cleanliness of input data
Requirements
- Bachelor’s degree required, Economics, Finance, Statistics, Mathematics or another STEM field preferred with at least 2 years’ experience in Analytics
- At least 1-2 years’ experience working with Python
- Expertise in visualization technologies including Tableau, Looker and others
- Hands on experience with programming languages like Java, Ruby
- Design, code, test, and aggregate results from SQL queries providing information to clients and employees
- Advanced ability to analyze and model business functions, processes and information flow within or between systems
- Must be a self-starter
- Be able to provide custom detail-oriented dashboards and reports utilizing both traditional and ad-hoc BI reporting tools
- Must be proficient in Excel using pivot tables, v-lookups, and functions
- Excellent communication skills
- Strong knowledge of Python Required