Power BI Developer with Azure, SSIS and Python/PySpark

Looking 12+ years of experience. Must be local to NY/NJ

Job Title: Power BI Developer with Azure, SSIS and Python/PySpark

Duration: 12 months(37.5 hrs. per week)

Location: Queens, NY(Day 1 onsite)

Position Summary -

We are seeking a hands-on Consultant with strong Azure ETL experience and advanced Power BI development skills. They are required to have experience modernizing legacy Microsoft BI environments (including SSIS). This is not an SSIS-only role.

The consultant will design, modernize, and enhance enterprise data and analytics solutions supporting Cyber Security, Physical Security, Electronic Security and Police operations.

This role includes evolving legacy SQL Server/SSIS-based processes into modern Azure data architectures while designing scalable new ETL/ELT pipelines and delivering executive-level analytics solutions.

The consultant will work directly with stakeholders to deliver production-grade reporting and analytics capabilities across multiple enterprise systems. This requires architectural thinking and hands-on technical execution.

Core Responsibilities

Candidates must have direct experience building enterprise-grade ETL pipelines and executive Power BI dashboards.

Design and implement modern ETL/ELT pipelines in Azure

Assess and refactor existing SSIS packages as part of broader modernization efforts

Architect Lakehouse / Medallion data models

Develop optimized dimensional data models (star schema)

Integrate data from SQL Server, Oracle, APIs, and security platforms

Design and deploy enterprise Power BI dashboards

Build paginated reports using Power BI Report Builder

Optimize DAX and dataset performance

Implement Row-Level Security (RLS)

Support CI/CD and DevOps deployment processes

Produce technical documentation and data lineage artifacts

Engage directly with executive stakeholders

Required Technical Skills (Must-Have)

Data Engineering & Architecture

Strong ETL/ELT design and optimization experience

Advanced SQL (expert-level required)

Python / PySpark

Dimensional data modeling (star schema required)

REST API integrations

Azure Data Stack

• Azure Data Factory
• Azure Databricks
• Azure Synapse Analytics
• Azure Data Lake Storage

Microsoft Data Platform

Experience with SQL Server data warehouse environments

Working knowledge of SSIS and experience modernizing or migrating SSIS workflows to Azure-based solutions

Power BI

Power BI Desktop (expert-level)

Advanced DAX

Executive dashboard development

Paginated reports (Power BI Report Builder)

Data Gateway configuration

Incremental refresh

Row-Level Security (RLS)

Nice to Have

Microsoft Purview

Terraform (Infrastructure-as-Code)

Orchestration tools (Airflow or equivalent)

Security systems data integration experience

Experience with C# / .NET web application development (for integration with internal systems or APIs)

Experience Requirements

7+ years of hands-on data engineering / analytics delivery

Demonstrated experience building production data pipelines in Azure

Proven experience delivering executive-facing Power BI solutions

Experience working in complex enterprise environments