Develop SQL reporting tables, stored procedures, semantic-layer calculations, and internal analytics applications. Build Python/Flask backends and JavaScript/D3 interfaces while establishing strong data visualization and UX standards. Model data using facts, dimensions, and semantic layers; validate metrics, tune performance, review AI-assisted code, and explain technical and design decisions to stakeholders. Collaborate with Engineering on shared data assets.
Job Summary & Responsibilities
Summary
We are seeking a Business Intelligence Developer with good SQL skills and exceptional data visualization and UI/UX craft to join our Business Intelligence team within the Data department. The role helps Moxie build internal analytics tools that help teams make faster, better decisions with trusted data. This is a fully onsite position working out of the Irving, Texas HQ.
A core focus of this position is writing the SQL that builds our reporting tables and calculations, building the web applications that put that data in front of people, and raising the standard for how we visualize data and design the user experience.
Responsibilities
- SQL Development and Performance:
- Write and tune SQL, including stored procedures and pre-aggregated load procedures, to meet performance targets (p95 under 1 second).
- Handle report tickets and small data extracts.
- Data Modeling and Semantic Layer:
- Build fact and dimension tables and semantic-layer calculations (live and daily sources), sharing that work with Engineering.
- Own extensions to the semantic layer and the applications built on it.
- Validate new reports against existing reports and document metric definitions.
- Web Application Development:
- Build and maintain internal web applications (Python/Flask backends, JavaScript and D3 front ends).
- Review AI-assisted code for correctness, performance, and security before it ships.
- Data Visualization and User Experience:
- Choose the right chart, layout, and interaction for each question, and turn business requests into clear, accurate, easy-to-read interfaces that follow our brand standards.
- Set visualization and UX standards for the team and coach other developers on them.
- Collaboration and Communication:
- Work with Engineering, which owns ingestion, pipelines, and raw tables, on shared fact and dimension table work.
- Explain metric logic and design decisions to non-technical stakeholders.
Job Requirements
Experience:
- 3+ years in BI, analytics, or data development.
Preferred Qualifications:
- A portfolio or code sample showing exceptional data visualization and UI/UX judgment in a working web interface; this is the first thing we review.
- Good, proven SQL (CTEs, window functions, stored procedures, query tuning).
- Working dimensional modeling knowledge (star schema, grain, slowly changing dimensions).
- JavaScript, HTML and CSS, and Python (Flask or similar).
- Git-based workflows.
- Ability to explain metric logic and design decisions to non-technical stakeholders.
Nice To Have Qualifications:
- D3 or a comparable charting library; design tools such as Figma; accessibility practice.
- Power BI, DAX, or semantic model experience.
- Azure SQL, Azure App Service, Key Vault, or CI/CD with GitHub Actions.
- Snowflake, dbt, or a semantic layer tool.
- Experience using AI coding tools in a reviewed, tested workflow.
Moxie Pest Control Irvine, California, USA Office
18 Technology Dr, Suite 154, Irvine, United States, 92618
Similar Jobs
Fintech • Real Estate • Software • Financial Services • PropTech
Serves as primary legal advisor for home equity investment servicing across the full lifecycle, including regulatory compliance, default management, foreclosure, bankruptcy, REO, servicing agreements, homeowner communications, and product enhancements. Develops regulatory guidance, procedures, playbooks, and templates; manages outside foreclosure and bankruptcy firms; and advises operations and leadership on mortgage and consumer finance requirements.
Events • Food • Travel • Hospitality • Hotels & Resorts
Prepares menu items and cold food according to recipes and quality standards, manages multiple guest orders, and applies cooking techniques such as sauces, roasting, grilling, and plating. Inspects finished plates, maintains stocked and sanitary workstations, follows food safety and alcohol regulations, and may assist with training or minor supervisory duties.
Fintech • Mobile • Software • Financial Services
Manages consumer litigation, arbitrations, discovery, third-party claims, outside counsel, pleadings, mediations, legal spend, and litigation risk reporting. Provides strategic legal guidance across consumer, employment, investment, lending, and regulatory disputes while collaborating with business stakeholders and counsel. Requires a JD, active U.S. bar license, approximately four years of litigation experience, and knowledge of banking regulations.
Top Skills:
E-Discovery PlatformsLitigation Management Tools
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
