Data Architect

7 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

  • Javascript Fullstack Architect

    6 days ago

    Chennai, Tamil Nadu, India NTT DATA Full time

    **Req ID**: 326153 We are currently seeking a Javascript Fullstack Architect to join our team in Chennai, Tamil Nādu (IN-TN), India (IN). We are looking to hire a JavaScript Full Stack Architect to work with us: **Responsibilities**: - Understand client's business requirements and be able to map them to technology solutions and make them work - Design...

  • Salesforce Architect

    1 week ago

    Chennai, Tamil Nadu, India NTT DATA Full time

    Req ID 342476 NTT DATA strives to hire exceptional innovative and passionate individuals who want to grow with us If you want to be part of an inclusive adaptable and forward-thinking organization apply now We are currently seeking a Salesforce Architect - Service Cloud to join our team in Chennai Tamil N du IN-TN India IN We are seeking an experienced...

  • Data Architect

    1 week ago

    Chennai, Tamil Nadu, India Unifi Data Management Services Full time ₹ 20,00,000 - ₹ 50,00,000 per year

    Role Summary:The Data Architect is responsible for designing, governing, and implementing enterprise-wide data architecture strategies to enable trusted, scalable, and high-performing data platforms. This role ensures data consistency, security, and accessibility across multiple business domains aligning data initiatives with business goals and digital...

  • Data Architect

    2 weeks ago

    Chennai, Tamil Nadu, India Augusta Hitech Soft Solutions Full time

    **Industry**: IT ** Qualification**: Any Degree ** Required Skills**: Data Architect, Salesforce Data Integration, AWS ** Working Shift**: 2PM to 11PM IST ** City**: Coimbatore / Chennai / Bangalore **Country**: India- - Name of the position: Data Architect- - Location: Coimbatore/ Chennai/ Bangalore- - No. of resources needed: 01- - Mode: Contract to...

  • Data Architect

    6 days 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

    3 hours ago

    Guindy, Chennai, Tamil Nadu, India Prodapt Full time

    **Overview**: GCP data architect with network domain skills GCP ( DataProc, cloud composer, data flow, BQ ),,, python, spark Py spark,, Hands on experience in Network domain. (4G,5G, LTE and RAN) knowledge on these topics / work experience preferred Well Versed ETL architecture and data pipeline **Responsibilities**: GCP data architect with network domain...

  • Salesforce Commerce Cloud Architect

    4 days ago

    Chennai, Tamil Nadu, India NTT DATA Full time

    **Req ID**: 330404 We are currently seeking a Salesforce Commerce Cloud Architect to join our team in Chennai, Tamil Nādu (IN-TN), India (IN). " 5+ years of Salesforce consulting experience with 4+ end to end Experience Cloud projects (in a consulting capacity) - 8+ years of relevant work experience in the Salesforce Space, 2+ Years in eCommerce...

  • Data Architect

    2 days ago

    Chennai, Tamil Nadu, India TransCloud Labs Full time

    Job Information Date Opened - 02/04/2025 Job Type - Full time Industry - IT Services Work Experience - 5+ years City - Chennai State/Province - Tamil Nadu Country - India Zip/Postal Code - 600130 About Us - Transcloud is a cloud technology services company that helps businesses adopt the cloud to empower them for the future. Job Title - Data...

  • Data Architect

    3 hours ago

    Nanganallur, Chennai, Tamil Nadu, India Industrial Growth Analytik Info Techniqs Full time

    Data architects help companies make and meet strategic data management goals. They also work with data engineers and software designers to develop plans to integrate new databases. Some additional responsibilities of a data architect include: - Evaluating a company's current databases and data networks - Planning end-to-end data models for analysis and...

  • Aws Data Architect

    1 week ago

    Chennai, Tamil Nadu, India Whitefield Careers Full time

    **AWS Principal Data Architect - Hadoop Migration** We are seeking an experienced AWS Principal Data Architect to lead the migration of Hadoop DWH workloads from on-premise to AWS EMR. As an AWS Data Architect, you will be a recognized expert in cloud data engineering, developing solutions designed for effective data processing and warehousing requirements...