Business Intelligence Analyst
Posted
Summary
Business Intelligence Analyst on the Dallas Mavericks' Strategy & Analytics team, acting as an analytical consultant to Marketing. Day-to-day: writing advanced SQL against cloud data warehouses, building automated Power BI/Tableau/Looker dashboards, tracking KPIs like CAC, LTV and ROI, and analyzing multi-channel marketing campaigns.
JOB RESPONSIBILITIES:
The Business Intelligence Analyst (BIA) supports the Strategy & Analytics department by combining strategy, business intelligence, advanced analytics, data management, and operational support, serving as a high-impact analytical consultant to the Marketing department and leaders throughout the organization.
This role serves as a bridge between marketing strategy, data engineering, analytics, and sales. The ideal candidate will take ownership of transforming raw marketing, audience, and transactional data into building robust dashboards, and measuring the ROI of our marketing initiatives. They will further provide comprehensive data analysis for decision support, develop models to identify trends, patterns, and opportunities for business improvement, and continuously innovate to help us stay competitive with longer-term business initiatives.
The ideal candidate pairs a strong analytical mindset with excellent communication skills, a proven ability to collaborate across teams, and a passion for using data to drive engagement and revenue.
ESSENTIAL JOB FUNCTIONS AND RESPONSIBILITES:
- BI & Dashboard Development: Design, build, and maintain automated, scalable dashboards and reports to track key performance indicators (KPIs) such as CAC, LTV, ROI, and conversion rates.
- Campaign Performance & Analytics: Analyze the performance of multi-channel marketing campaigns (paid media, email, organic, web)
- Data Pipelines & Modeling: Partner with the data engineering team to ensure marketing data from various source systems (CRMs, ad platforms, web analytics) is accurately ingested, cleaned, and modeled for reporting.
- Ad-Hoc Analysis: Conduct exploratory data analysis to answer critical business questions from executive leadership and stakeholders.
CORE COMPETENCIES:
- Data Querying & Manipulation: Strong proficiency in SQL (writing complex queries, joins, and aggregations) to extract and manipulate data from cloud data warehouses.
- Data Visualization: Proven experience building clean, intuitive, and stakeholder-ready dashboards using modern BI tools.
- Data Modeling Concepts: Familiarity with relational databases, data warehousing concepts (e.g., star schemas), and how marketing data structures align.
- Statistical Basics: Understanding of A/B testing methodologies, statistical significance, and basic forecasting techniques.
- Analytical Curiosity: A natural urge to dig deeper into the “why” behind the data, rather than just reporting the “what”.
- Attention to Detail: High commitment to data integrity, validating reports thoroughly before presenting findings.
- Team Player: Self-starter passionate about helping lead the team toward advancing the business. Champion innovative ways to find growth by working within the team environment. Align with team to adopt and develop best practices.
SKILLS AND QUALIFICATIONS
- 2-4 years of experience in business intelligence, data science, or other highly analytical role. Experience within sports, entertainment, or a high-growth tech environment is preferred.
- Technical Stack includes, but not limited to:
- Advanced SQL - ability to write complex, performant queries and manage data transformations. Uses, but does not rely solely on, AI tools to improve efficiency.
- Marketing & Web Analytics: Google Analytics 4 (GA4) Adobe Analytics, and Google Tag manager (GTM).
- Marketing Platforms: Google Ads, Meta Ads Manager, HubSpot, Salesforce, SFMC, or Marketo.
- Data Visualization: Advanced capabilities in Power BI, Tableau, or Looker.
- Optional/Plus: Basic Python or R for data manipulation and modeling.
- Strong ability to solve problems and deal with ambiguity. Hypotheses driven and able to logically break down approach and assumptions.
- Team player, proactive, results-oriented, strategic thinker, highly organized, flexible, and strong analytical skills. Willingness to roll up sleeves and help as needed to advance the business.
- Strong communication skills and collaborative work style to work across multiple business teams to efficiently drive results and impact. Deadline-driven, organized, and able to multi-task.
- Ability to work in a team and on a standalone basis. Ability to develop a collaborative rapport with staff, partners, customers, clients, etc.
- Proficiency with AI tools, including OpenAI, Gemini, Claude, etc.
- Proficiency with MS Office applications including Excel and PowerPoint.
EDUCATION:
- B.S. or B.A. Degree or equivalent degree in a field of business analytics or related quantitative field and 2-4 years of applicable experience. Advanced degree preferred.
JOB TYPE: Full Time
The Dallas Mavericks provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.