Note: The job is a remote job and is open to candidates in USA. Digital Media Solutions (DMS) is a performance-driven digital marketing company that connects consumers and brands through data, technology, and proprietary media platforms. They are seeking a Sr. BI & Analytics Analyst to own and evolve their Single Source of Truth for profitability performance, transforming large-scale datasets into actionable insights for various business units and senior leadership teams.

Responsibilities

• Design and write complex SQL queries to aggregate auction data AWS
• Structure large-scale event data into a centralized data warehouse
• Build and maintain data models that define core business metrics
• Ensure Finance, Technology, and Business teams are working from consistent and reliable data
• Lead the transition from legacy reporting tools to Looker
• Develop LookML models and dashboards tracking signal volume, API performance, and customer activity trends
• Partner with Finance to measure unit economics, margin by signal type, and revenue attribution
• Partner with Technology teams to monitor signal delivery and data health using AWS logs and Datadog
• Partner with Business Units to build profitability views showing which signal channels drive the most value
• Maintain data integrity across Last Activity API and Activity Signal products
• Identify and resolve data discrepancies and latency issues before they impact reporting or billing accuracy
• Define and document analytics standards and best practices for the broader team

Skills

• 5+ years of experience in business intelligence, data analytics, or data engineering environments
• Demonstrated experience working with large-scale datasets and owning core business metrics end-to-end
• Advanced SQL with the ability to query large, complex datasets
• Experience working in cloud data environments such as AWS and DataBricks
• Experience building dashboards and data models in Looker (LookML) or leading a migration to Looker
• Experience working with event-based data, API logs, marketing, or streaming data
• Ability to translate large datasets into clear business insights and performance metrics
• Strong understanding of financial metrics such as LTV, CAC, and gross margin
• Ability to work cross-functionally with Finance, Engineering, and business stakeholders, and to influence at a senior level
• Familiarity with AWS / Snowflake for monitoring data pipelines and system performance
• Experience analyzing API products, signal data, or event-driven systems
• Experience mentoring analysts or setting team-wide analytics standards

Company Overview