> Markdown version of [/jobs/ext/1249258-data-analyst](https://www.wearedevelopers.com/jobs/ext/1249258-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analyst - **Company:** Association Member Benefits Advisors, LLC - **Location:** United States - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Artificial Intelligence, Data Analysis, Microsoft Azure, Information Engineering, Database Queries, Digital Architecture, Python (Programming Language), Microsoft SQL Server, Power BI, Delivery Pipeline, Apache Spark, Powerquery, Build Management, Data Analytics, Software Version Control, Api Management, Databricks - **Published:** July 12, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=0594e199205066c3 ## About the Role * Solid grounding in dimensional/semantic data modeling - star schemas, fact/dimension design, grain. * Working proficiency in DAX and Power Query (M). * Strong SQL skills and hands-on comfort working directly in SQL Server. * Experience with at least one cloud analytics platform (Azure Fabric, Synapse, Databricks, or similar) - you don't need to be a Fabric expert on day one, but you've made the on-prem-to-cloud leap before. * A track record of documenting your work and explaining technical decisions to non-specialists. Preferred Qualifications * Direct experience with Azure Fabric (OneLake, lakehouse/warehouse concepts, Direct Lake mode). * Experience with semantic model deployment and version control (Tabular Editor, Azure DevOps, deployment pipelines). * Exposure to notebooks, Python, or Spark for analytics workloads. * Insurance or financial services domain experience. ## Description Three years ago, AMBA completed the largest acquisition in company history - nearly doubling our size in people and infrastructure almost overnight. Since then, our Data & Analytics team has been quietly doing some of the most consequential work in the company: consolidating two separate, aging reporting environments built around insurance policy administration into a single, trustworthy source of truth. We've settled on our approach. Data is cleansed and integrated in our on-premises SQL Server environment, then published into Azure Fabric, where we're building semantic models that will power everything from Power BI reporting to API integrations to AI-driven analysis. It's foundational infrastructure work with a clear, high-visibility payoff. An outside consultant has helped us stand up the Fabric and semantic-modeling side of this build. As that engagement winds down, we're looking for an Analytics Engineer to join the team permanently, absorb what's been built, and carry the next phase forward. This isn't a maintenance job. You'd be building a semantic layer from scratch, at a company genuinely staking its reporting future on it, with a clear growth path into skills currently held by an outside consultant - and real ownership from day one. The Day-to-Day * Design and build semantic models in Azure Fabric on top of our consolidated SQL Server data, balancing performance, usability, and governance. * Own the handoff from our data engineering team's cleansed, integrated data into consumable, well-modeled semantic layers. * Build and maintain Power BI reporting on these models, including DAX measures, row-level/object-level security, and deployment pipelines. * Help shape how the semantic layer serves consumers beyond Power BI - API access patterns and AI/analytics use cases. * Document architecture, modeling decisions, and processes so this knowledge lives with the team, not with a single person. * Partner with and mentor our data engineering team on cloud and semantic-modeling concepts as they grow into this space alongside you. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Cutting LLM Costs Without Cutting Quality: How to Beat Proprietary LLMs with Fine-Tuned Open Source](https://www.wearedevelopers.com/videos/100151-cutting-llm-costs-without-cutting-quality-how-to-beat-proprietary-llms-with-fine-tuned-open-source) - [Enabling intelligent logistics automation: home-grown Industrial IoT platform at Austrian Post](https://www.wearedevelopers.com/videos/2018-enabling-intelligent-logistics-automation-home-grown-industrial-iot-platform-at-austrian-post) - [OLTP in the Lakehouse: Redefining Data for AI Workloads](https://www.wearedevelopers.com/videos/2038-oltp-in-the-lakehouse-redefining-data-for-ai-workloads) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Navigating the AI Shift](https://www.wearedevelopers.com/magazine/629-navigating-the-ai-shift) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)