Data Architect

Medimpact; Bengaluru; Hybrid; INR 1,500,000 - 2,500,000; Full time

Job summary

Medimpact is seeking an experienced Data Architect in Bengaluru, India, to lead the design and optimization of enterprise data ecosystems. You'll oversee database solutions using Oracle and PostgreSQL, ensuring compliance with data governance protocols and performance standards.

The role requires 12+ years of experience in data architecture, significant expertise in database technologies, and strong stakeholder management skills. Join Medimpact to drive innovative data management practices!

Qualifications

• 12+ years of experience in Data Architecture, Database Architecture, or Data Management.
• Strong experience with database performance tuning and optimization.
• Excellent communication and stakeholder management skills.

Responsibilities

• Lead the design and governance of the enterprise data ecosystem.
• Define and maintain data architecture standards and principles.
• Design and optimize large-scale Oracle and PostgreSQL databases.

Skills

Oracle Database

PostgreSQL

SQL and PL/SQL development

Data modeling methodologies

Data warehouse concepts

ETL and data integration technologies

Database performance tuning

Metadata Management

Master Data Management (MDM)

Power BI

Tableau

Education

Bachelor's or master's degree in computer science or related field

Tools

Informatica

SQL-Based ETL

Enterprise Reporting Platforms

Oracle RAC

Oracle Data Guard

PostgreSQL Streaming Replication

Job description

Position Summary

We are seeking an experienced Data Architect with 12+ years of experience to lead the design, governance, and optimization of our enterprise data ecosystem. The ideal candidate will possess deep expertise in Oracle and PostgreSQL database architectures, enterprise data modelling, data integration, and data governance. This role will be responsible for defining data architecture standards, ensuring scalability and performance of data platforms, and supporting strategic business initiatives through effective data management practices.

Key Responsibilities

Data Architecture & Design

• Define and maintain enterprise data architecture standards, principles, and best practices.
• Design conceptual, logical, and physical data models for enterprise applications and reporting systems.
• Architect scalable and maintainable database solutions using Oracle and PostgreSQL.
• Review and approve data designs across projects to ensure architectural consistency.

Database Architecture

• Design and optimize large-scale Oracle and PostgreSQL database environments.
• Define strategies for database partitioning, indexing, performance tuning, and capacity planning.
• Architect high‑availability and disaster recovery solutions.
• Support database upgrades, migrations, and consolidation initiatives.

Data Integration & Warehousing

• Define enterprise data integration standards and frameworks.
• Design ETL processes and data movement architectures.
• Support data warehouse and reporting solutions.
• Ensure data consistency and integrity across multiple systems.

Data Governance & Security

• Establish data governance frameworks, standards, and policies.
• Define data quality, metadata management, and lineage practices.
• Ensure compliance with security and regulatory requirements.
• Collaborate with security and infrastructure teams to protect enterprise data assets.

Leadership & Collaboration

• Work closely with business stakeholders, application teams, DBAs, and development teams.
• Provide technical leadership and mentorship to database developers and data engineers.
• Participate in architecture reviews and strategic planning initiatives.

Required Qualifications

• Bachelor's or masters degree in computer science, Information Systems, or a related field.
• Minimum 12 years of experience in Data Architecture, Database Architecture, or Data Management.
• Strong experience with Oracle and PostgreSQL databases.
• Expertise in SQL and PL/SQL development.
• Strong knowledge of data modeling methodologies and tools.
• Experience with data warehousing concepts and enterprise reporting solutions.
• Strong understanding of database performance tuning and optimization.
• Experience designing high‑availability and disaster recovery solutions.
• Experience with ETL and data integration technologies.
• Excellent communication and stakeholder management skills.

Technical Skills

Databases

• Oracle Database
• PostgreSQL
• Oracle RAC
• Oracle Data Guard
• PostgreSQL Streaming Replication

Data Architecture

• Enterprise Data Modelling
• Data Warehousing
• Master Data Management (MDM)
• Metadata Management
• Data Governance

ETL & Integration

• Informatica
• SQL-Based ETL
• Data Integration Frameworks

Reporting & Analytics

• Power BI
• Tableau
• Enterprise Reporting Platforms

Preferred Qualifications

• Experience in highly regulated enterprise environments.
• Experience supporting large-scale transactional systems.
• Experience defining enterprise-wide data standards and governance practices.
• TOGAF or equivalent architecture certification is a plus.
• Experience mentoring technical teams and leading architecture initiatives.

Key Competencies

• Enterprise Data Architecture
• Database Design & Optimization
• Data Governance
• Stakeholder Management
• Strategic Thinking
• Problem Solving
• Technical Leadership