Azure ETL Developer with Advance Power BI Experience - Public transportation domain experience at SyncreonConsulting

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