Analytics Engineer
Summary
Builds and ships internal reporting and full-stack web apps (Azure Static Web Apps, Container Apps, Functions) on top of a Microsoft Fabric medallion lakehouse, ingesting data from systems like Sage 300 CRE and UKG, while using AI tooling like Claude Code and MCP servers with evals. On-site role in Phoenix, AZ requiring 5-8 years of production experience.
? Build and ship reporting against the Gold layer, from the query through to the interface the business opens, and work the report request queue
? Vet the financial, schedule, and safety figures behind what you ship. Leadership acts on these numbers, and nothing goes out on an untested calculation.
? Design and build internal web applications on Azure Static Web Apps, Container Apps, and Functions with Entra ID authentication, front end through back end, and own hosting configuration, deployment, releases, and in-app user roles for what you build
? Build with Claude Code to our build standards across Python, SQL, JavaScript, and HTML/CSS, and review every line it generates before it reaches production
? Develop & maintain MCP servers, data they expose, and lead the shift from per source access to a lake first model where every application, report, and agent reads from Gold
? Write evals for every AI feature that ships, and keep them running as the feature changes
? Build ingestion from our systems of record, including Sage 300 CRE, UKG, Smartsheet, Samsara, ToolWatch, and Command Alkon, using Azure Data Factory pipelines and Fabric notebooks
? Build Silver and Gold tables inside the medallion design set by our Data Architect, and keep the models, measures, and definitions documented so one number means one thing company wide
? Own the data quality framework: schema validation, deduplication on business keys, business rules, reconciliation against source totals, with failures quarantined & alerted
? Ship through Fabric deployment pipelines and GitHub, Dev to Test to Prod, with unit tests gating merges and data validation assertions gating each promotion
? Handle secrets through Azure Key Vault and managed identity, and work within the separate masked and full fidelity PII paths the platform defines
? 5 to 8 years building and shipping production software, reporting, and data pipelines, including senior ownership of systems other people depend on
? Hands on production experience with an agentic coding tool. Claude Code strongly preferred; Cursor or Copilot experience transfers. Not casual use.
? Strong Python and SQL, plus real front end capability in JavaScript/TypeScript and HTML/CSS. You will be building interfaces, not just reviewing them.
? Experience building and deploying web applications, ideally Azure Static Web Apps, Container Apps, or Functions, including authentication and role based access
? A track record of delivering reporting end to end: understanding the business question, modeling the data, building the thing people open, and standing behind the numbers in it
? Hands on Microsoft Fabric, including OneLake, lakehouses, notebooks, and Data Factory pipelines, or Synapse and ADLS Gen2 experience you can carry directly into Fabric
? Building Silver and Gold tables in a medallion or layered lakehouse, including incremental loads and Delta or Parquet formats
? Data quality and testing inside pipelines, including unit tests in CI and assertion frameworks such as dbt tests or Great Expectations
? Git based CI/CD and release discipline: branch strategy, PR review, promotion gates, and environment config
? Practical LLM experience: prompt design, retrieval (RAG), tool calling, agent workflows, and evaluating whether an AI feature actually works
? Solid fundamentals in data modeling, API design, and permissions and access control
? Clear writing, since you will document models, definitions, and decisions for both engineers and executives
NICE TO HAVE
? Direct Claude depth beyond Claude Code: the Claude API, Claude Enterprise, MCP, subagents, skills, or hooks
? Building or migrating MCP servers, or comparable tool integration layers
? Azure Container Apps, Azure Functions, and Static Web Apps CI/CD
? Fabric deployment pipelines, deployment rules, and the Deployment Pipelines REST APIs
? Azure Key Vault and managed identity, Azure Monitor, and Log Analytics
? Microsoft Purview and data governance for financial and workforce data, including sensitivity labeling, lineage, and PII handling, plus NIST / CMMC awareness
? Construction ERP and field systems such as Sage 300 CRE, UKG, Command Alkon, or Samsara, or comparable internal operations tooling
Skills
- Agentic AI
- AI
- Analytics
- API
- Api Design
- Authentication
- Azure
- Azure Data Factory
- Azure Functions
- CI/CD
- Claude
- Claude Code
- Cmmc
- CSS
- Data Governance
- Data Modeling
- Data Pipelines
- Data Quality
- dbt
- Entra ID
- ERP
- Git
- GitHub
- HTML
- JavaScript
- Lakehouse
- LLM
- MCP
- Microsoft Fabric
- Nist
- Parquet
- Python
- REST
- Smartsheet
- SQL
- TypeScript
- Vault