Sr Data Analyst

amsive; Deutschland; Vor Ort; EUR 70.000 - 86.000; Vollzeit

Benefits dieser Stelle

Dental, Vision, and Health Insurance

401(k) with company match

Paid Parental Leave

Zusammenfassung

Amsive is seeking a Senior Data Analyst to help build the next generation of our analytics platform within Microsoft Fabric. You will design semantic models, develop scalable analytics solutions, and create AI-enabled data experiences for business users across the organization.

Collaborating with Data Engineers, Solution Architects, BI professionals, and Marketing teams, you will transform enterprise data into trusted assets powering reporting, AI apps, and decision making.

Qualifikationen

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Statistics, Mathematics, Engineering, or related technical discipline.
• 3–5 years of experience designing analytical solutions using modern cloud data platforms.
• Strong experience with Microsoft Fabric, Microsoft Power BI, or comparable enterprise analytics platforms.
• Experience developing Power BI semantic models and writing DAX measures.
• Strong SQL skills with experience querying and transforming large datasets.
• Experience developing PySpark and Spark SQL solutions.
• Understanding of dimensional modeling and enterprise data warehouse concepts.
• Experience working with Git-based source control.
• Strong analytical thinking and problem-solving skills.
• Excellent communication skills with the ability to explain technical concepts to both technical and non-technical audiences.
• Demonstrated ability to work independently while collaborating effectively within a remote team.
• Experience with Microsoft Fabric Lakehouse architecture, Direct Lake semantic models, or Delta Lakes are preferred

Aufgaben

• Design, develop, and maintain Power BI semantic models that support enterprise reporting and self-service analytics.
• Develop scalable star schemas, measures, calculated columns, hierarchies, perspectives, and Row-Level Security.
• Optimize semantic models for performance, usability, and governance.
• Build reusable metrics and governed business logic shared across reporting solutions.
• Develop analytics solutions using Microsoft Fabric Lakehouse technologies.
• Write and optimize SQL, Spark SQL, and PySpark notebooks supporting analytics workloads.
• Partner with Data Engineers to improve data quality, performance, and reliability.
• Troubleshoot data pipelines, semantic models, and reporting issues across the platform.
• Design AI-enabled analytical experiences using Microsoft Fabric Data Agents and Azure AI technologies.
• Develop structured outputs (including JSON) that support internal web applications and AI-powered user experiences.
• Evaluate emerging AI capabilities and recommend practical applications that improve productivity and business value.
• Use AI-assisted development tools to accelerate delivery, improve quality, and automate repetitive work.
• Build dashboards that monitor Fabric capacity utilization, refresh performance, workload health, pipeline execution, and platform performance.
• Develop reporting that helps engineering teams identify performance bottlenecks and operational issues.
• Establish monitoring standards for enterprise analytics solutions.

Kenntnisse

Analytical thinking

Communication skills

Problem solving

Independent worker

Ausbildung

Bachelor's degree in Computer Science or related

Tools

Power BI

DAX

SQL

PySpark

Spark SQL

Git

Microsoft Fabric

Delta Lakes

Jobbeschreibung

Who We Are

At Amsive, we're more than just a performance marketing agency; we're a team that thrives on collaboration and innovation. We offer a supportive environment where personal growth is just as important as professional development. We're a team of passionate individuals ready to tackle challenges, learn from one another, and drive results. We believe in empowering our team members, providing them with the tools they need to succeed, and trusting them to lead the way. With decades of expertise and a commitment to integrated solutions, we don't meet the industry standard; we're setting it.

If you're looking for a place where your work matters, a career path you can grow on your terms, and a team that's as invested in your success as you are, Amsive is for you. We offer a unique blend of flexibility, growth opportunities, and a culture that values each individual. Join us, and be part of the team ready to welcome, support, and grow with you.

*We regret to inform you that currently, Amsive DOES NOT provide sponsorship opportunities.

This is a HYBRID position, 1 day in office per week. Our office is located in the Flatiron District in New York, NY

What we are looking for:

Amsive is seeking a Senior Data Analystto help build the next generation of our analytics platform within Microsoft Fabric.This is not a traditional reportingrole,youwill help design semantic models, develop scalable analytics solutions, build AI-enabled data experiences, and improve how business users consume data across our organization.

