Sr. BI & Analytics Analyst
Digital Media Solutions · United States
- Hybrid
- Full-time
- $140,000 / year
- United States
Job highlights
- Owns profitability performance Single Source of Truth.
- Works with large datasets AWS and DataBricks.
- Transforms data into actionable business insights.
- Sets data modeling standards and mentors analysts.
- Partners with Finance, Technology, and Business leaders.
About the role
Sr. BI & Analytics Analyst
Digital Media Solutions (DMS) is a performance-driven digital marketing company that connects consumers and brands through data, technology, and proprietary media platforms. Our systems power high-volume consumer acquisition across multiple verticals, processing large-scale traffic and real-time decisioning in dynamic market environments.
About This Role
We're looking for a Sr. BI & Analytics Analyst to own and evolve our Single Source of Truth for profitability performance. In this role, you'll work with large-scale datasets across AWS and DataBricks, transforming the data into actionable insights for our business units, revenue operations, and senior leadership teams. As a senior member of the analytics team, you'll set standards for data modeling, mentor other analysts, and partner closely with Finance, Technology, and Business leaders to ensure our data is reliable and translated into insights that drive product performance, revenue visibility, and strategic decision-making.
Why Join DMS?
At Digital Media Solutions, you'll work with systems that process millions of high-intent consumer signals across web, email, push, and voice channels. In this role, you'll define and evolve the company's Single Source of Truth for signal activity, revenue attribution, and product performance, shaping how the business measures, analyzes, and acts on its data. You'll play a leading role in defining the metrics and data models the company relies on to understand performance and drive strategic decisions.
You'll work with large-scale datasets and modern analytics tools while partnering closely with Finance, Technology, and Business leaders to turn complex signal data into insights that guide product and revenue strategy. If you enjoy owning core business metrics, working with high-volume event data, and building analytics that directly influence how a business operates, this role offers the opportunity to do exactly that.
Responsibilities
Data Centralization:
- Design and write complex SQL queries to aggregate auction data AWS.
- Structure large-scale event data into a centralized data warehouse.
Single Source of Truth:
- Build and maintain data models that define core business metrics.
- Ensure Finance, Technology, and Business teams are working from consistent and reliable data.
Reporting & Looker Visualization:
- Lead the transition from legacy reporting tools to Looker.
- Develop LookML models and dashboards tracking signal volume, API performance, and customer activity trends.
Cross-Functional Analytics:
- 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.
Data Governance:
- 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.
Requirements
Experience:
- 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.
Technical Skills:
- 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.
Analytical & Business Skills:
- 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.
Preferred Qualifications:
- 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.
Compensation:
The anticipated annual base salary range for this position is $135,000-$145,000. Actual compensation may vary based on work experience, education, and skill level.
Key skills/competency
- Business Intelligence
- Data Analytics
- SQL
- AWS
- DataBricks
- Looker
- Data Modeling
- Reporting
- Financial Metrics
- Data Governance
Skills & topics
- BI Analyst
- Analytics Analyst
- Sr. BI Analyst
- Business Intelligence
- Data Analytics
- SQL
- AWS
- DataBricks
- Looker
- Data Modeling
- Reporting
- Finance Analytics
- Revenue Attribution
- Data Governance
How to get hired
- Tailor your resume: Highlight 5+ years in BI/analytics, SQL expertise, and AWS/DataBricks experience.
- Showcase Looker skills: Emphasize experience building dashboards, data models, or migration leadership.
- Quantify achievements: Use numbers to demonstrate impact on profitability and business metrics.
- Prepare for technical questions: Be ready to discuss complex SQL queries and data modeling strategies.
- Demonstrate cross-functional collaboration: Highlight experience partnering with Finance, Tech, and Business stakeholders.
Technical preparation
Behavioral questions
Frequently asked questions
- What are the key technical skills required for the Sr. BI & Analytics Analyst role at Digital Media Solutions?
- The Sr. BI & Analytics Analyst role at Digital Media Solutions requires advanced SQL skills for querying large datasets, experience with cloud data environments like AWS and DataBricks, and proficiency in Looker for building dashboards and data models. Experience with event-based data, API logs, or marketing data is also crucial.
- What kind of datasets will I be working with as a Sr. BI & Analytics Analyst at DMS?
- As a Sr. BI & Analytics Analyst at DMS, you will work with large-scale event-based data, including auction data, signal volume, API performance, customer activity trends, and financial data related to unit economics and revenue attribution. You will be responsible for structuring and transforming this data for profitability analysis.
- What is the 'Single Source of Truth' that the Sr. BI & Analytics Analyst will own at Digital Media Solutions?
- The 'Single Source of Truth' that the Sr. BI & Analytics Analyst will own at Digital Media Solutions refers to the centralized and reliable data repository that defines core business metrics for profitability performance. This includes signal activity, revenue attribution, and product performance, ensuring all teams work from consistent data.
- Does Digital Media Solutions offer opportunities for mentorship or leadership in this Sr. BI & Analytics Analyst role?
- Yes, as a senior member of the analytics team, the Sr. BI & Analytics Analyst will have the opportunity to set standards for data modeling and mentor other analysts. Experience in mentoring analysts is also listed as a preferred qualification.
- What is the salary range for the Sr. BI & Analytics Analyst position at Digital Media Solutions?
- The anticipated annual base salary range for the Sr. BI & Analytics Analyst position at Digital Media Solutions is $135,000 to $145,000, depending on experience, education, and skill level.
- What are the expected career growth opportunities for a Sr. BI & Analytics Analyst at Digital Media Solutions?
- This role offers significant growth opportunities by allowing you to shape how the business measures and acts on data, play a leading role in defining key metrics and data models, and directly influence product and revenue strategy. Your work will directly impact business operations and strategic decision-making.