Azure Data Engineer

Job Title: Azure ETL with Power BI

Location: Jamaica, NY 11427 (Occasional visits to other client facilities).

Duration: 12 Months Contract (possibilities of hybrid after 3 months).

Interview Process: virtual and/or in-person

Work Hours: 37.50 hours/Week

NOTE: Hybrid work will be available after 3 months of exceptional performance determined by the manager (3 days onsite, 2 days remote). The primary work location will be at Jamaica station however visits to other client facilities in Manhattan will be required.

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

About Us:

InterSources Inc, is a Small, Woman, and Minority-Owned Business Enterprise, ISO/IEC 27001, SOC 2 Type 2 certified company with massive 18 years of diversified experience in providing IT Consulting Services, Artificial Intelligence, Data Analysis, Application Development, Cloud Services, Cybersecurity, Digital Marketing, ERP Management, Custom Software Development, Web Development, UI/ UX Design, System Integration, QA Support etc. We make reasonable accommodations for clients and employees, and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud and Oracle partner company.