Azure ETL Developer with Advance Power BI Experience - Public transportatio at Syncreon Consulting

New York, New York, United States -

Full Time

Start Date

Immediate

Expiry Date

16 Jun, 26

Salary

0.0

Posted On

18 Mar, 26

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Etl, ElT, Power Bi, Sql, Python, PySpark, Data Modeling, Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Azure Data Lake Storage, Ssis, Dax, Paginated Reports, Rls, DevOps

Industry

Truck Transportation

Description

Company Description 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 partner for various industries. We work as trusted business partners and always strive to deliver the most value and highest return on investment for our clients. We are highly trained business professionals with strong understanding of clients need. We work closely with the leading staffing trade associations, training, and research organizations to ensure we are knowledgeable of the latest industry trends and technologies Job Description 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 Additional Information All your information will be kept confidential according to EEO guidelines.

Responsibilities

The role requires candidates to design and implement modern ETL/ELT pipelines in Azure, assess and refactor existing SSIS packages, and architect Lakehouse/Medallion data models. Additionally, the developer must design and deploy enterprise Power BI dashboards, build paginated reports, optimize DAX, and implement Row-Level Security.