Senior Business Intelligence Analyst

This is a fully remote position, open to applicants in United States.

📋 Description

• Take charge of designing and constructing Power BI reports and dashboards for both internal digital staff and client-facing stakeholders.

• Convert intricate data structures and relationships into user-friendly layouts and navigation.

• Create report-level DAX measures, calculations, and reusable reporting components.

• Collaborate with IT and Data Engineering to establish reliable data foundations, semantic models, security protocols, and workspace architecture.

• Assume responsibility for a client-facing reporting platform transitioning from external development to in-house creation.

• Address platform parity requirements and develop market and dealer intelligence capabilities, including benchmarking, trend analysis, and category segmentation.

• Assist in automated alerting products that link digital campaign activities to subsequent business results.

• Manage internal dashboards and automated alerts for account performance, revenue, and campaign pacing.

• Develop budget tracking and spend allocation logic based on a fiscal calendar for flighted, intra-month campaigns.

• Transition legacy pacing views into Power BI automated alerts.

• Deliver leadership-level insights on key account metrics.

• Oversee contact record health and hygiene across essential business systems.

• Create and sustain audience segment identification and scoring frameworks.

• Supervise inbound and outbound data flows within Digital reporting and paid media systems.

• Implement monitoring and alerting mechanisms for sync failures, dropped identifiers, and match-rate decline.

• Act as the primary liaison for Digital reporting, dashboard adoption, and analytics needs.

• Collaborate with IT, Data Engineering, CRM, Identity, and Audience Development teams.

• Report directly to the SVP of Audience and Media.

⛳️ Requirements

• Bachelor’s degree in Business, Analytics, Computer Science, or a related field.

• 7 to 10 years of experience in business intelligence, analytics, or dashboard development.

• Expertise in advanced Microsoft Fabric / Power BI report and dashboard creation.

• Strong visual design and user experience sensibility.

• Proficient in report-level DAX and interactive/navigational features.

• Extensive knowledge of underlying data structures, relationships, and data types.

• Proven success in developing Power BI reporting at scale for various stakeholder groups.

• Experience in creating or maintaining campaign pacing and budget alerting logic for paid media services.

• Background in taking over and enhancing a reporting platform initially developed by an external vendor or agency.

• Proficiency in T-SQL across cloud data warehouses, including MySQL, BigQuery, Snowflake, Redshift, and OneLake.

• Hands-on experience with AWS or Azure cloud environments.

• Familiarity with SSO, embedded BI security models, RLS, RBAC, and report-level authorization/access management.

• Experience with CRM reporting and Salesforce Sales Cloud objects.

• Understanding of data pipeline monitoring, identity resolution, and match rate fundamentals.

• Working knowledge of GA4 and paid media platforms such as Meta, Google, StackAdapt, and Simplifi.

• Ability to articulate findings, analytics initiatives, reporting enhancements, and priorities to senior leadership, non-technical stakeholders, and clients.

• Capability to operate independently in a fast-paced, lean team and mentor reporting practices.

• Microsoft Fabric / Power BI certification is preferred.

• MySQL database experience is preferred.

• Experience with market intelligence, competitive benchmarking, or industry data products is preferred.

• Familiarity with multiple paid media platforms is preferred.

• Experience with third-party external data connectors and unified data models is preferred.

• Background in B2B media or data companies is preferred.

• Experience collaborating with CRM, identity, or data engineering functions is preferred.

🏝️ Benefits

• Medical, dental, and vision insurance.

• 401(k) retirement plan.

• Paid time off.

• Paid holidays.

• Life and disability insurance.

• Flexible work schedules.

• Generous paid time off.

• 13 paid company holiday observances.

• Opportunities for remote work.

• Casual dress work environment.

• Reimbursement for physical fitness expenses.

• Discounts on various events, travel, and dining.

• Additional compensation may include bonuses and equity.