Senior Data Engineer (Full-time 1-year Contract)

The Company

The Company

We are a Norwegian owned company delivering offshore software services from our development centre in Sri Lanka. Over the last 15 years we have completed 250 successful projects worldwide for clients ranging from startups to Fortune 500 companies. For a decade and a half we have been creating breakthrough software for leading organisations in Europe USA Australia Singapore and more. We are a team of global experts who architect solutions that change the way business is done and add colour to everyday living.

We offer custom software application development to diverse sectors such as proptech fintech environment logistics maritime health and more. We assign a dedicated long-term technology team to each client allowing for seamless integration with their internal teams. Guided by the Nordic values of trust transparency and commitment our diverse team drives innovation and disruption in the modern digital era.

The Role

We are seeking skilled Data Engineers on a 1-year contracts to support a CRM transformation initiative involving data migration and integration between enterprise platforms. This role focuses on building ETL pipelines designing scalable data models developing Azure-based integrations and ensuring data quality performance and reliability across systems. Depending on experience level the engineer may take ownership of complex components and support mentoring and technical guidance within the team.

Key Responsibilities

• Analyze source CRM data models and map structures to target enterprise systems.
• Design and implement ETL pipelines and integration workflows using SSIS and Azure services.
• Develop complex SQL scripts stored procedures and database components to support migration activities.
• Build and maintain Azure-based data orchestration and transformation workflows.
• Implement incremental data loads validation rules and reconciliation processes.
• Ensure high standards of data quality integrity and consistency throughout migration phases.
• Troubleshoot and resolve ETL integration and data pipeline issues.
• Optimize performance across SQL queries SSIS packages and data processing workflows.
• Document technical designs mappings and data transformation logic.
• Participate in code reviews CI/CD workflows and version control practices.
• Collaborate with engineering QA and business stakeholders to ensure successful delivery.
• Mentor junior engineers and contribute to engineering best practices (Senior Engineer level).

Core Technical Skills Required

Data Analysis & Modeling

• Analyze CRM data models and custom objects.
• Design ERDs define PKFK relationships and cardinalities.
• Develop schemas views stored procedures and functions.
• Apply indexing strategies for performance optimization.

SQL & Data Transformation

• Write advanced SQL queries including joins CTEs and window functions.
• Implement data cleansing deduplication and validation logic.
• Perform source-to-target reconciliation and audit checks.
• Optimize queries for large-scale data processing.

Data Warehousing

• Design and maintain fact and dimension models.
• Implement incremental loads and change data capture.
• Support reporting datasets and metadata-driven ETL processes.

ETL & Integration (SSIS)

• Develop SSIS packages with complex data flows and transformations.
• Implement logging monitoring and error handling.
• Schedule and optimize ETL workflows for high-volume data loads.

Azure & Cloud Services

• Use Azure Data Lake (ADLS) for staging and storage.
• Develop Azure Logic Apps and Function Apps for orchestration and transformation.
• Integrate systems using REST APIs and event-based patterns.

Data Ingestion

• Process structured and semi-structured data formats such as CSV TXT JSON XML and Parquet.
• Normalize validate and transform multi-source datasets.

Version Control & DevOps

• Use GitHub for source control and branching workflows.
• Participate in pull requests and code reviews.
• Support CI/CD processes and multi-environment deployments.

Experience & Qualifications Required

• 3 years in data engineering ETL development or system integration roles.
• Strong SQL and relational database expertise.
• Hands-on experience with SSIS and ETL pipeline development.
• Experience working with Azure data and integration services.
• Exposure to CRM platforms such as Salesforce or MS Dynamics is an advantage.
• Strong analytical thinking troubleshooting ability and communication skills.
• Ability to work collaboratively in cross-functional project environments.

Contract Details

• Contract Duration: 12 Months
• Engagement Type: Full-time
• Working mdoe: Hybrid (3 days WFO)