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, andOptimise a robust data warehousing platform for the pharmaceutical industry. The goal is toensure seamless integration of diverse data sources, maintain high standards of data quality, andgovernance, and enable advanced analytics through the definition and management of semantic and common data layers. Utilising Axtria Data MAx 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 storageand retrieval.
• ETL Processes: Develop and optimize ETL processes to accurately and efficiently movedata 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 datagovernance policies to maintain data quality and security.
• Performance Optimisation: Continuously monitor and improve the performance of thedata warehouse to handle large volumes of data and complex queries.
• Semantic Layer Definition: Define and manage the semantic layer architecture andtechnologystack to manage the lifecycle of semantic constructs including consumption intodownstream systems.
• Common Data Layer Management: Integrate data from multiple sources into acentralizedrepository, ensuring consistency and accessibility.
• Deep expertise in architecting enterprise grade software systems that are performant,scalable, resilient and manageable. Architecting Gen AI based systems is an added plus.
• Advanced Analytics: Enable advanced analytics and machine learning to identifypatterns in genomic data, optimize clinical trials, and personalize medication.
• Generative AI: Should have worked with production ready usecase for Gen AI based dataand
• Stakeholder Engagement: Work closely with business stakeholders to understand theirdata needs and translate them into technical solutions.
• Data Modeling: Strong expertise in Data Modelling, with ability to design complex datamodels from the ground up and clearly articulate the rationale behind design choices.
• ETL Processes: Must have worked with different loading strategies for facts anddimensions like SCD, Full Load, Incremental Load, Upsert, Append only, Rolling Windowetc.
• Cloud Warehouse skills: Expertise in leading cloud data warehouse platforms—Snowflake, Databricks, and Amazon Redshift—with a deep understanding of theirarchitectural nuances, strengths, and limitations, enabling the design and deployment ofscalable, high-performance data solutions aligned with business objectives.
• Cross-Functional Collaboration: Collaborate with IT, data scientists, and businessanalysts to ensure the data warehouse supports various analytical and operational needs.Qualifications:
• Proven experience in data architecture and data warehousing, preferably in thepharmaceutical 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 Data MAx 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 regulatorystandards.
• Experience with generative AI technologies and their application in data warehousing

---