Data Engineer

EWS Group; Pakistan; On-site; PKR 2,790,000 - 3,906,000; Full time

Benefits offered by this job

Medical Coverage

Provident Fund

Employee Performance-based bonuses

Home Internet Subsidy

Conveyance Allowance

Profit Sharing Plan

Life Benefit

Lunch/Dinner Provided

Professional Development Budget

Leave Encashment

Job summary

Contour Software is seeking a skilled Data Engineer to join the empowOR/CADS data initiative in Pakistan. The role focuses on building scalable data pipelines, refactoring CADS data flows, and ensuring secure data processing across Fabric lakehouses and Azure Data Factory.

You will collaborate with cross-functional teams to deliver reliable data solutions. The ideal candidate has 3–4 years of hands-on data engineering experience, strong SQL, Python, and data-security awareness, and a passion for

Qualifications

• 3–4 years of relevant experience required.

Responsibilities

• Develop and maintain data pipelines across Fabric and ADF.
• Diagnose dataflow issues and implement end-to-end fixes.
• Write efficient SQL and optimize performance of queries.
• Collaborate with engineering, DevOps and BI teams.

Skills

Microsoft Fabric

Azure Data Factory

SQL

Python

Data Integration

ETL/ELT

Data Security

Data Pipelines

Job description

About Contour Contour Software has grown from a dozen people to over 2,000 staff across 3 cities, in less than 14 years. As a subsidiary of Constellation Software Inc., we are proud to be part of a global enterprise software conglomerate that has grown to become one of the top 10 software companies in the world, with employees and customers in 100+ countries. With a broad-based and ever-growing portfolio of market-leading, vertical-market enterprise solutions covering more than 100 industry domains in predominantly mature markets, CSI's recipe creates the perfect environment for professionals to build fulfilling, long-term careers. What started as an R&D & Accounting back-office, has progressed into a full-service Global Centre serving all functions and departments, at the divisional as well as operating group/corporate level. Today Contour employees, located in Karachi, Lahore & Islamabad, are serving CSI divisions located in time zones spanning the globe, from Sydney to Vancouver. With the global growth of Constellation as the wind in our sails, we are only just getting started!

About Division: empowOR was ‘born’ out of the complex needs of multi-service agencies who are trying to:

De-silo their data and approach

Use data and technology to improve efficiencies in operations

Coordinate services

Use data for funder reporting & strategic analysis

The Position: empowOR and CADS data — the CADS refactor, the Fabric lakehouses and warehouses, and the pipelines and transforms that move and reshape customer data — is architected, built, and kept performant, so that linking, reporting, and integrations run reliably and scale.

Key Responsibilities

• Enterprise Data Platform: Ensure Data Platform is scalable , secure and well supported, CADS is owned end to end — refactored onto a Fabric lakehouse architecture that scales, then supported and maintained. Own CADS data flow in full — meaning supporting the new infrastructure that utilizes MS Fabric, SPLINK (python based deduplication code), data flow and data syncs across fabric and a small DB for UI interactions Build and maintain the ingest and transform path — likely using SQL MERGE INTO / COALESCE — with the API acting as an ingest gateway rather than doing transactional per-record updates and utilizing queue tables and pipelines to process data Support migration of data Ensure SSNs and other sensitive fields are hashed or encrypted before storage in Fabric, per compliance requirements Participate in CADS Team / CADS Refactor and Architecture sessions
• Data Pipelines & Integrations: Design, build, and maintain data pipelines and transforms across Microsoft Fabric and Azure Data Factory (ADF) Diagnose and resolve complex dataflow and transform issues, including the recurring ADF/SQL internal errors, and own the architecture-level fixes Serve as the senior escalation point for CADS, and pipeline issues raised by the Tech 2 — Fabric & Integrations specialist and support Write efficient SQL, troubleshoot poorly performing queries, and lead performance tuning across the data platform Gain familiarity and assist in support of internal data transformation code (called CDTF--core data transform framework)
• Enterprise Data Warehouse & Semantic Models: Write SQL to build data warehouse tables that have been designed Suggest improvements to data warehouse infrastructure Support the internal (semantic) model in PowerBI and measure updates (shared with the Reporting & Integration Manager) Build new data sets and pipelines that support Data Autonomy and downstream reporting Keep the model and measures correct so that Power BI / Report Builder outputs built downstream are accurate
• Reporting Infrastructure & Business Intelligence: Build new Report Builder data sets Serve as the escalation point for Report Builder issues Engineer report queuing solutions Maintain mirrored databases for reporting Build and support data empowORment reporting offerings Make SQL improvements to reporting queries and structures as needed
• Data Migration & Integration: Support new data source integrations into CADS support, maintain and improve data integrations into and out of empowOR Design and lead data migration work Attend reporting & Integration Team meetings (as relevant to the warehouse, semantic model, and pipelines)
• Release Management: Write QA plans for and QA architecture- and pipeline-level changes across CADS, transforms, the warehouse, and reporting structure Recreate the scenarios that cause an issue, test those and ancillary functions in the QA portal, leave notes in the task discussion, and follow the QA pass/fail process
• Strategic Initiatives: Participate in strategic-plan projects as needed, including building in-house capability (e.g., updating the CADS UI / Breck model) where it reduces reliance on outside consultants

