W2 contract || Power BI Developer

Location: Princeton, NJ (Onsite from day one)
Duration: 12+ months (W2 contract)

About the role

We are seeking a highly experienced, hands-on Principal Power BI & Fabric Developer / Senior Data Engineer to lead the architecture, development, and optimization of enterprise-grade analytics solutions using Microsoft Fabric, Power BI, and robust SQL backend systems. The ideal candidate is a technical expert who leverages modern development practices (like Tabular Editor and GitHub Copilot) to deliver highly secure, performant, and scalable data models.

Responsibilities

• Design, build, and optimize scalable end-to-end data pipelines and advanced star-schema data models using Microsoft Fabric and Power BI.
• Implement enterprise-grade security protocols within Power BI, including Row-Level Security (RLS) and Object-Level Security (OLS) to safeguard sensitive data.
• Utilize external tools like Tabular Editor for advanced BIM model management, DAX scripting, and model optimization.
• Write, optimize, and maintain advanced SQL queries (leveraging complex Joins, Window functions, and indexing) for seamless data integration.
• Leverage Microsoft Fabric components (Lakehouses, Data Warehouses, Data Factory, OneLake, and DirectLake mode) to modernize data architecture.
• Connect, extract, and ingest data from various source systems using REST APIs.
• Integrate GitHub Copilot into daily workflows to accelerate code generation, debugging, and documentation for SQL, DAX, and scripts.

Requirements

• Minimum of 10 years of professional experience in Data Engineering, Business Intelligence, or Enterprise Analytics.
• Deep expertise in Power BI Desktop/Service, advanced DAX, deployment pipelines, advanced data modeling, and performance optimization.
• Proven experience implementing Row-Level Security (RLS) and Object-Level Security (OLS).
• Mastery of SQL engineering, including complex Joins, CTEs, performance tuning, and query optimization.
• Hands-on experience navigating and building within the Microsoft Fabric ecosystem.
• Proficiency with Tabular Editor (for managing tabular models) and REST APIs for data integration.
• Experience utilizing GitHub Copilot or similar AI pair-programming tools to optimize coding efficiency.