Data & Analytics Lead - Power BI & Data Lake Expert

TicketManager; Calabasas (CA); On-site; Full time

Job description

The Role

The Data & Analytics Lead is the 'intelligence engine' for the entire organization. Your mission is to elevate our existing Power BI footprint by managing the Data Lake (AWS or Azure), scaling Power BI Fabric, and providing high‑speed technical partnership across departments.

Responsibilities

• Power BI & Fabric Power‑User
  • Advance the Stack: Take ownership of a mature Power BI environment. Optimize existing dashboards for performance and design next‑gen visualizations in Power BI Fabric.
  • New Development: Rapidly build and deploy new dashboards that track emerging business initiatives across the organization.
  • Deep‑Dive DAX: Write and troubleshoot complex DAX and Power Query (M) to ensure metrics are accurate and performant.
• Data Lake Architecture & Management
  • Lake Ownership: Manage and optimize our Data Lake environment (AWS or Azure). Ensure data is clean, accessible, and structured for high‑performance reporting.
  • Cross‑Org Integration: Ingest data from disparate sources (Dynamics, Zendesk, Atlassian, and application data) into a unified layer that allows cross‑departmental analysis.
  • Experimental Engineering: Test new tools, connectors, or AI‑driven data processing methods to find the most efficient path to an answer.
• High‑Velocity Ad‑Hoc Analysis
  • The 'Human API': Act as the primary point of contact for quick questions from leadership, pivoting from long‑term projects to a 30‑minute deep‑dive to answer pressing business questions.
  • Cross‑Departmental Projects: Manage a rotating queue of projects from different teams.
• Curiosity & Experimentation
  • Stay Hungry: Continuously seek better ways to visualize data or automate reporting, asking 'What if we tried this?' rather than simply following a ticket.
  • AI Integration: Explore how AI features within the Power BI/Fabric ecosystem (e.g., Copilot for Power BI) can speed up internal workflows.

Desired Skills and Experience

• Bachelor's degree required (Computer Science, Mathematics, Statistics, or related field preferred)
• 3–5 years of experience in a data analytics, BI, or data engineering‑adjacent role
• Expert‑level proficiency in Power BI, including advanced DAX, Power BI Service administration, and experience with Microsoft Fabric and/or Lakehouse architecture
• Strong hands‑on experience with cloud‑based data platforms, including AWS (S3, Redshift) and/or Azure (Data Lake, Synapse)
• Advanced SQL expertise with the ability to write complex queries across large, disparate, and legacy datasets
• Demonstrated ability to identify trends, anomalies, and data quality issues proactively (strong analytical and statistical intuition)
• Experience in logistics, sports/entertainment, or high‑growth SaaS environments strongly preferred
• Proficiency in Python or R for advanced data manipulation and analysis preferred
• Portfolio or examples of impactful dashboard design that go beyond standard BI reporting (emphasis on storytelling and usability)
• Comfortable working in fast‑paced, in‑office environments that require real‑time collaboration and rapid iteration
• Able to prioritize speed and business needs in time‑sensitive situations, balancing 'good enough now' vs. 'perfect later'
• Technically adaptable and resourceful, with the ability to quickly ramp on new tools across AWS, Azure, and emerging data technologies

TicketManager Highlights

• Compensation: $80,000 to $100,000 Base Salary & Bonus Eligibility
• Location: Calabasas, CA (HQ), New York City, NY, or Mesa, AZ
• Reports to: COO
• Work Expectations: Role is In‑Office, Monday‑Friday
• Retirement: 401(k) & Company Match
• Health Benefits: Medical, Dental, Vision & Chiropractic
• Time Off: Unlimited PTO