Marketing Analytics Engineer

Podium exists to help local businesses win. Using Podium’s technology, local businesses are able to simplify the way they build their business and modernize the way they communicate with their customers – from collecting payments, facilitating online reviews, launching marketing campaigns, and much more.  

Our work and focus on local business and helping them to build thriving businesses has been recognized across the industry, including Forbes’ Next Billion Dollar Startups, Forbes’ Cloud 100, the Inc. 5000 (#13), and Fast Company’s World’s Most Innovative Companies. For more about our product, watch this video. Podium has a positive, inclusive, and supportive culture and was recently named one of Inc. Magazine’s Best Workplaces for 2021 (4 years in a row). We look for people who are curious, creative and are willing to do the work to be a little better every day. We also embody our company values in all that we do, which always starts with being Customer Obsessed, followed by Be a Founder, Zero Drama, and Enjoy the Ride. 

The Marketing Analytics Engineer role is critical within Podium with tremendous visibility across key stakeholders. This role is responsible for supporting marketing reporting by creating key datasets and strategically connecting various data sources to the data warehouse and BI tool. This includes working across various groups to understand how data is structured, working within the data warehouse and business intelligence platform to create datasets, and analyzing data for trends and insights. This role will work cross-functionally across marketing, business strategy, data science, and IT to drive impact for marketing at Podium through data-driven reporting and insights.

What you get to do in this role:

• Assemble large, complex data sets that meet functional business requirements
• Assist analyst teams in identifying the best data to use to answer business questions through data dictionary maintenance and overall data knowledge
• Assist analyst teams with data gathering and provide insight for improving SQL query construction
• Work to identify, design, and implement internal process improvements including: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Work with functional business leaders to integrate new data sources and software solutions into the reporting environment
• Work with marketing and multiple technical business teams to quickly diagnose, prioritize, and scope marketing data needs that will deliver insights to optimize the business
• Manage data strategy and analytics workflows to support marketing reporting development including centralization and processing of marketing cost data to support attribution and ROI reporting
• Drive standardization and automation in marketing performance reporting across analysis and reporting deliverables
• Ensure your numbers are air-tight by performing individual quality control, checking with relevant data owners, and cross-referencing findings against secondary sources

In order to be successful, the ideal candidate will have

• 4+ years of Advanced SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
• Knowledge of modern data pipeline architecture, e.g. AWS, Snowflake, et
• Strong data visualization and dashboarding experience (Tableau, Domo)
• Experience building and optimizing data pipelines, architectures, and data in a near real-time environment
• Experience working with data ingestion tools or API integrations to pull data from and push data into various business software solutions, e.g. Marketo, Salesforce, Google Ads, 
• Experience performing root cause analysis on internal and external data and processes to provide required data to analysts in answering business questions
• Experience working with business process owners and analysts to create and maintain purpose-built data infrastructure
• Experience supporting and working with cross-functional teams in a dynamic environment
• Strong ability to translate stakeholder requests into technical requirements to surface impactful end-state analyses, reports and insights
• Degree in Computer Science, Math, Statistics, Engineering, Economics, Business, or hands on job experience with data science or analytics
• You are committed to honesty and a diverse and inclusive workplace

BENEFITS

• Transparent culture
• Great opportunities for career growth
• Unlimited PTO
• 401k with a competitive matching contribution plan
• Great medical, dental, vision benefits
• A stellar onsite gym with local professional coaches, morning and night classes offered 
• Life insurance, long and short-term disability coverage
• Paid maternity and paternity leave
• Weekly free lunch, breakfast and smoothies; DoorDash stipend for remote employees
• Swag

Podium is an equal opportunity employer. Podium provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, national origin, sexual orientation, gender identity or expression, age, disability, genetic information, marital status or veteran status.