Data Architect

23 hours ago

Chennai, Tamil Nadu, India Ignitho Inc. Full time ₹ 6,00,000 - ₹ 18,00,000 per year

Job Summary:

The Senior Data Architect will lead the design and implementation of scalable, high performance data architectures across both on-premises and cloud environments. This role involves advanced data modelling, SQL development, and ETL design, with a strong focus on data quality, integrity, and strategy. The architect will collaborate closely with cross-functional teams to align technical solutions with business needs, perform in depth data analysis, and drive the development of robust data models that support long-term organisational goals.

Core Competencies:


• Data Architecture & Strategy


• Advanced Data Modelling (Star, Snowflake)


• SQL Development (Partitioning, Stored Procedures, Recursive Queries)


• Data Profiling & Root Cause Analysis


• ETL Design & Implementation


• Cloud & On-Premise Data Platforms (Oracle, Databricks)


• Data Quality & Governance


• Stakeholder Engagement


• Change Data Capture & Audit Strategy


• Cross-Functional Collaboration

Roles and Responsibilities:


• Analyse existing data sources to understand data flow, relationships, and usage.


• Design and implement scalable data models following best practices in normalisation, denormalization, and dimensional modelling.


• Develop and optimise complex SQL queries, including recursive SQLs and macros, to extract, transform, and analyse data.


• Architect end-to-end data strategies aligned with future-state objectives, focusing on performance, scalability, and flexibility.


• Reverse engineer data models through data profiling, identifying key attributes and relationships.


• Collaborate with business and technical stakeholders to map data patterns to underlying processes and use cases.


• Conduct root cause analysis (RCA) to troubleshoot data inconsistencies and propose effective resolutions.


• Perform frequency distribution and statistical analyses to detect data trends and quality issues.


• Design and implement change data capture (CDC), audit logging, and reference data strategies.


• Define and create mapping tables and helper tables to support flexible and configurable ETL processes.


• Own and ensure data integrity, accuracy, and completeness across platforms.

General Attributes:


• Demonstrates intellectual curiosity and passion for uncovering insights in complex datasets.


• Skilled communicator capable of translating technical concepts into actionable insights for diverse stakeholders.


• Engages effectively with clinicians, researchers, data scientists, and IT teams to gather requirements and align objectives.


• Leads deep-dive data analysis initiatives to support data-driven decision making.


• Collaborates across departments to deliver robust, business-aligned data models and solutions.

Preferred Skills


• Familiarity with data visualisation tools (e.g., Tableau, Power BI) is an advantage.


• Experience in the Life Sciences or Pharmaceutical industry is highly desirable.

  • Cloud SRE Architect

    22 hours ago

    Chennai, Tamil Nadu, India Bastion Data Solutions Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Company Description Bastion data solutions.. Role Description This is a full-time on-site role for a Cloud SRE Architect / DevOps Engineer at Bastion Data Solutions in Chennai. The role involves day-to-day tasks such as Site Reliability Engineering, troubleshooting, software development, system administration, and infrastructure management. Qualifications...

  • Salesforce Data Architect

    4 weeks ago

    Chennai, Tamil Nadu, India Photon Full time

    ROLE: Salesforce Data Architect Location: Chennai/Hyderabad/Bangalore Responsibilities: Lead assessment of legacy data (SAP C4C, HubSpot, Excel) Define Salesforce data model and mapping strategy Oversee migration design, validation, and reconciliation process Support data quality and governance framework Requirements: 6+ years of experience in data...

  • Salesforce Data Architect

    3 weeks ago

    Chennai, Tamil Nadu, India Photon Full time

    ROLE: Salesforce Data ArchitectLocation: Chennai/Hyderabad/BangaloreResponsibilities: Lead assessment of legacy data (SAP C4C, HubSpot, Excel) Define Salesforce data model and mapping strategy Oversee migration design, validation, and reconciliation process Support data quality and governance framework Requirements: 6+ years of experience in data...

  • Data Architect

    4 weeks ago

    Chennai, Tamil Nadu, India Tata Consultancy Services Full time

    TCS is Hiring Data Architect For Pune and Chennai locationExperience : 8 - 12 yearsMode of interview: VirtualLocation : Pune / ChennaiJOB DESCRIPTION:Must have:- Proficiency in SQL, data modeling tools, and pipeline orchestration tools.- Familiar with modern data stacks (Snowflake, Databricks, Apache Spark, Kafka).- Hands-on experience with at least one...

  • Data Architect

    2 weeks ago

    Chennai, Tamil Nadu, India Spectrum Consulting Full time

    Job Title : AI Architect - Agentic Systems & Data ContextLocation: ChennaiJob Type: Full-TimeExperience Level: 8+ yearsRole OverviewAs our AI Architect, you will be the chief designer of our intelligent, autonomous systems. You will establish the technical vision and architectural blueprint for Kripya's next-generation agentic AI solutions that power our...

  • Data Architect

    4 weeks ago

    Chennai, Tamil Nadu, India OptiSol Business Solutions Full time

    Position – Data Architect Experience: 8+ years Position Overview We are seeking a Data Architect who can understand enterprise data from the ground up and translate it into scalable, reliable, and dynamic designs. The ideal candidate will not only build robust data foundations but also leverage Generative AI (GenAI) and advanced data insights frameworks...

  • Data Architect

    3 weeks ago

    Chennai, Tamil Nadu, India OptiSol Business Solutions Full time

    Position – Data Architect Experience: 8+ years Position Overview We are seeking a Data Architect who can understand enterprise data from the ground up and translate it into scalable, reliable, and dynamic designs. The ideal candidate will not only build robust data foundations but also leverage Generative AI (GenAI) and advanced data insights frameworks to...

  • Data Architect

    3 weeks ago

    Chennai, Tamil Nadu, India Optisol Business Solutions Full time

    About the job :Position - Data Architect Experience : 8+ years Position Overview :We are seeking a Data Architect who can understand enterprise data from the ground up and translate it into scalable, reliable, and dynamic designs. The ideal candidate will not only build robust data foundations but also leverage Generative AI (GenAI) and advanced data...

  • Data Architect

    3 weeks ago

    Chennai, Tamil Nadu, India OptiSol Business Solutions Full time

    Position – Data Architect Experience: 8+ years Position Overview We are seeking a Data Architect who can understand enterprise data from the ground up and translate it into scalable, reliable, and dynamic designs. The ideal candidate will not only build robust data foundations but also leverage Generative AI (GenAI) and advanced data insights frameworks to...

  • GCP Data Architect

    4 weeks ago

    Chennai, Tamil Nadu, India Tata Consultancy Services Full time

    Job Role: GCP Data ArchitectJob Location: Chennai/Hyderabad/Pune/Bangalore/GurgaonExp Range: 10Years to 15Years.Desired Competencies (Technical/Behavioral Competency):Should have experience in GCP Data ArchitectShould have experience in Data Flow, Data Proc, Big QueryDevelop ETL/ELT pipeline using Data Flow, Data Proc, Big QueryProvide technical leadership...