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 & 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 diversestakeholders.
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.(ref : hirist.tech)