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
eCommerce • Fashion • Retail • Sales • Wearables • Design
Provides personalized styling advice, product recommendations, and sales support in a Kate Spade retail environment. Engages customers, creates complete looks, processes POS transactions, maintains stockroom organization, supports omnichannel selling, and delivers strong customer service. Requires flexible scheduling, teamwork, product knowledge, and the ability to lift up to 50 pounds occasionally while maneuvering throughout the sales floor and stockroom.
Top Skills:
Omnichannel SellingPoint-Of-Sale (Pos) SystemsSocial MediaVirtual Selling
eCommerce • Fashion • Retail • Sales • Wearables • Design
Supports store sales and operations by welcoming customers, operating POS and cash wrap, recommending products, processing shipments, organizing stock, replenishing merchandise, executing visual merchandising, maintaining housekeeping standards, and following loss prevention policies. Requires flexible scheduling, physical stockroom and sales-floor work, strong customer service, communication, organization, and retail technology skills.
Top Skills:
Cash Register SystemsInternetIpadLaptopMobile PosPosWalkie-Talkie
eCommerce • Fashion • Retail • Sales • Wearables • Design
Supports store sales and operations by welcoming customers, operating POS and cash wrap, recommending products, processing shipments, replenishing inventory, maintaining stockroom and sales-floor standards, supporting visual merchandising, and following loss-prevention procedures. Requires strong customer service, communication, organization, multitasking, fashion awareness, basic computer and POS skills, schedule flexibility, and the ability to lift up to 50 pounds occasionally.
Top Skills:
Cash Register SystemsInternetIpadLaptopMobile PosPos SystemsWalkie-Talkie
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
