Job Description:

We are seeking for a Data Architect with over a decade of experience designing scalable data platforms and enterprise data models. This role requires solid knowledge of SQL/NoSQL databases distributed systems and cloud ecosystems across AWS Azure or GCP. The ideal candidate will build high-volume data pipelines real-time streaming solutions and robust ETL/ELT frameworks. Proficiency with tools like Spark Databricks Snowflake and major integration platforms is essential. You will design secure compliant data architectures aligned with GDPR HIPAA or CCPA. Additionally you will drive data governance practices including cataloguing lineage and access control.

Key Responsibilities:

- Has strong execution knowledge of Data Modeling Databases in general (SQL and NoSQL) software development lifecycle and practices unit testing functional programming etc.
- 10 years of experience in data architecture data engineering or related roles.
- 5 years of experience in building scalable enterprise data warehousing and modelling on prem and/or cloud AWS
- Expertise in data structures distributed computing manipulating and analyzing complex high-volume data from variety of internal and external sources.
- Expertise in cloud platforms such as Azure AWS or Google Cloud and their data services (e.g. Azure Data Lake AWS S3 BigQuery).

- Hands-on experience with data integration tools (e.g. Azure Data Factory Talend Informatica).
- Experience in developing ETL designs and data models for structured/ unstructured and streaming data sources
- Experience with real-time data streaming technologies like Kafka Kinesis or Event Hub.
- Proficiency with big data tools and frameworks like Apache Spark Databricks Snowflake or Hadoop.
- Experience with SQL and NoSQL databases (e.g. SQL Server Snowflake Cosmos DB DynamoDB).
- Apply understanding of pharma-specific data domains including clinical trial data real-world evidence (RWE)



commercial/sales data regulatory submissions and supply chain to design architectures that reflect the structure and sensitivity of that data
- Ensure data solutions are designed with pharma-grade compliance in mind including GxP 21 CFR Part 11 and HIPAA going beyond checkbox compliance to embed these requirements into architecture decisions from the ground up
- Solid knowledge of scripting and programming languages such as Python Spark Java or Scala.
- Design secure data solutions with deep knowledge of pharma-relevant compliance standards GDPR HIPAA 21 CFR Part 11 GxP including audit trail design data integrity controls and validated system requirements
- Implement and enforce data governance frameworks including data cataloguing lineage and access controls.

Required Skills and Experience:

- Experience in understanding and translating data analytic requirements and functional needs into technical requirements while working with global customers.
- Experience working with pharma data across at least two functional areas (e.g. Clinical Commercial Regulatory R&D; Medical Affairs Supply Chain) understanding the data models source systems and business context of each.
- Familiarity with pharma-specific data sources and platforms such as IQVIA Symphony Health Veeva clinical EDC systems (Medidata Oracle Clinical) or regulatory submission data.
- Experience architecting solutions for sensitive pharma data categories patient-level data adverse event reporting clinical trial results with appropriate anonymization access controls and lineage tracking
- Pharma consulting or client-facing experience is a strong differentiator; ability to translate regulatory and domain constraints into actionable architectural patterns.




- Design cloud-native data architectures that support scalable real-time and batch processing.
- Build and maintain data pipelines to support large scale data management in alignment with data strategy and data processing standards.
- Define strategies for data modelling data integration and metadata management.
- Robust experience in database data warehouse data lake design & architecture.
- Leverage cloud platforms (AWS Azure GCP etc.) for data storage compute and analytics services such as Azure Synapse AWS Redshift or Google BigQuery.
- Experience in Database programming using multiple flavour of SQL.
- Implement data governance frameworks including data quality lineage and cataloguing.
- Collaborate with cross-functional teams including business analysts data engineers and DevOps teams.
- Experience in Big Data ecosystem - on-prem (Hortonworks/MapR) or Cloud (Dataproc/EMR/HDInsight/Databricks/SnowPark)
- Evaluate emerging cloud technologies and recommend improvements to data architecture.
- Experience in any orchestration tool such as Airflow/Oozie for scheduling pipelines
- Hands-on experience in using Spark Streaming Kafka Databricks Snowflake etc.
- Experience working in an Agile/Scrum development process.
- Experience to optimize data systems for cost efficiency performance and scalability.

Being a Mathemagician:

- Embody MathCos culture and way of working.
- Demonstrate ownership and strive for excellence in delivering results.
- Actively engage and contribute to initiatives fostering company growth.
- Support diversity and appreciate different perspectives.

Recognitions:

- Positioned as a Leader in Top Generative AI Service Providers PeMa Quadrant 2023 by AIMResearch.
- Recognized among Inspiring Workplaces in North America 2023.o Accredited for Inclusive Practices by Great Place to Work Institute India.
- Recognized among Indias Best Workplaces for Diversity Equity Inclusion & Belonging 2023 by Great Place To Work India.

Required Experience:

Staff IC

📌 Data Architect Pharma (Bengaluru)
🏢 MathCo India
📍 Bengaluru