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

  • Solutions Architect

    4 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 Architect

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

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

  • Data Architect

    6 days ago

    Chennai, Tamil Nadu, India Hyqoo Full time

    The data architect is responsible for designing, creating, and managing an organization’s data architecture. This role is critical in establishing a solid foundation for data management within an organization, ensuring that data is organized, accessible, secure, and aligned with business objectives. The data architect designs warehouses, file systems and...

  • Data Architect

    1 week ago

    Chennai, Tamil Nadu, India Tata Consultancy Services Full time

    Role - Data Architect Location -Chennai Experience - 10 to 18 Years Desired Competencies (Technical/Behavioral Competency) Required Technical Skill Set Data Bricks, Snowflake, ELT/ETL Architecture, Python, C++/Java Desired Competencies (Technical/Behavioral Competency) Must-Have - Knowledge of systems development, including system development life cycle,...

  • Data Architect

    1 week ago

    Chennai, Tamil Nadu, India Eicher Full time

    Location Chennai, Tamil Nadu, India Category HR/Finance/IT Posted Date 02/24/2025 Job Id P-100981 Job Requirements Job Title Data Architect Designation Team Manager Reports To CIO Job Purpose Data Architect will be responsible for defining strategy and executing Enterprise Business Intelligence and Digital Business Intelligence Solutions by...

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