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
Events • Food • Travel • Hospitality • Hotels & Resorts
Manages event planning and execution from pre-event preparation through post-event follow-up. Serves as the primary client contact, resolves issues, develops creative menus and catered experiences, solicits new business, prepares proposals, negotiates contracts, maintains client relationships, and coaches team members to deliver high-quality hospitality and maximize event revenue.
Gaming
Designs and supports AWS back-end services for Wizard of Oz Slots, develops PHP gameplay functionality, and maintains CI/CD pipelines and infrastructure-as-code tooling. Responsibilities include load testing, infrastructure optimization, monitoring, escalation support, code quality, process improvement, and mentoring engineers. The role requires experience operating high-traffic, low-latency systems, working with SQL and NoSQL databases, and collaborating in a distributed team.
Top Skills:
AWSChefCi/CdInfrastructure As CodeJenkinsMicroservicesNoSQLPHPSQLTerraformVue
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
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
