Senior Data Solution Designer

Adactin Software; India; On-site; INR 3,000,000 - 5,000,000; Full time

Job summary

Adactin Software is seeking a Senior Data Solution Designer who can bridge business needs with scalable data solutions. You will translate complex reporting and analytics requirements into robust data models while collaborating with data engineers, architects, analysts and business stakeholders.

Design conceptual, logical and physical data models, define reporting-ready datasets and semantic layers, and partner with BI teams to deliver dashboards.

Qualifications

• 8+ years of experience in Data Analysis, Data Modelling, Solution Design, or Data Architecture.
• Strong expertise in Data Modelling (Conceptual, Logical, Physical).
• Dimensional Modelling (Star Schema, Snowflake Schema).
• Data Warehousing Concepts
• Data Mapping and Data Lineage
• Proven experience translating business requirements into technical data solutions.
• Strong understanding of reporting and analytics data structures.
• Experience designing reporting-ready datasets for BI platforms.
• Advanced SQL skills and strong data analysis capabilities.
• Experience working with enterprise data platforms and cloud environments.
• Excellent stakeholder engagement and workshop facilitation skills.
• Strong documentation and communication skills.
• Ability to collaborate effectively with engineering and business teams.

Responsibilities

• Engage with business stakeholders to understand, analyze, and document data and reporting requirements.
• Translate business needs into scalable technical solution designs and data models.
• Design conceptual, logical, and physical data models aligned with enterprise architecture standards.
• Define and create reporting-ready datasets, semantic layers, and analytical data structures.
• Collaborate with Data Engineers to design ETL/ELT pipelines and data transformation logic.
• Work with BI and Analytics teams to enable high-quality reporting and dashboard solutions.
• Ensure data designs support performance, scalability, governance, and future business needs.
• Conduct data analysis, source-to-target mapping, and data lineage assessments.
• Facilitate design workshops, requirement gathering sessions, and solution reviews.
• Produce detailed design documentation, including process flows, mapping specifications, and data dictionaries.
• Support data quality, governance, and master data management initiatives.
• Act as a liaison between business users, architects, developers, and project teams.

Skills

Data analysis

Data modelling

Solution design

Data architecture

SQL

ETL/ELT

Cloud platforms

Stakeholder engagement

Workshop facilitation

Data governance

Tools

Snowflake

Azure Synapse

Databricks

Power BI

Tableau

Qlik

Redshift

BigQuery

Microsoft Fabric

Job description

We are seeking a Senior Data Solution Designer with strong expertise in data modelling, business requirement analysis, solution design, and reporting data structures. The ideal candidate will bridge business and technology teams, translating complex requirements into scalable, reporting-ready data solutions while working closely with data engineers, architects, analysts, and business stakeholders.

Key Responsibilities

• Engage with business stakeholders to understand, analyze, and document data and reporting requirements.
• Translate business needs into scalable technical solution designs and data models.
• Design conceptual, logical, and physical data models aligned with enterprise architecture standards.
• Define and create reporting-ready datasets, semantic layers, and analytical data structures.
• Collaborate with Data Engineers to design ETL/ELT pipelines and data transformation logic.
• Work with BI and Analytics teams to enable high-quality reporting and dashboard solutions.
• Ensure data designs support performance, scalability, governance, and future business needs.
• Conduct data analysis, source-to-target mapping, and data lineage assessments.
• Facilitate design workshops, requirement gathering sessions, and solution reviews.
• Produce detailed design documentation, including process flows, mapping specifications, and data dictionaries.
• Support data quality, governance, and master data management initiatives.
• Act as a liaison between business users, architects, developers, and project teams.

Required Skills & Experience

• 8+ years of experience in Data Analysis, Data Modelling, Solution Design, or Data Architecture.
• Strong expertise in:
  • Data Modelling (Conceptual, Logical, Physical)
  • Dimensional Modelling (Star Schema, Snowflake Schema)
  • Data Warehousing Concepts
  • Data Mapping and Data Lineage
• Proven experience translating business requirements into technical data solutions.
• Strong understanding of reporting and analytics data structures.
• Experience designing reporting-ready datasets for BI platforms.
• Advanced SQL skills and strong data analysis capabilities.
• Experience working with enterprise data platforms and cloud environments.
• Excellent stakeholder engagement and workshop facilitation skills.
• Strong documentation and communication skills.
• Ability to collaborate effectively with engineering and business teams.

Preferred Skills

• Experience with Snowflake, Azure Synapse, Databricks, Microsoft Fabric, Redshift, or BigQuery.
• Familiarity with Power BI, Tableau, or Qlik.
• Knowledge of ETL/ELT frameworks and Data Integration tools.
• Understanding of Data Governance, Metadata Management, and Data Quality frameworks.
• Experience working in Agile delivery environments.
• Exposure to Data Vault modelling methodologies.