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
• 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.
Regards,
Mohammed ilyas,
PH - 229-264-4024 or Text - 229-469-1455 or you can share the updated resume at Mohammed@vtekis. com
All your information will be kept confidential according to EEO guidelines.