Responsibilities

• Own the delivery of marketing analytics solutions end-to-end, including requirements gathering, SQL development, data modeling, dashboarding, QA, and stakeholder rollout
• Develop and maintain scalable datasets and reporting tables in Snowflake to support funnel performance, campaign measurement, and pipeline generation
• Build and manage Power BI semantic models and dashboards using strong data modeling practices (facts, dimensions, relationships, and grain)
• Standardize KPI definitions and reporting logic across Marketing, Sales, and Finance to ensure consistency and alignment
• Analyze marketing performance across the funnel, translating complex data into clear, actionable insights for technical and non-technical stakeholders
• Reverse-engineer and rationalize legacy dashboards and datasets, eliminating duplication and improving data quality and documentation
• Partner with IT, Data Engineering, and BI developers to improve data pipelines, validate outputs, and ensure business accuracy
• Support ad hoc analysis and executive reporting requests across campaigns, segments, and regions
• Collaborate with offshore or distributed BI development teams by providing technical specifications and QA oversight
• Promote best practices in SQL development, data modeling, and BI design across the organization

Requirements

• 6+ years of experience in data analytics, business intelligence, or analytics engineering roles
• Advanced SQL expertise, including building and optimizing datasets in Snowflake or similar platforms
• Strong experience with Power BI (or similar BI tools), including data modeling, DAX, and dashboard development
• Demonstrated experience working with complex or legacy data environments and improving data quality and consistency
• Solid understanding of data modeling concepts (fact and dimension tables, joins, grain, aggregation)
• Experience working with CRM and/or marketing data (e.g., Salesforce, marketing automation platforms)
• Strong communication skills with the ability to translate business needs into technical solutions and explain insights to non-technical stakeholders

Preferred

• Experience in B2B SaaS, healthcare technology, or revenue-focused analytics environments
• Familiarity with marketing funnel metrics (lead lifecycle, MQLs, pipeline, bookings)
• Exposure to marketing attribution models (first-touch, multi-touch, campaign influence)
• Experience collaborating with offshore or distributed development teams

Benefits

• Along with health and financial benefits, athenistas enjoy perks specific to each location, including commuter support, employee assistance programs, tuition assistance, employee resource groups, and collaborative workspaces — some offices even welcome dogs.
• We also encourage a better work-life balance for athenistas with our flexibility. While we know in-office collaboration is critical to our vision, we recognize that not all work needs to be done within an office environment, — full-time.
• In addition to our traditional benefits and perks, we sponsor events throughout the year, including book clubs, external speakers, and hackathons. We provide athenistas with a company culture based on learning, the support of an engaged team, and an inclusive environment where all employees are valued.