Data Visualization - Digital Analytics

Optomi, in partnership with a leading health organization, is seeking a Data Visualization - Digital Analytics for their rapidly growing analytical team. You'd be building visualizations which are automated, interactive, actionable and accurate to help business partners improve the pace and quality of day-to-day decision making. You will be challenged to convert our many ongoing channel investments and tests into easy to understand visualizations that make it easy for the company to manage this level of marketing spend.

You'll will be viewed as a tableau SME and should be proficient in manipulating data using SQL in a cloud environment. Ideally, you will have a strong understanding of performance marketing reporting and consumer data as well as strong communication and demonstrated data storytelling skills.

WHAT YOU'LL DO:

• Work closely with the digital and media marketing team to define and document business logic (requirements) and data definitions to ensure shared understanding.
• Manage ad-hoc data requests from internal business partners, calculating all of our metrics/kpis in a timely manner to identify what can be automated, or develop self-service tools for these types of requests.
• Develop SQL to aggregate and explore data from multiple datasets to understand the possibilities and limitations within our data sets.
• Troubleshoot both independently and collaboratively with others, such as live development sessions and coding sessions, to solve problems and work on projects with the broader team
• Enable digital teams with self-service capabilities through publishing and maintaining curated data sources and developing automated reports/dashboards in Tableau.
• Communicate with stakeholders on various projects to gather requirements, document plans, collect feedback, execute, and present deliverables to achieve expected outcomes.
• Work collaboratively and cross functionally with other members of the data team to support data engineering, digital analytics, testing, data modeling, data visualization, retention analytics, customer insights/market research, data science/machine learning, etc.
• Brainstorm creative solutions to exploratory projects built around ambiguity, including running analysis to identify problems, understand root cause of trends, provide actionable insights and recommend solutions.
• Design, create, and operationalize business logic into source of truth data models in Enterprise Data Warehouse and surface them through self-service BI tools.
• Create complex yet elegant reports and dashboards that enable the marketing team to drill in and out to understand their marketing spend and their channel performance.

YOUR BACKGROUND AND SKILLS

• Proven skills in distilling complex topics into easy to understand data visualizations. Advanced Tableau data visualization skills preferred.
• Comfortable navigating large datasets, acquiring and cleansing data from multiple sources.
• Familiarity with B2C acquisition and subscription marketing concepts and metrics, including customer journeys, conversion funnels and critical reporting (acquisition, CAC, payback, retention rate, etc.).
• 4+ years of experience in marketing analytics, data science, BI or data insights roles, preferably in a direct-to-consumer, e-commerce or SaaS business.
• Experience developing operational reports and data visualizations for digital marketing teams.
• Hands-on experience working with structured and unstructured data in cloud-based environments, including BigQuery, Snowflake, RedShift, etc.
• Strong interpersonal, written communication, and organizational skills.
• Familiarity with marketing, CRM, social and ad platforms, such as Salesforce, Google Ads, Facebook, YouTube, Instagram, TikTok and others. Experience with partnership and affiliate marketing is a plus.
• Ability to be a self starter and work independently.
• Deep experience data modeling and performing SQL-based data transformation to support reporting and analytic needs.
• Ability to collaborate with partners to document key business needs into a clearly defined requirements document and project plan.
• A full life outside of work with personal passions and hobbies!