Data Analyst

AMBA

Data Analyst designing and building semantic models in Azure Fabric for AMBA. Owning data integration and reporting responsibilities in a hybrid work environment.

Posted 7/10/2026full-time🇺🇸 United StatesMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

AzureCloudPythonSparkSQL

About the role

Key responsibilities & impact

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

Requirements

What you’ll need

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

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Dimensional Data ModelingDAXPower QuerySQLAzure FabricSemantic Model DeploymentVersion ControlTabular EditorPythonSpark

Soft Skills

DocumentationMentoringCommunication