Power BI Developer

Job Title: Power BI Developer with Azure, SSIS and Python/PySpark Duration: 12 months Location: Queens, NY (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)