Senior Data Analyst

Jobtailor; New York (NY); On-site; USD 110,000 - 140,000; Full time

Job summary

Jobtailor in New York, NY is seeking an experienced BI Engineer to design, develop, and maintain Power BI semantic models and analytics solutions using Microsoft Fabric Lakehouse technologies.

You will write SQL, PySpark, and Spark SQL, build scalable star schemas, and implement Row-Level Security while collaborating with data engineers to improve data quality and governance. Remote-friendly environment with strong emphasis on self-service analytics.

Qualifications

• Bachelor's degree in CS, Information Systems, Statistics, or related technical discipline.

Responsibilities

• Design, develop, and maintain Power BI semantic models that support enterprise reporting and self-service analytics.
• Develop scalable star schemas, measures, and calculated columns with RLS.
• Optimize semantic models for performance, usability, and governance.
• Build reusable metrics and governed business logic 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 and reporting issues across the platform.
• Design AI-enabled analytical experiences using Microsoft Fabric Data Agents and Azure AI technologies.

Skills

Power BI

SQL

PySpark

Spark SQL

Dimensional Modeling

Data Warehouse Concepts

Git-Based Source Control

DAX Measures

Education

Bachelor's degree in Computer Science or related field

Tools

Microsoft Fabric

Power BI

Job description

• 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 and enhance 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.
• Build dashboards that monitor Fabric capacity utilization, refresh performance, workload health, pipeline execution, and overall platform performance.
• Develop reporting that helps engineering teams proactively identify performance bottlenecks and operational issues.
• Help establish monitoring standards for enterprise analytics solutions.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Statistics, Mathematics, Engineering, or a 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

Core Competencies

Proficient in designing and developing Power BI semantic models and analytics solutions using Microsoft Fabric technologies. Strong expertise in SQL, PySpark, and dimensional modeling to enhance data quality and performance for enterprise reporting.

Highest-signal resume keywords

• Power BI Semantic Model Development
• Microsoft Fabric Lakehouse Technologies
• SQL and PySpark Proficiency
• Dimensional Modeling Expertise
• Analytical Thinking and Problem-Solving

ATS Optimization Keywords

Hard Skills

• Power BI
• DAX Measures
• SQL
• PySpark
• Spark SQL
• Dimensional Modeling
• Data Warehouse Concepts
• Git-Based Source Control
• JSON Development
• AI-Enabled Analytical Experiences

Soft Skills

• Analytical Thinking
• Problem-Solving
• Excellent Communication
• Collaboration
• Independence

Industry Keywords

• Enterprise Reporting
• Self-Service Analytics
• Performance Optimization
• Governance
• Monitoring Standards

Tools & Technologies

• Microsoft Fabric
• Microsoft Power BI
• Azure AI
• Data Agents
• Lakehouse Architecture