Onsite Data Engineer: Azure ETL & BI Specialist

Acme One; Lahore; Presencial; PKR 1.500.000 - 3.000.000; Jornada completa

Descripción de la vacante

Acme One in Lahore is seeking a Data Engineer with hands-on experience in SQL Server, SSIS, Azure cloud data tools, and Power BI to build and maintain data pipelines, support cloud-based integrations, and contribute to BI solutions that matter.

Key responsibilities include developing, optimizing, and maintaining ETL/ELT pipelines across on-prem and Azure, designing SQL Server objects, building data ingestion with SSIS, ADF, ADLS, Synapse, and Databricks, and creating Power BI datasets and

Formación

• 1–3 years of experience as a Data Engineer, BI Developer, or similar.
• Strong MS SQL Server & T-SQL skills.
• Hands-on with Azure tools - ADF, ADLS, Synapse.
• Power BI proficiency for reports, dashboards, DAX, data modeling.
• Solid understanding of ETL/ELT and star/snowflake data modeling.

Responsabilidades

• Develop, optimize, and maintain ETL/ELT pipelines across on-premises and Azure environments.
• Design and manage SQL Server objects - tables, views, stored procedures, and functions.
• Build data ingestion and transformation solutions using SSIS, ADF, ADLS, Azure Synapse, and Databricks.
• Create and manage Power BI datasets, dataflows, DAX measures, and interactive dashboards.
• Ensure data quality, reliability, and timely availability across systems.
• Troubleshoot pipeline failures, performance issues, and data inconsistencies.
• Collaborate with analysts and business users on reporting requirements.
• Document workflows, data models, and SOPs.

Conocimientos

SQL Server

T-SQL

ETL/ELT

Power BI

Data modeling

Herramientas

SSIS

Azure Data Factory

Azure Data Lake Storage

Azure Synapse

Databricks

Power BI

Descripción del empleo

Acme One in Lahore is seeking a Data Engineer with hands-on experience in SQL Server, SSIS, Azure cloud data tools, and Power BI to build and maintain data pipelines, support cloud-based integrations, and contribute to BI solutions that matter.

Key responsibilities include developing, optimizing, and maintaining ETL/ELT pipelines across on-prem and Azure, designing SQL Server objects, building data ingestion with SSIS, ADF, ADLS, Synapse, and Databricks, and creating Power BI datasets and