[Remote] Sr. BI & Analytics Analyst
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