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.
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 Austin Tech Scene
Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center
