Azure ETL Developer with Advance Power BI Experience - Public transportation domain experience
About The Position
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
Requirements
- Prior MTA or any public transportation domain experience
- 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 Factory
- Azure Databricks
- Azure Synapse Analytics
- Azure Data Lake Storage
- Experience with SQL Server data warehouse environments
- Working knowledge of SSIS and experience modernizing or migrating SSIS workflows to Azure-based solutions
- 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)
- 8+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.
Nice To Haves
- 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)
Responsibilities
- Building enterprise-grade ETL pipelines
- Building 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
