Data Architect

6 days ago

Sholinganallur Chennai Tamil Nadu, India Ignitho Technologies Full time ₹ 10,00,000 - ₹ 25,00,000 per year

Role: Data Architect

Job Summary

The Data Architect will lead the design and implementation of scalable, high-performance data architectures across both on-premise and cloud environments. This role involves advanced data modeling, 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 organizational goals.

Core Competencies

  • Data Architecture & Strategy
  • Advanced Data Modeling (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

  • Analyze existing data sources to understand data flow, relationships, and usage.
  • Design and implement scalable data models following best practices in normalization, denormalization, and dimensional modeling.
  • Develop and optimize complex SQL queries, including recursive SQLs and macros, to extract, transform, and analyze 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 visualization tools (e.g., Tableau, Power BI) is an advantage.
  • Experience in the Life Sciences or Pharmaceutical industry is highly desirable.

Job Types: Full-time, Permanent

Pay: ₹1,000, ₹2,500,000.00 per year

Benefits:

  • Flexible schedule
  • Health insurance
  • Life insurance
  • Provident Fund
  • Work from home

Work Location: In person

  • Solution Architect

    2 weeks ago

    Chennai, Tamil Nadu, India NTT DATA Full time

    **Req ID**: 279402 We are currently seeking a Solution Architect to join our team in Bangalore, Karnātaka (IN-KA), India (IN). **SFDC Solution Architect** **How You'll Help Us**: **As a Solution Architect, you will have the opportunity to get in on the ground floor of a new division created within one of the largest technology providers in the world. We...

  • Solution Architect

    2 days ago

    Chennai, Tamil Nadu, India NTT DATA Full time

    **Req ID**: 274964 We are currently seeking a Solution Architect to join our team in Chennai, Tamil Nādu (IN-TN), India (IN). As a Salesforce Technical Lead, resoure to work with our clients and internal teams to act as domain experts and drive the design of practical and innovative solutions across industries. We seek someone who communicates clearly and...

  • Data Architect

    2 weeks ago

    Chennai, Tamil Nadu, India Revolite Infotech Pvt. Ltd Full time

    **Job Title**: Data Architect **Experience**: 10 - 15 Years **Job Location**: Singapore or Bangkok **Core Expertise**: Designing and building **data models** (database structures, entity relationship diagrams). **Credit Data knowledge** (critical requirement). **Bonus**: Experience with **Payments and Transactions**. Proficiency in **ETL processes** and...

  • Data Architect

    2 weeks ago

    Chennai, Tamil Nadu, India Gainwell Technologies LLC Full time

    **Summary**: - As a **Data Architect** at Gainwell, you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the members they serve — a community’s most vulnerable. Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of...

  • Data Architect

    7 days ago

    Chennai, Tamil Nadu, India SourceFuse Full time

    **Job Information**: Work Experience: 15+ years Industry: IT Services **Job Type**: FULL TIME Location: Chennai, India **Role Overview**: **Key Responsibilities**: - **Architect and Design** scalable and secure data platforms, ensuring high availability and performance. - **Develop and Optimize** data pipelines and ETL processes using modern frameworks...

  • Data Architect

    2 weeks ago

    Chennai, Tamil Nadu, India Ciklum Full time

    Description **Ciklum** is looking for a **Data Architect **to join our team full-time in Chennai / Pune. We are a custom product engineering company that supports both multinational organizations and scaling startups to solve their most complex business challenges. With a global team of over 4,000 highly skilled developers, consultants, analysts and...

  • Data Architect

    2 weeks ago

    Chennai, Tamil Nadu, India Barclays Full time

    Embark your transformative journey as Data Architect Vice president based out of Chennai. You will design, develop, and implement solutions to solve complex business problems, collaborating with stakeholders to understand their needs and requirements, and design and implement solutions that meet those needs and create solutions that balance technology risks...

  • Data Architect

    3 days ago

    Chennai, Tamil Nadu, India Virtusa Full time

    Hands-on experience in data modelling, database design, and data administration is mandatory. Mandatory knowledge of data warehousing ideas and proficiency in various database systems. Mandatory knowledge of data modelling tools such as Erwin, IBM Data Architect, or Microsoft Visio is required. Require knowledge of ETL methods and technologies. Strong...

  • Data Architect

    2 weeks ago

    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 major...

  • Data Architect

    2 weeks ago

    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...