Note: The job is a remote job and is open to candidates in USA. AMBA is a trusted provider of essential coverage for retired public servants nationwide, and they are seeking a talented Data Analyst to join their Information Technology Team. The role involves designing and building semantic models, maintaining Power BI reporting, and mentoring the data engineering team in cloud and semantic-modeling concepts.
Responsibilities
- 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
Skills
- 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
- 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
Benefits
- Comprehensive benefits package including medical, dental, and vision insurance, spending accounts, and other voluntary benefits.
- Annual Bonus Program.
- Corporate 401k Matching.
- Generous time off, 10 paid company holidays, sick time off, and paid parental leave.
- Community Involvement perks, including 1 paid day off each year to volunteer with a local charity of your choice and company volunteer events.
- Support & development to cultivate your knowledge and continuing education to support your professional designations
- Business casual dress code.
- Hybrid work arrangement.
Company Overview