Data & Analytics Lead
TicketManager · Calabasas, CA · 1 mo ago
On-siteEducation$80k–$100k/yrFull-time
Responsibilities
- Power BI & Fabric
- 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 our 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 for cross-departmental analysis.
- Experimental Engineering: Be open to testing 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.
- You must be able to pivot from a long-term project to a 30-minute deep-dive to answer a pressing business question.
- Cross-Departmental Projects: Manage a rotating queue of projects from different teams.
- 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”
- Techically adaptable and resourceful, with the ability to quickly ramp on new tools across AWS, Azure, and emerging data technologies