Working alongside Data Engineers, Solution Architects, Business Intelligence professionals, and Marketing teams,you'llhelp transform enterprise data into trusted, reusable assets that power reporting, AI applications, and operational decision making.We'relooking for someone who enjoys solving complex technical problems,embracesAI-assisted development, and constantlylooksfor better ways to build, automate, and deliver analytics.

What You Will Be Doing:

Semantic Modeling & Analytics

• Design, develop, andmaintainPower BI semantic models that support enterprise reporting and self-service analytics.
• Develop scalable star schemas, measures, calculated columns, hierarchies, perspectives, and Row-Level Security.
• Optimizesemantic models for performance, usability, and governance.
• Build reusable metrics and governed business logic shared across reporting solutions.

Microsoft Fabric & Data Engineering

• Develop and enhance analytics solutions using Microsoft Fabric Lakehouse technologies.
• Write andoptimizeSQL, Spark SQL, andPySparknotebooks supporting analytics workloads.
• Partner with Data Engineers to improve data quality, performance, and reliability.
• Troubleshoot data pipelines, semantic models, and reporting issues across the platform.

AI & Modern Analytics

• Design AI-enabled analytical experiences using Microsoft Fabric Data Agents and Azure AI technologies.
• Develop structured outputs (including JSON) that support internal web applications and AI-powered user experiences.
• Evaluate emerging AI capabilities and recommend practical applications that improve productivity and business value.
• Use AI-assisted development tools to accelerate delivery, improve quality, and automate repetitive work.

Operational Intelligence

• Build dashboards thatmonitorFabric capacityutilization, refresh performance, workload health, pipeline execution, and overall platform performance.
• Develop reporting that helps engineering teams proactively identify performance bottlenecks and operational issues.
• Helpestablishmonitoring standards for enterprise analytics solutions.

What We're Looking For:

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Statistics, Mathematics, Engineering, ora relatedtechnical discipline.
• 3–5 years of experience designing analytical solutions using modern cloud data platforms.
• Strong experience with Microsoft Fabric, Microsoft Power BI, or comparable enterprise analytics platforms.
• Experience developing Power BI semantic models and writing DAX measures.
• Strong SQL skills with experience querying and transforming large datasets.
• Experience developingPySparkand Spark SQL solutions.
• Understanding ofdimensional modeling and enterprise data warehouse concepts.
• Experience working with Git-based source control.
• Strong analytical thinking and problem-solving skills.
• Excellent communication skills with the ability to explain technical concepts to both technical and non-technical audiences.
• Demonstrated ability to work independently while collaborating effectively within a remote team.
• Experience withMicrosoft Fabric Lakehouse architecture,Direct Lake semantic models, or Delta Lakes are preferred

Additional Information:

• Salary starting at $90,000/yr, based on skills and experience
• Paid time off that includes Unlimited Vacation Time, Annual Sick Days, Mental Health Days, and Holidays
• Dental, Vision, and Health Insurance
• 401(k) with a company match program
• Paid Parental Leave

Other Duties

Pleasenotethis job description is not designed to cover orcontaina comprehensive listing of activities, duties or responsibilities that arerequired ofthe employee for this job. Duties,responsibilitiesand activities may change at any time with or without notice.

If you need anyassistanceseeking a job opportunity atAmsive, or if you need reasonable accommodation with the application process, please call [phone].

Amsive is proud to be an Equal Opportunity Employer. We are committed to building a supportive and inclusive environment for all employees.It isAmsive’scontinuing policy to provide equal employment opportunity and not to discriminate on the basis of race, color, religion, pregnancy or childbirth, marital status, national origin, ancestry or citizenship status, age, disability, sex, sexual orientation, gender identity, veteran status or any other characteristic protected by applicable federal, state or local laws. This policy applies to all aspects of employment, including (but not limited to) application for employment, recruiting, hiring, compensation, benefits, promotions and transfers, training, layoffs, rehires, termination of employment and all other terms and conditions of employment.

All offers of employment withAmsiveare contingent upon the successful completion of background checks, which may include criminal history and reference verification, conducted in compliance with applicable state, federal, and local laws.

As part of the Company's equal employment opportunity policy,Amsivewill also take affirmative action as called for by applicable laws and Executive Orders to ensure that minority group individuals, females, disabled veterans, recently separated veterans, other protected veterans, Armed Forces service medal veterans, and qualified disabled persons are introduced into our workforce and considered for promotional opportunities.