{"schemaVersion":"jobsearcher.job.v1","id":"4e034f2604509c8c5e63df8a","url":"https://jobsearcher.com/jobs/4e034f2604509c8c5e63df8a","canonicalUrl":"https://jobsearcher.com/jobs/4e034f2604509c8c5e63df8a","title":"Data Analyst","description":"Description:\nAMBA is seeking a talented Data Analyst to join our growing Information Technology Team! We are looking for someone with detail oriented skills who thrives in an agile, team-oriented environment.\n\nAbout AMBA\nSince 1981, AMBA has been a trusted provider of essential coverage for retired public servants nationwide. Our reach extends to diverse groups, including hardworking public employees, state retirees, educators, military personnel, trade professionals, firefighters, law enforcement, Unions, Alumni groups, Allied Healthcare, and other non-profit associations. As a full-service marketing and membership development company, we proudly offer outstanding insurance services to our vast network of 44 million members across 450+ associations in all 50 states\nBenefits\nComprehensive benefits package including medical, dental, and vision insurance, spending accounts, and other voluntary benefits.\nAnnual Bonus Program.\nCorporate 401k Matching.\nGenerous time off, 10 paid company holidays, sick time off, and paid parental leave.\nCommunity Involvement perks, including 1 paid day off each year to volunteer with a local charity of your choice and company volunteer events.\nSupport & development to cultivate your knowledge and continuing education to support your professional designations\nBusiness casual dress code.\nHybrid work arrangement.\n\nAbout the Role\nThree 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.\nWe'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.\nAn 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.\n\nThis 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.\nThe Day-to-Day\nDesign and build semantic models in Azure Fabric on top of our consolidated SQL Server data, balancing performance, usability, and governance.\nOwn the handoff from our data engineering team's cleansed, integrated data into consumable, well-modeled semantic layers.\nBuild and maintain Power BI reporting on these models, including DAX measures, row-level/object-level security, and deployment pipelines.\nHelp shape how the semantic layer serves consumers beyond Power BI — API access patterns and AI/analytics use cases.\nDocument architecture, modeling decisions, and processes so this knowledge lives with the team, not with a single person.\nPartner with and mentor our data engineering team on cloud and semantic-modeling concepts as they grow into this space alongside you.\nRequirements:\nSolid grounding in dimensional/semantic data modeling - star schemas, fact/dimension design, grain.\nWorking proficiency in DAX and Power Query (M).\nStrong SQL skills and hands-on comfort working directly in SQL Server.\nExperience 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.\nA track record of documenting your work and explaining technical decisions to non-specialists.\nPreferred Qualifications\nDirect experience with Azure Fabric (OneLake, lakehouse/warehouse concepts, Direct Lake mode).\nExperience with semantic model deployment and version control (Tabular Editor, Azure DevOps, deployment pipelines).\nExposure to notebooks, Python, or Spark for analytics workloads.\nInsurance or financial services domain experience.\nAMBA is an equal opportunity employer committed to providing a workplace free from harassment and discrimination. We celebrate the unique differences of our employees because that is what drives curiosity, innovation, and the success of our business. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, gender identity or expression, age, marital status, veteran status, disability status, pregnancy, parental status, genetic information, political affiliation, or any other status protected by the laws or regulations in the locations where we operate. We value diversity and the skills, knowledge, and experience that difference brings to our culture, attracting top talent with shared values and forming the foundation for a great place to work.","company":"Amba","rawCompany":"amba","city":"Denver","state":"CO","isRemote":false,"isActive":false,"createdAt":"2026-08-15T13:09:58.929Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-2051.01","title":"Business Intelligence Analysts","slug":"business-intelligence-analysts"},{"code":"15-2051.00","title":"Data Scientists","slug":"data-scientists"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"524298","title":"All Other Insurance Related Activities","slug":"all-other-insurance-related-activities"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Data Analyst","description":"Description:\nAMBA is seeking a talented Data Analyst to join our growing Information Technology Team! We are looking for someone with detail oriented skills who thrives in an agile, team-oriented environment.\n\nAbout AMBA\nSince 1981, AMBA has been a trusted provider of essential coverage for retired public servants nationwide. Our reach extends to diverse groups, including hardworking public employees, state retirees, educators, military personnel, trade professionals, firefighters, law enforcement, Unions, Alumni groups, Allied Healthcare, and other non-profit associations. As a full-service marketing and membership development company, we proudly offer outstanding insurance services to our vast network of 44 million members across 450+ associations in all 50 states\nBenefits\nComprehensive benefits package including medical, dental, and vision insurance, spending accounts, and other voluntary benefits.\nAnnual Bonus Program.\nCorporate 401k Matching.\nGenerous time off, 10 paid company holidays, sick time off, and paid parental leave.\nCommunity Involvement perks, including 1 paid day off each year to volunteer with a local charity of your choice and company volunteer events.\nSupport & development to cultivate your knowledge and continuing education to support your professional designations\nBusiness casual dress code.\nHybrid work arrangement.\n\nAbout the Role\nThree 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.\nWe'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.\nAn 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.\n\nThis 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.\nThe Day-to-Day\nDesign and build semantic models in Azure Fabric on top of our consolidated SQL Server data, balancing performance, usability, and governance.\nOwn the handoff from our data engineering team's cleansed, integrated data into consumable, well-modeled semantic layers.\nBuild and maintain Power BI reporting on these models, including DAX measures, row-level/object-level security, and deployment pipelines.\nHelp shape how the semantic layer serves consumers beyond Power BI — API access patterns and AI/analytics use cases.\nDocument architecture, modeling decisions, and processes so this knowledge lives with the team, not with a single person.\nPartner with and mentor our data engineering team on cloud and semantic-modeling concepts as they grow into this space alongside you.\nRequirements:\nSolid grounding in dimensional/semantic data modeling - star schemas, fact/dimension design, grain.\nWorking proficiency in DAX and Power Query (M).\nStrong SQL skills and hands-on comfort working directly in SQL Server.\nExperience 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.\nA track record of documenting your work and explaining technical decisions to non-specialists.\nPreferred Qualifications\nDirect experience with Azure Fabric (OneLake, lakehouse/warehouse concepts, Direct Lake mode).\nExperience with semantic model deployment and version control (Tabular Editor, Azure DevOps, deployment pipelines).\nExposure to notebooks, Python, or Spark for analytics workloads.\nInsurance or financial services domain experience.\nAMBA is an equal opportunity employer committed to providing a workplace free from harassment and discrimination. We celebrate the unique differences of our employees because that is what drives curiosity, innovation, and the success of our business. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, gender identity or expression, age, marital status, veteran status, disability status, pregnancy, parental status, genetic information, political affiliation, or any other status protected by the laws or regulations in the locations where we operate. We value diversity and the skills, knowledge, and experience that difference brings to our culture, attracting top talent with shared values and forming the foundation for a great place to work.","datePosted":"2026-08-15T13:09:58.929Z","dateModified":"2026-08-15T13:09:58.929Z","hiringOrganization":{"@type":"Organization","name":"Amba","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Denver","addressRegion":"CO","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"4e034f2604509c8c5e63df8a"},"url":"https://jobsearcher.com/jobs/4e034f2604509c8c5e63df8a"}}