Data Analyst

Association Member Benefits Advisors; Italia; Ibrido; EUR 40.000 - 60.000; Tempo pieno

Vantaggi offerti da questo lavoro

Medical, dental, and vision insurance

401k Matching

Generous time off

Descrizione del lavoro

AMBA is seeking a talented Data Analyst to join our IT team in Italy. You will design semantic models in Azure Fabric, build Power BI reporting, and deliver trusted data insights to stakeholders across the organization.

The role emphasizes hands-on data modelling, collaboration with data engineers, and ownership of the semantic layer from design to deployment. A hybrid work arrangement and opportunities for growth are available within a dynamic nonprofit environment.

Competenze

• Experience building semantic models and star schemas.
• Strong SQL skills in SQL Server or similar platforms.
• Proficient in DAX and Power Query (M).
• Experience with cloud analytics platforms and data integration.
• Ability to document design decisions for non-specialists.

Mansioni

• Design and build semantic models in Azure Fabric on top of consolidated data.
• Own handoff from data engineering for cleansed data to semantic layers.
• Build and maintain Power BI reporting with DAX measures and row-level security.
• Shape API access patterns and AI/analytics use cases for downstream consumers.
• Document architecture and modeling decisions for team longevity.
• Collaborate with and mentor the data engineering team.

Conoscenze

Semantic data modeling

SQL

DAX

Power Query

Azure Fabric

Cloud analytics

Documentation

Mentoring/data engineering support

Strumenti

Azure Fabric

Synapse

Databricks

Tabular Editor

Descrizione del lavoro

Data Analyst

Azienda : Association Member Benefits Advisors
Tipo Lavoro : Full Time
Location: Italy

AMBA 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.

About AMBA

Since 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

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.

About the Role

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.

Requirements

• 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.

AMBA 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.