Senior Data Architect
- Ignitho
- 10 - 15 years
- Chennai
- 28 days 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-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 Classification
Industry: Emerging Technologies (AI/ML)Functional Area / Department: Data Science & AnalyticsRole Category: Data Science & Analytics - OtherRole: Data Science & Analytics - OtherEmployement Type: Full timeContact Details:
Company: IgnithoLocation(s): Chennai
Keyskills: Databricks Unified Data Analytics Platform Snowflake Modeling Advance Sql 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