Data Engineer – Analytics & BI Lahore, Pakistan On-site 2+ years

KCloudAI; Lahore; Presencial; PKR 1.800.000 - 2.500.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Competitive salary

Health insurance coverage

Work on real analytics problems for国际的

Descripción de la vacante

KCloudAI in Lahore, Pakistan is seeking a data-focused engineer to turn raw datasets into actionable analytics and reporting. You will design data models, build ETL pipelines, write complex SQL, and participate in client discussions to define KPIs and outcomes.

The role combines hands-on data work with collaboration across business teams and modern cloud BI tools, offering a clear growth path in data engineering and analytics.

Formación

• 2+ years of hands-on experience in data engineering, analytics engineering or BI development.
• Strong SQL skills and experience handling complex datasets, queries and data validation
• Solid understanding of relational databases, dimensional modelling and data warehousing
• Practical experience with ETL/ELT processes
• Strong analytical mindset, attention to data quality and the ability to understand relationships within complex datasets
• Ability to translate business requirements into KPIs and reporting
• Clear communication and confidence working with stakeholders and clients

Responsabilidades

• Extract, clean, transform and integrate raw data from multiple sources
• Design relational and dimensional data models for warehouses and reporting layers
• Build and maintain ETL/ELT pipelines that are reliable and easy to reason about
• Write and optimise complex SQL queries, and validate data quality end to end
• Work with stakeholders to understand business requirements and define the right KPIs
• Develop reliable reporting and analytical solutions in modern BI tools
• Take part confidently in client discussions about data, processes and outcomes

Conocimientos

SQL

Dimensional modelling

Data warehousing

ETL/ELT

Data quality

KPIs

Stakeholder comms

Herramientas

Power BI

Sigma

Tableau

Looker

Snowflake

Databricks

dbt

Azure Data Factory

Descripción del empleo

At KCloudAI, we're looking for someone with a strong understanding of data, hands-on experience working with raw datasets, and the ability to turn complex data into meaningful analytics and reporting solutions. You'll work across the full path from source systems to dashboards — extracting and cleaning data, modelling it properly, and building the reporting that clients rely on to run their business. You'll also sit in client discussions, so understanding business processes matters as much as writing good SQL. Experience with every tool is not required: strong data fundamentals, analytical thinking and relevant practical experience matter more.

Responsibilities

• Extract, clean, transform and integrate raw data from multiple sources
• Design relational and dimensional data models for warehouses and reporting layers
• Build and maintain ETL/ELT pipelines that are reliable and easy to reason about
• Write and optimise complex SQL queries, and validate data quality end to end
• Work with stakeholders to understand business requirements and define the right KPIs
• Develop reliable reporting and analytical solutions in modern BI tools
• Take part confidently in client discussions about data, processes and outcomes

Requirements

• 2+ years of hands-on experience in data engineering, analytics engineering or BI development
• Strong SQL skills and experience handling complex datasets, queries and data validation
• Solid understanding of relational databases, dimensional modelling and data warehousing
• Practical experience with ETL/ELT processes
• Strong analytical mindset, attention to data quality and the ability to understand relationships within complex datasets
• Ability to translate business requirements into KPIs and reporting
• Clear communication and confidence working with stakeholders and clients

Nice to have

• Cloud data platforms such as Snowflake or Databricks
• Databases such as SQL Server or PostgreSQL
• Transformation and integration tools such as dbt, Alteryx, Fivetran or Azure Data Factory
• BI tools such as Power BI, Sigma, Tableau or Looker
• Experience on client-facing consulting or delivery projects

What comes with it

• Competitive salary
• Health insurance coverage
• Work on real analytics problems for international clients
• Exposure to modern cloud data and BI platforms
• Training and certification support
• Clear growth path in data engineering and analytics
• Modern equipment and a full workstation
• Team events and a collaborative office culture

2+ years of hands-on experience in data engineering, analytics engineering or BI development; Strong SQL skills and experience handling complex datasets, queries and data validation; Solid understanding of relational databases, dimensional modelling and data warehousing; Practical experience with ETL/ELT processes; Strong analytical mindset, attention to data quality and the ability to understand relationships within complex datasets; Ability to translate business requirements into KPIs and reporting; Clear communication and confidence working with stakeholders and clients