Senior Business Intelligence Analyst

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

📋 Description

• Lead the design and development of Power BI reports and dashboards for both internal teams and client-facing stakeholders.

• Convert intricate data structures into user-friendly, interactive report layouts and navigation systems.

• 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 an external development partner.

• Complete remaining platform parity tasks and develop market and dealer intelligence features, including benchmarking, trend analysis, and segmentation.

• Facilitate automated alerts that link digital campaign activities to subsequent business outcomes.

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

• Create budget tracking and spend allocation logic based on the fiscal calendar.

• Transition legacy pacing views into automated alerts within Power BI.

• Provide leadership-level insights on key account metrics.

• Oversee the health and hygiene of contact data across essential business systems.

• Develop and maintain frameworks for audience segment identification and scoring.

• Monitor inbound and outbound data flows across reporting and paid media systems.

• Implement data pipeline monitoring and alerting for synchronization failures, dropped identifiers, and match-rate degradation.

• Act as the primary point of contact for Digital reporting, dashboard adoption, and analytics requirements.

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

• Report directly to the SVP, 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.

• Advanced skills in Microsoft Fabric / Power BI report and dashboard development.

• Strong visual design skills and a keen sense of user experience.

• Proficiency in report-level DAX and interactive/navigation features.

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

• Experience building Power BI reports at scale for both internal and client-facing audiences.

• Familiarity with campaign pacing and budget alerting logic for paid media services.

• Experience in taking over and enhancing vendor- or agency-developed reporting platforms.

• Proficient in T-SQL in cloud data warehouses such as MySQL, BigQuery, Snowflake, Redshift, and OneLake.

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

• Understanding of SSO, embedded BI security models, RLS, RBAC, and report-level authorization.

• Experience with CRM reporting and Salesforce Sales Cloud objects.

• Familiarity with data pipeline monitoring, identity resolution, and match-rate concepts.

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

• Ability to communicate analytics findings and priorities effectively to leadership, non-technical stakeholders, and clients.

• Capacity to work independently and mentor reporting practices.

• Preferred: Microsoft Fabric / Power BI certification.

• Preferred: Experience with MySQL databases.

• Preferred: Background in market intelligence, competitive benchmarking, or industry data products.

• Preferred: Experience across multiple paid media platforms.

• Preferred: Familiarity with third-party external data connectors and unified data models.

• Preferred: Experience in B2B media or data companies.

• Preferred: Experience coordinating with CRM, identity, or data engineering functions.

🏝️ 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.

• Remote work opportunities.

• Casual dress work environment.

• Physical fitness reimbursement.

• Discounts on various events, travel, and dining.

• Additional compensation may include bonuses and equity.