Senior Data Engineer - HubSpot to IFS Data Lake (6-Month Fixed Term)

About the role

IFS is seeking an experienced Senior Data Engineer for a 6-month fixed-term contract in Colombo. The engineer builds data pipelines that ingest HubSpot data into the IFS Enterprise Data Lake and designs the analytical solution for reporting and AI consumption. The role works under the Senior Director, Data & Analytics, alongside the Senior Technical Manager, Data & Analytics, and collaborates with stakeholders, marketing and sales teams, data engineers, analytics teams and the enterprise architect.

Key responsibilities

• Build HubSpot data pipelines into the Data Lake, including secure extraction via APIs, connectors or integration services
• Develop automated ingestion pipelines, data transformation, cleansing and standardization according to business rules and data models
• Create data models for reporting and analytics with minimal downstream impact, and document pipelines, schemas, transformations and use cases
• Define data quality, validation, reconciliation, exception handling, security, privacy, compliance and governance requirements
• Document user roles, access controls and data consumption needs, and create data flow diagrams and functional specifications
• Facilitate requirement reviews, stakeholder sign-off and change management, and optimize pipelines for performance, scalability and cost

Required profile

• 5-8 years of data engineering experience, including 3+ years with Microsoft Fabric and Azure data platforms
• Proven experience designing enterprise-scale data models and analytics platforms
• Strong stakeholder management, written communication and evidence-based reporting skills
• University degree in Computer Science, Information Systems, Engineering, Business Systems or equivalent practical experience; fluency in English

Required skills

• Microsoft Fabric, Azure AI Services, Azure Machine Learning
• Star schema, data warehouse, data mart, materialized views, normalization and joins
• Relational and non-relational databases
• CRM, CPQ, sales, commercial, ERP or quote-to-cash solutions
• Beneficial: HubSpot, Salesforce, Dynamics, Azure BI (Power BI, Synapse, SSIS, SSAS, ADF, Purview, OneLake)
• Jira, Azure DevOps, Confluence, SharePoint, Teams