Data Engineer

Acme One; Lahore; On-site; PKR 1,500,000 - 3,000,000; Full time

Job summary

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

Qualifications

• 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.

Responsibilities

• 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.

Skills

SQL Server

T-SQL

ETL/ELT

Power BI

Data modeling

Tools

SSIS

Azure Data Factory

Azure Data Lake Storage

Azure Synapse

Databricks

Power BI

Job description

Job Type:Full-time(Onsite)

Location:Acme-One, 31C, Block C Abdalians Cooperative Housing Society, Lahore, Pakistan

Note:Only onsite candidates will be considered. Remote applications will not be accepted

We’relooking for a motivated Data Engineer with hands-on experience in SQL Server, SSIS, Azure cloud data tools, and Power BI.You’llhelp build andmaintaindata pipelines, support cloud-based integrations, and contribute to BI solutions thatmatter.

Key Responsibilities

• 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 (basic exposure is a plus)
• Create and manage Power BI datasets, dataflows, DAX measures, and interactive dashboards
• Ensure data quality, reliability, andtimelyavailability 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

Requirements

• 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 BIproficiency- reports, dashboards, DAX, data modeling
• Solid understanding of ETL/ELT and star/snowflake data modeling