Data Engineer II

Travel Innovation Group; Lahore; On-site; PKR 892,800 - 1,339,200; Full time

Benefits offered by this job

Medical Insurance

Pension Scheme Fund

Gym Passport

Career Progression

Company Provided Lunch

Monthly Mobile Allowance

Bi-annual Bonuses

Job summary

Travel Innovation Group is seeking a Data Engineer II to develop and maintain robust ETL pipelines from source systems to BI reporting layers in Lahore. Candidates should have 2-4 years of experience and strong SQL and Python skills, along with familiarity with Microsoft BI tools.

The role provides ample opportunities for professional development and collaboration in a fast-paced environment, with exciting benefits such as medical insurance, career progression, and a modern office space.

Qualifications

• 2 to 4 years of relevant experience in a similar job role.
• Hands-on experience using Microsoft BI Stack.
• Strong SQL and Python skills.

Responsibilities

• Develop and optimize ETL/ELT pipelines for BI/data warehousing needs.
• Ensure data quality, governance, and integrity across the BI thread.
• Integrate data from multiple sources (APIs, databases, cloud storage).

Skills

SQL

Python

ETL Pipelines

Microsoft BI Stack

Azure DevOps

Data Governance

Data Analytics

Tools

Databricks

Power BI

SSRS

Azure Data Factory

Job description

Data Engineer II

Contract: Permanent
Location: Calrom Lahore office; Askari Corporate Tower, 1st Floor
Shift pattern: Day shift, 11:30 – 20:00, Monday to Friday
Salary: Competitive DOE

About us and the department this role sits in

Calrom Pakistan (Private) Limited (Microsoft Gold Partner) is tech division of Travel Innovation Group (Lime Management, Aviate and Calrom Limited) which has more than 250 staff all over the world. Calrom Pakistan Limited is a fast-growing SaaS tech company specializing in group booking solutions, fare distribution, air shopping and ticketing systems for airlines. Our systems are used by some of the world’s largest and most respected airlines, which is a testament to our passion for creating quality and innovative software solutions.

A highly passionate bunch, our data analytics & AI team bring our unique software solutions to life. Believing in self-service business intelligence concepts, they are empowering business managers and data analysts to perform their bespoke analysis using the power of modern BI tools. They are also providing support to development teams, actively managing 24x7 OLTP database clusters on multiple geo-location. To keep the analysis more robust and meaningful, team is building data warehouses on regular intervals and making periodic data marts specific to the end user needs to provide a complete picture of the business at any point in time. AI is helping shaping the future of price prediction using the historic data and trying to provide accurate predictions on top routes and flights.

We are looking for a BI (ETL) Engineer to design, build, and maintain robust ETL pipelines, ensuring seamless data flow from source systems to our BI reporting layers (data warehouse, data lakes). You’ll collaborate with data analysts/scientists to support reporting, analytics, and business insights.

The role

• Develop and optimize ETL/ELT pipelines (SQL, Python, Databricks, etc.) for BI/data warehousing needs
• Ensure data quality, governance, and integrity across the BI thread
• Integrate data from multiple sources (APIs, databases, cloud storage)
• Implement CI/CD pipelines using Azure DevOps for automated testing and deployment of ETL processes
• Support BI tools (Power BI, Tableau) with clean, structured datasets
• Collaborate with stakeholders to understand and implement BI requirements

We think you’ll be a great fit if you have

• 2 to 4 years of relevant work experience in a similar job role, preferably in a fast-paced, data driven environment, delivering value quickly and interactively.
• Hands‑on experience using Microsoft BI Stack especially Fabric Power BI plus DAX, pbit and SSRS
• Hands‑on experience of BI Concepts including ETL Pipelines, designing warehousing, marts, deploy and maintain solutions in different environment and providing business analysis that adds value
• Strong SQL + Python skills
• Experience with Azure (Data Factory, Databricks, Synapse Analytics)
• Proficiency with Azure DevOps CI/CD for ETL deployments
• Familiarity with BI tools (ideally BI thread) and data governance
• Experience of data technologies, especially in the Microsoft stack, with a great grasp of SQL and/or Python (Flask).
• Experience of using Azure services including Azure SQL Database, Data Factory, DevOps, Power BI, ML Studio, Databricks, stream analytics, Terraform
• Experience of good SDLC practices: source control (git), CI/CD, test and release processes
• Any experience using any of the following would also be a bonus in our environment: Dynamics CRM, Rabbit MQ, Hubspot, C# .NET development or legacy Microsoft data technologies (SSIS, SSRS)

We are looking for the right person who is a team player who can communicate effectively and is comfortable working within a diversified, multi‑cultural and multi‑functional team, both locally and remote, understanding the perspectives of each partner. Above all, someone with the passion to drive and succeed in their own career.

Experience in any of the above would help you to become productive in the job more quickly. We are genuinely committed to your success so, if you don’t quite meet all of our requirements yet, we encourage you to apply anyway and start a conversation.

Exciting benefits we offer

• Modern office in central Lahore with a great space to kick back and relax or collaborate with the team.
• Medical Insurance (OPD+IPD) for self & dependents (Spouse, children and as well as Parents).
• Pension Scheme Fund (Applicable after Probation Period).
• Gym Passport (or) Building Gym (available here in Askari Corporate Tower).
• Due Annual Increments (+) Inflation based adjustments (if applicable).
• (PDP) – Personal Development Program.
• Career Progression and Clear Career Path (SIFA based).
• Company Provided Lunch Everyday.
• Open Plan Environment.
• Company Sponsored Recreational (Local) Trips (and/or) team building events and activities.
• Company Celebration Dinners (e.g) Annual dinners, Iftar dinners. Etc.
• Company Paid Sports Activities.
• Onsite Secured Parkings for your Cars and Bikes.
• Company Paid Professional Certifications. (i.e) reimbursements subject to business needs.
• Monthly Birthday Celebrations of Employees.
• Bi‑annual Bonuses (10% of your basic salary)
• Referral Bonuses. (PKR. 25,000)
• Leave Bank & Encashment Policy.
• Monthly Mobile Allowance (PKR. 2,700) for Senior Software Engineers / Senior Data Engineers.
• Work‑life balance