SENIOR ETL/BI (DATA) ENGINEER

Exciting benefits we offer

  • Market competitive salary (depending on experience)
  • Company provided lunch everyday
  • Medical insurance for self & dependents (OPD/IPD)
  • Pension Scheme
  • EOBI
  • Company paid sports activities
  • Company paid for certifications
  • Flexible working hours
  • Career progression and clear career path (SIFA based)
  • Personal development plan (PDP)
  • Open plan environment
  • Company celebration dinners
  • Yearly company paid local tour
  • Onsite secured car park for cars and bikes
  • Leave bank and encashment policy
  • Monthly employee’s birthday celebration

The role:

You will work closely with our Pakistan Regional Directors, Systems Architects, and Team Leads (both in Lahore and the UK) analyzing, designing, and building new systems and enhancements to existing systems. You should possess a desire to learn and work with unique, highly complex, online transactional systems, not run-of-the-mill database backed CRUD systems. Primarily you will be working on Microsoft technologies stack.

The successful candidate will have:

  • Minimum 4 years of relevant work experience in a similar job role, preferably in a fast-paced, data driven environment, delivering value quickly and iteratively
  • Work closely with Heads, Architects, Business Intelligence, Data Science, Developers, and IT Delivery Teams to design, develop and maintain highly scalable data solutions and pipelines
  • Demonstrable experience in developing solutions that support analysis and business processes in commercial environments
  • Hands-on experience in installing/managing SSIS and SSRS/ PowerBI (Online/On-Premises)
  • Experience in data modelling, ETL/ELT processes, and data warehousing
  • Advanced working SQL knowledge and experience working with relational databases, query authoring (TSQL) and query/performance tuning
  • Good knowledge of BI dashboarding and self-service tools, especially PowerBI and SSRS Report Server
  • Experience of DevOps culture would be highly advantageous – Repo, Release pipelines, auditing
  • Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
  • Implementing and following best practices in Azure CICD and Git in a data environment.
  • Good knowledge of Azure Data Lake(ADL) (incl. Blob Storage, Delta) Azure Data Factory (ADF) and Azure Databricks is desirable only
  • Knowledge of Microsoft Dynamics CRM is a plus
  • A team player can communicate effectively and comfortable working within a multi-cultural and multi-functional team, both locally and remote, understanding the perspectives of each partner.
  • Excellent problem-solving and analytical skills with attention to details and are renowned for having high standards in your work.

As an experienced engineer, we would expect you to contribute to our continual process of improving our systems, processes, and technology stack. Overall, we look for people who have an inquisitive mind, are always learning, and to whom development is a passion, who are not scared to look under the covers of a framework to figure out how things work, and ultimately why it may not be working as expected. You will work a group of highly passionate technology people who want to develop the best systems in their chosen business area. As a business we love to see our people grow and develop with room for both career and skills development across the organization.

Where we are

In Pakistan, our state of art office is in the newly built Tricon business center situated in the heart of Gulberg. The Tricon Corporate Centre is the latest addition to the city line with state of art office facilities. The hi-tech building features a full height glass window, which overlooks Gymkhana Golf Club and Main Gulberg. The centre is highly accessible through public transport with best road infrastructure, accessible through Jail Road, Sherpao bridge, Gulberg Main Boulevard and M M Alam Road. The centre is surrounded by banks, cafes, restaurants, shopping malls, hospitals and health and fitness clubs.

To apply, email us with your CV or click apply now.

Apply now

About Calrom Pakistan

Calrom Pakistan is the tech division of the Travel Innovation Group, renowned travel industry heavyweights (if we do say so ourselves) offering a wealth of unique services via our three companies; Lime, Aviate and Calrom and employing over 400 staff all across the world. Calrom Pakistan (Microsoft Gold Partner) is a fast-growing SaaS tech company specialising 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.

Our offices, people and partners now span the globe and we’re looking for exceptional tech talent in Lahore to work with us, succeed with us and grow with us.