Data Architect

10 hours ago

Sholinganallur Chennai Tamil Nadu, India Ignitho Technologies Full time

**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,000.00 - ₹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

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

  • Solution Architect

    2 weeks 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

    3 days ago

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

    Job Title: Data Architect – AWS & GCP Experience: 11 Years Location: Remote / Hybrid Job Type: Full-timeAbout the Role:We are seeking an experienced Data Architect with deep expertise in AWS and Google Cloud Platform (GCP). The ideal candidate will have a proven track record in designing and implementing scalable, secure, and high-performance data...

  • Solutions Architect

    5 days ago

    Chennai, Tamil Nadu, India NTT DATA Full time

    **Make an impact with NTT DATA** Join a company that is pushing the boundaries of what is possible. We are renowned for our technical excellence and leading innovations, and for making a difference to our clients and society. Our workplace embraces diversity and inclusion - it’s a place where you can grow, belong and thrive. **Your day at NTT...

  • Data Visualization Expert

    6 days ago

    Chennai, Tamil Nadu, India NTT DATA Full time

    We are currently seeking a Data Visualization Expert - Quick sight to join our team in Chennai, Tamil Nādu (IN-TN), India (IN). **What awaits you/ Job Profile** **Location : Bangalore and Chennai, Hybrid mode,Immediate to 10 Days Notice period** - Develop reports using Amazon Quicksight - Data Visualization Development: Design and develop data...

  • Data Architect

    1 day 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

    10 hours ago

    Chennai, Tamil Nadu, India Saaki Argus & Averil Consulting Full time

    **Hiring for Data Architect** **Location**: Chennai & Bangalore **Work mode**: Hybrid **Responsibilities**: - Design and implement robust data architectures that support business requirements and drive data-driven decision-making. - Develop and maintain scalable data models, data warehouses, and data lakes using Snowflake, Databricks, Hadoop, and...

  • Data Architect

    2 days ago

    Chennai, Tamil Nadu, India Versatile Consultancy Full time

    10 plus years of experience in Data Engineering with solid experience in design, development and implementation of end-to-end data ingestion and data processing system in AWS platform. 7 to 9 years of experience in AWS Glue, Lambda, Appflow, EventBridge, Python, PySpark, Lake House, S3, Redshift, Postgres, API Gateway, CloudFormation, Kinesis, Athena, KMS,...

  • Data Architect

    6 days ago

    Chennai, Tamil Nadu, India Virtusa Full time

    **Detailed Job Description for**Data Architect at PAN India**: - Minimum 9-13 Years of experience in IT Industry. - Bachelor’s Degree or equivalent number of years of experience in a Computer Science or Data Management related field. - Experience in the use of conceptual and logical data modelling technologies. - Experience in defining and working with...

  • Aws Data Architect

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