Senior Data Architect

Job Title:- Senior Data Architect

Location:- NCR/(Bangalore preferably)

Experience:- 10+ Years

JOB OBJECTIVE:

To leverage expertise in data architecture and management to design, implement, and

Optimise a robust data warehousing platform for the pharmaceutical industry. The goal is to

ensure seamless integration of diverse data sources, maintain high standards of data quality, and

governance, and enable advanced analytics through the definition and management of semantic and common data layers. Utilising Axtria DataMAxTM and generative AI technologies, the aim is to accelerate business insights and support regulatory compliance, ultimately enhancing decision-making and operational efficiency.

Key Responsibilities:

• Data Modeling: Design logical and physical data models to ensure efficient data storage

and retrieval.

• ETL Processes: Develop and optimize ETL processes to accurately and efficiently move

data from various sources into the data warehouse.

• Infrastructure Design: Plan and implement the technical infrastructure, including hardware,

software, and network components.

• Data Governance: Ensure compliance with regulatory standards and implement data

governance policies to maintain data quality and security.

• Performance Optimisation: Continuously monitor and improve the performance of the

data warehouse to handle large volumes of data and complex queries.

• Semantic Layer Definition: Define and manage the semantic layer architecture and

technology

stack to manage the lifecycle of semantic constructs including consumption into

downstream systems.

• Common Data Layer Management: Integrate data from multiple sources into a

centralized

repository, ensuring consistency and accessibility.

• Deep expertise in architecting enterprise grade software systems that are performant,

scalable, resilient and manageable. Architecting GenAI based systems is an added plus.

• Advanced Analytics: Enable advanced analytics and machine learning to identify

patterns in genomic data, optimize clinical trials, and personalize medication.

• Generative AI: Should have worked with production ready usecase for GenAI based data

and

• Stakeholder Engagement: Work closely with business stakeholders to understand their

data needs and translate them into technical solutions.

• Data Modeling: Strong expertise in Data Modelling, with ability to design complex data

models from the ground up and clearly articulate the rationale behind design choices.

• ETL Processes: Must have worked with different loading strategies for facts and

dimensions like SCD, Full Load, Incremental Load, Upsert, Append only, Rolling Window

etc.

• Cloud Warehouse skills: Expertise in leading cloud data warehouse platforms—

Snowflake, Databricks, and Amazon Redshift—with a deep understanding of their

architectural nuances, strengths, and limitations, enabling the design and deployment of

scalable, high-performance data solutions aligned with business objectives.

• Cross-Functional Collaboration: Collaborate with IT, data scientists, and business

analysts to ensure the data warehouse supports various analytical and operational needs.

Qualifications:

• Proven experience in data architecture and data warehousing, preferably in the

pharmaceutical industry.

• Strong knowledge of data modeling, ETL processes, and infrastructure design.

• Experience with data governance and regulatory compliance in the life sciences sector.

• Proficiency in using Axtria DataMAxTM or similar data management products.

• Excellent analytical and problem-solving skills.

• Strong communication and collaboration skills.

Preferred Skills:

• Familiarity with advanced analytics and machine learning techniques.

• Experience in managing semantic and common data layers.

• Knowledge of FDA guidelines, HIPAA regulations, and other relevant regulatory

standards.

• Experience with generative AI technologies and their application in data warehousing