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)

Benefits

• health and financial benefits
• commuter support
• employee assistance programs
• tuition assistance
• employee resource groups
• collaborative workspaces
• some offices even welcome dogs
• flexibility/work-life balance
• events throughout the year (book clubs, external speakers, hackathons)