Data & Analytics Lead

AEG Presents

$80K — $100K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in a relevant field (Computer Science, Mathematics, Statistics, etc.).
  • 3-5 years in data analytics, BI, or data engineering roles.
  • Expert-level proficiency in Power BI, advanced DAX, and Power BI Fabric.
  • Strong experience with AWS (S3, Redshift) and/or Azure (Data Lake, Synapse).
  • Advanced SQL skills for complex queries across varying datasets.
  • Analytical mindset with ability to anticipate trends and data quality issues.
  • Experience in logistics, sports/entertainment, or high-growth SaaS preferred.

Responsibilities

  • Own and enhance the Power BI environment for performance and design.
  • Rapidly develop new dashboards to track business initiatives.
  • Write and troubleshoot complex DAX and Power Query for metric accuracy.
  • Manage and optimize the Data Lake environment (AWS or Azure).
  • Integrate data from various sources for cross-departmental analysis.
  • Respond to quick inquiries from leadership and pivot as needed.
  • Continuously search for innovative data visualization and reporting methods.

Benefits

  • 401(k) plan with company match.
  • Comprehensive health benefits including medical, dental, and vision.
  • Unlimited PTO for a work-life balance.
  • Collaborative in-office culture with catered lunches.
  • Quarterly company events and monthly happy hours.
Full Job Description
In order to be considered for this role, after clicking "Apply Now" above and being redirected, you must fully complete the application process on the follow-up screen.

The Role:

The Data & Analytics Lead is the "intelligence engine" for the entire organization. We are already a heavy Power BI shop; your mission is to take our existing footprint to the next level. You will manage our Data Lake (AWS or Azure), scale our Power BI Fabric implementation, and act as a high-speed technical partner for every department-from Sales to Fulfillment. This is a role for a curious, experimental builder who loves solving complex puzzles under tight deadlines and providing the "speed to insight" that keeps our executive team moving.

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 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. One day you're helping Finance with billing reconciliation; the next, you're helping Support track ticket deflection.
Curiosity & Experimentation
  • Stay Hungry: Constantly look for better ways to visualize data or automate reporting. We want someone who asks "What if we tried this?" instead of just following a ticket.
  • AI Integration: Explore how AI features within the Power BI/Fabric ecosystem (like Copilot for Power BI) can be used to speed up our 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
  • Interview Process: Multistage interview process with senior leaders across TicketManager to ensure strong alignment on role scope and expectations.
  • Events: Quarterly live event credits (we practice what we preach!), monthly happy hours, and volunteering
  • Perks: Fun, collaborative, in-office culture at our HQ with catered lunches and big company perks with the autonomy of a high-growth startup.

Similar Jobs

More Jobs at AEG Presents

More Information Technology Jobs

Find similar Data & Analytics Lead jobs: