{bc}
smartrecruiters

Senior Data Lead (3 Months Fixed Term Contract)

IFS
Pune, IND
Full Time, Contract, Temporary
Senior · 5+ years experience
Hybrid
Discovered 1 months ago
HubSpotDealHubTHORIFS CloudPower BIMicrosoft Fabric

Full Job Posting

Architect & Design Hubspot data for Analytics into Data lake

Assess and document HubSpot data sources, entities, relationships and business requirements for analytics consumption.

Design scalable data architecture and ingestion frameworks to extract HubSpot data into the enterprise data lake.

Define data models, schemas and storage strategies to support reporting, analytics and downstream impact.

Establish data mapping, transformation and enrichment rules to align HubSpot data with enterprise standards.

Implement data quality, validation and governance controls to ensure accuracy, consistency and compliance.

Design incremental data integration patterns to support timely analytics and operational reporting.

Develop metadata, lineage and documentation standards for HubSpot data assets within the data lake ecosystem.

Collaborate with business stakeholders, analytics teams and data engineers to ensure minimal reporting impact during the transition from the existing CRM platform (THOR/ IFS Cloud) to HubSpot.

Optimize data pipelines and storage structures for performance, scalability and cost efficiency.

Provide architecture recommendations and best practices for future expansion of customer, marketing, sales and service analytics.

Create Functional Requirement Document (FRD)

  • Conduct stakeholder workshops and requirement gathering sessions to capture business, functional and reporting needs.
  • Document business objectives, scope, assumptions, dependencies and success criteria for the HubSpot analytics solution.
  • Define functional requirements for data ingestion, transformation, storage and consumption within the fabric/ data lake environment.
  • Capture source-to-target mapping requirements, including business rules, data definitions and transformation logic.
  • Document analytical use cases, KPIs, metrics, dashboards and reporting requirements.
  • Define data quality, validation, reconciliation and exception-handling requirements.
  • Capture security, privacy, compliance and data governance requirements.
  • Document user roles, access controls and data consumption requirements for business and technical stakeholders.
  • Develop process flows, data flow diagrams and functional specifications to support implementation.
  • Facilitate requirement reviews, stakeholder sign-off, and change management throughout the project lifecycle.
  • Provide traceability between business requirements, functional requirements and solution design artifacts.

Implementation of Data from HubSpot into IFS enterprise Data Lake

Assist the data engineer with configuring and implementing secure data extraction processes from HubSpot using APIs, connectors or integration services.

Assist the data engineer with development and deployment of automated data ingestion pipelines to load HubSpot data into the IFS Enterprise Data Lake.

Assist the data engineer with Implementation of data transformation, cleansing and standardization processes in accordance with approved business rules and data models.

Key Deliverables

Architecture & Design of Hubspot data for Analytics into Data lake

Data architecture document

Documentation of ingestion frameworks to extract HubSpot data into the enterprise data lake

Document HubSpot data sources, entities, relationships and business requirements for analytics consumption.

Data pipelines, data quality dashboards

Data pipelines running with incremental data load.

Data quality dashboards

Data lineage implementation for HubSpot data

Data catalogue implementation for HubSpot data

Essential Experience

5-8 years of experience in data architecture, data engineering or enterprise data management.

3+ years of hands-on experience with Microsoft Fabric and Azure data platforms.

Microsoft Fabric AI Capabilities

Azure AI Services

Azure Machine Learning

Generative AI

Strong experience in enterprise data governance and metadata management.

Proven experience designing enterprise-scale data models and analytics platforms.

Strong data management skills

Good understanding of Star Schema based framework, Data warehouse and Data Mart and Materialized View

Good understanding of database concepts like normalization, joins, changing dimensions etc..

Good understanding of relational and non-relational database management systems

Experience in CRM, CPQ, sales, commercial, ERP or quote-to-cash / lead-to-order solutions.

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.

Highly Beneficial Experience

Experience with HubSpot, DealHub, Salesforce, Dynamics or similar CRM / sales platforms.

Experience with CPQ platforms, quotation/pricing flows, approval workflows and DAR-like governance processes.

Experience with ERP integration, preferably IFS Cloud / THOR, SAP, Oracle or NetSuite.

Experience with Azure BI technology (Fabric, Synapse, Power BI, Azure SQL, SSIS, SSAS, Purview, OneLake, ADF)

Technical Skills

Fabric, Synapse, Power BI, Azure SQL, SSIS, SSAS, Purview, OneLake, ADF

Management tools such as Jira, Azure DevOps.

Collaboration tools such as Confluence, SharePoint, Teams or equivalent.

Business and Process Knowledge

Lead-to-Order / Lead-to-Cash process concepts.

Lead, account, contact, opportunity, quote, contract and order data flows.

Data quality and master data dependencies.

Leadership and Behavioural Competencies

Lead testing across multiple teams without direct line management authority.

Be structured, pragmatic and delivery-focused.

Communicate clearly with both technical teams and business stakeholders.

Challenge incomplete requirements, unclear ownership and insufficient test evidence.

Escalate risks early and professionally.

Maintain control under delivery pressure.

Separate critical go-live issues from lower-priority improvements.

Drive accountability across vendors, IT and business.

Build confidence with senior stakeholders through clear reporting and evidence.

Operate independently while staying aligned with programme governance.

Education and Certifications

Essential

University degree in Computer Science, Information Systems, Engineering, Business Systems or equivalent practical experience.

Fluency in English, written and verbal.

Proven experience in test leadership roles.

Highly Beneficial

Fabric Data Engineer.

We embrace flexibility and hybrid work opportunities to support diverse needs and lifestyles, while also valuing inclusive workplace experiences. By fostering a sense of community, we drive innovation, strengthen connections, and nurture belonging. Our commitment ensures you can work in a way that suits you best, while also engaging with colleagues to share ideas and build meaningful relationships.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at IFS