Need candidates with prior MTA or any public transportation domain experience
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
8years 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.
Regards
Mohammed ilyas
PH - or Text - or you can share the updated resume at com
Additional Information :
All your information will be kept confidential according to EEO guidelines.
Remote Work :
No
Employment Type :
Contract
We provide Recruitment and Staffing services to many industries and domain through our innovative and customized solutions and passionate commitment to research. Ability to understand the hiring strategies, availability of talent and compensation benchmarking makes us proud hiring par ... View more