Build and maintain ETL/ELT pipelines, cloud data warehouse models, dashboards, and reports. Ensure data quality, governance, lineage, and reliable metric definitions while translating stakeholder needs into actionable analytics. Support AI-enabled reporting, natural-language querying, anomaly detection, and governed LLM tools. Collaborate with business, IT, and engineering teams to automate reporting and improve self-service data access.
We're looking for a hybrid Business Intelligence Analyst & Data Engineer who can operate across the full data lifecycle — from building and maintaining reliable data pipelines to designing dashboards and reports that drive business decisions. This role sits at the intersection of data infrastructure and analytics: you'll own how data flows into our systems and how it's ultimately consumed by stakeholders across the organization.
This is a great fit for someone who enjoys both the technical rigor of data engineering and the storytelling/analytical side of BI work, and who wants ownership over an end-to-end data product rather than sitting in just one lane. AI-driven analytics is a growing part of our roadmap, so we're especially interested in candidates who are curious about applying AI/LLM tools to make data more accessible and self-service across the business.
Key Responsibilities
Data Engineering
- Design, build, and maintain ETL/ELT pipelines that integrate data from multiple source systems (CRM, ERP, project management tools, spreadsheets, APIs) into centralized data warehouses or data marts
- Ensure data quality, consistency, and integrity across pipelines through validation, testing, and monitoring
- Optimize data models (star/snowflake schemas) for reporting performance
- Automate manual data processes and reduce reliance on ad hoc spreadsheet work
- Manage data source connections, credentials, and refresh schedules
- Troubleshoot and resolve data pipeline failures, latency issues, and discrepancies
Business Intelligence & Analytics
- Build and maintain dashboards and reports (e.g., in Tableau, Power BI, or similar) that translate raw data into clear, actionable insights
- Partner with business stakeholders to gather reporting requirements and translate them into technical specifications
- Define and maintain a single source of truth for key business metrics (a data dictionary / metrics glossary)
- Conduct ad hoc analysis to answer business questions and support strategic decision-making
- Monitor dashboard usage and proactively improve reports based on stakeholder feedback
- Document data lineage, business logic, and calculation methodology for transparency and auditability
AI-Enabled Analytics
- Design and maintain data structures (clean schemas, semantic layers, metric definitions) that are well-suited for consumption by AI agents and natural-language query tools, not just human-facing dashboards
- Build or support AI-powered reporting assistants/chatbots that let stakeholders ask business questions in plain language and get accurate, governed answers
- Evaluate and integrate LLM-based tools into the analytics stack (e.g., automated insight generation, anomaly detection, natural-language-to-SQL interfaces)
- Establish guardrails for AI-generated analysis — certified data sources, citation of underlying data, and validation processes to ensure trustworthy outputs
- Stay current on AI/BI tooling trends and proactively recommend where automation or AI can reduce manual reporting work
Cross-Functional Collaboration
- Work closely with department leaders (Sales, Finance, Operations, Professional Services, etc.) to understand data needs and pain points
- Act as a technical liaison between business teams and IT/engineering on data-related initiatives
- Support the rollout of new tools, data sources, or automation initiatives (e.g., AI-powered reporting agents, workflow automation platforms)
Requirements
- Bachelor's degree in Computer Science, Data Science, Information Systems, Statistics, or a related field (or equivalent practical experience)
- 3+ years of experience in a data engineering, BI analyst, or analytics engineering role
- Strong SQL skills, including experience writing complex queries, optimizing performance, and working with large datasets
- Experience building and maintaining ETL/ELT pipelines (custom scripts, or tools like Fivetran, dbt, Airflow, Workato, or similar)
- Hands-on experience with a BI/visualization tool (Tableau, Power BI, Looker, or similar)
- Solid understanding of data modeling concepts (dimensional modeling, normalization, star schemas)
- Experience working with cloud data warehouses (Snowflake, BigQuery, Redshift, or similar)
- Strong analytical mindset with the ability to translate ambiguous business questions into structured data analysis
- Excellent communication skills — able to explain technical concepts to non-technical stakeholders
Preferred Qualifications
- Experience with Python or another scripting language for data manipulation and automation
- Familiarity with CRM/ERP systems (Salesforce, NetSuite) and how operational data flows from them
- Experience with API integrations and workflow automation platforms (Workato, Zapier, or similar)
- Hands-on experience building or integrating AI/LLM-powered tools (e.g., Claude, ChatGPT, Copilot) into data workflows — such as natural-language querying, automated report generation, or AI-driven data agents
- Familiarity with prompt engineering, retrieval-augmented generation (RAG), or agent-based architectures as applied to analytics
- Experience establishing data governance practices (certified data sources, metric definitions, documentation standards) suitable for both human and AI consumers
- Prior experience in a Professional Services, Finance, or Operations analytics function
Similar Jobs
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Lead technical pre-sales consulting for cybersecurity solutions across assigned territories. Conduct discovery workshops, product demonstrations, solution positioning, and strategic customer sessions. Partner with sales, product management, marketing, professional services, and executives to support revenue goals, develop customer relationships, provide product feedback, analyze competitors, and support industry events. Requires 10+ years of pre-sales or sales engineering experience and expertise with ServiceNow or cloud software solutions.
Top Skills:
AIArmisServicenowVeza
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Lead growth strategy and end-to-end execution for Atlassian’s Product Collection portfolio. Define customer problems, prioritize roadmaps, run experiments, analyze quantitative and qualitative insights, and drive adoption across products. Partner with Design, Engineering, Data Science, and GTM teams to deliver measurable outcomes. Mentor product managers and improve product discovery, delivery, and experimentation practices.
Top Skills:
A/B TestingFunnel AnalyticsSaaS
Artificial Intelligence • Consumer Web • Digital Media • Information Technology • Social Impact • Software
Lead the AI Quality engineering team while remaining hands-on building evaluation infrastructure, observability tooling, diagnostic systems, datasets, annotation workflows, and CI/CD pipelines for production AI agents. Run experiments across prompts, models, routing, caching, and agent harnesses to improve quality, latency, and cost. Partner with AI Core engineering and manage technical direction and team priorities.
Top Skills:
Ai AgentsBraintrustCi/CdLangsmithLlmsPythonRuby On Rails
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