Required Skills & Knowledge

• 3–4 years of relevant experience required.
• Strong hands‑on experience with Microsoft Fabric — lakehouse, warehouse, and semantic model
• Strong hands‑on experience with Azure Data Factory (ADF) — building pipelines, not only monitoring them
• Demonstrated experience diagnosing and resolving data flow and transform issues, and designing transform/pipeline architecture (medallion and ETL/ELT patterns, MERGE/upsert logic)
• Advanced SQL — query authoring, performance tuning, and troubleshooting poorly performing queries
• Experience with data integration patterns — ingest APIs/gateways, SFTP, scheduled jobs, and file‑based imports (parquet/JSON)
• Understanding of data security and compliance handling, such as hashing or encrypting sensitive fields (e.g., SSNs)
• Scripting experience in Python or a similar language; familiarity with entity‑linking / record‑matching concepts (e.g., Splink) a plus
• Comfortable working cross‑functionally with engineering, DevOps, and the reporting team
• Familiarity with nonprofit‑focused software and agency data needs a plus

Work Shift

Work Shift 4PM – 1 AM OR 5PM – 2 AM Pakistan Time

Exciting Benefits we offer:

• Market‑leading Salary
• Medical Coverage – Self & Dependents
• Parents Medical Coverage
• Provident Fund
• Employee Performance‑based bonuses
• Home Internet Subsidy
• Conveyance Allowance
• Profit Sharing Plan [Tenured Employees Only]
• Life Benefit
• Child Care Facility
• Company Provided Lunch/Dinner
• Professional Development Budget
• Recreational area for in‑house games
• Sporadic On‑shore training opportunities
• Friendly work environment
• Leave Encashment

Leave Encashment Disclaimer:

We attribute our success to the unique contributions of our diverse staff. We’re committed to fostering a culture of respect that thrives on the varied perspectives and experiences of all individuals we recruit, employ, promote, and compensate. Since day one, we’ve adhered to a policy that champions a work environment honoring the worth and dignity of each person while being free from all forms of employment discrimination. In our continuous effort to promote inclusivity, we extend our commitment to individuals with special needs by providing reasonable accommodations. We actively encourage qualified individuals with special needs to apply for the various openings within our company. Should you require assistance in completing the application process or have any inquiries regarding special facilities, please do not hesitate to contact our HR team. Your unique talents and abilities are welcomed and valued here.

As a subsidiary of CSI, Contour Software serves as a dedicated Global Centre, currently housing employees and teams for more than 150 Divisional and Corporate departments. Contour employees are key players in implementing, supporting, extending, enhancing, and renewing enterprise systems that run thousands of medium and large businesses, as well as public institutions, globally!