Data Architect
- Ignitho
- 5 - 8 years
- Chennai
- 4 months ago
- Email to a friend
- Report this job
Job Description
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.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Project & Program ManagementRole Category: Technology / ITRole: Technology / IT - OtherEmployement Type: Full timeContact Details:
Company: IgnithoLocation(s): Chennai
Keyskills: Snowflake Data Architecture Advance Sql Data Modeling Data Bricks Visualizing ETL
Similar positions
Ignitho
Data Led, Cloud Enabled, Digital EngineeringIgnitho is a Digital Engineering company, taking Enterprises from ambition to success in the Data Led, Cloud Enabled, Digital Economy. Ignithos engineering services are powered by our IOIO framework, which leverages Frugal Innovation methodo...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in