Data Architect

Job Summary:

Core Competencies:

• Data Architecture & Strategy

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:

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