Data Architect

RARR Technologies Pvt Ltd; Mumbai; On-site; INR 2,500,000 - 4,500,000; Full time

Job summary

RARR Technologies Pvt Ltd, Mumbai, is seeking an experienced Data Architect to design and govern our data landscape, leading data modeling, architecture design, and scalable platforms across on-prem and cloud. You will collaborate with engineering and business teams to deliver robust data solutions.

The role emphasizes security, compliance, performance tuning, and technology strategy, with responsibility for architecture artifacts, roadmaps, and data governance standards.

Qualifications

• Strong expertise in data modeling, database architecture, logical and physical data models, and schema design.
• Hands-on experience with SQL and relational database management systems (RDBMS).
• Knowledge of modern data warehouse technologies such as Snowflake and Amazon Redshift or equivalent.
• Experience designing and implementing ETL/ELT processes and enterprise data pipelines.
• Understanding of cloud-based data architecture and data services across AWS, Azure, or GCP.
• Strong understanding of data integration patterns, APIs, batch processing, and real-time data processing.
• Knowledge of data security, privacy, access controls, encryption, and compliance frameworks.
• Ability to identify data architecture challenges and implement scalable solutions.
• Strong verbal and written communication skills to explain architectural concepts to various stakeholders.
• Experience with data modeling and architecture tools.

Responsibilities

• Data Modeling & Design: design logical and physical data models, schemas, and architecture diagrams.
• Data Architecture: define scalable data architecture frameworks for collection, storage, processing, integration, and consumption.
• Infrastructure Planning: design data warehouses, data lakes, ETL/ELT pipelines, and integration solutions.
• Security & Compliance: ensure platforms comply with GDPR, HIPAA, and other privacy requirements.
• Performance Optimization: monitor and optimize data platforms for large-scale volumes.
• Data Governance: establish standards for data quality, security, metadata management, accessibility, and lifecycle.
• Technology Strategy: evaluate data technologies and recommend scalable, cost-effective solutions.
• Strategic Collaboration: work with stakeholders, data engineers, developers, and teams to align with business goals.
• Architecture Documentation: create and maintain architecture diagrams, specifications, data models, and documentation.
• Problem Solving: identify challenges and implement robust solutions to improve reliability and scalability.

Skills

Data architecture & modeling

Database technologies

Data warehousing

ETL/ELT

Cloud data platforms

Data integration

Security & compliance

Performance tuning

Analytical & strategic thinking

Communication skills

Architecture tools

Tools

ER/architecture diagramming tools

Job description

Job Description:

• Data Modeling & Design: Design and develop logical and physical data models, including database schemas, blueprints, and architecture diagrams.
• Data Architecture: Define scalable data architecture frameworks covering data collection, storage, processing, integration, and consumption.
• Infrastructure Planning: Design and implement data warehouses, data lakes, ETL/ELT pipelines, and data integration solutions.
• Security & Compliance: Ensure data platforms comply with regulatory and organizational standards such as GDPR, HIPAA, and other data privacy requirements.
• Performance Optimization: Monitor, analyze, and optimize database and data platform performance to efficiently handle large-scale data volumes.
• Data Governance: Establish standards for data quality, security, metadata management, accessibility, and lifecycle management.
• Technology Strategy: Evaluate data technologies and recommend scalable, cost-effective solutions aligned with enterprise requirements.
• Strategic Collaboration: Work closely with business stakeholders, data engineers, developers, and technical teams to align data architecture with business objectives.
• Architecture Documentation: Create and maintain architecture diagrams, technical specifications, data models, and design documentation.
• Problem Solving: Identify data architecture challenges and implement robust solutions to improve reliability, scalability, and maintainability.

Essential Skills

• Data Architecture & Modeling: Strong expertise in data modeling, database architecture, logical and physical data models, and schema design.
• Database Technologies: Hands-on experience with SQL and relational database management systems (RDBMS).
• Data Warehousing: Strong knowledge of modern data warehouse technologies such as Snowflake, Amazon Redshift, or equivalent platforms.
• ETL/ELT: Experience designing and implementing ETL/ELT processes and enterprise data pipelines.
• Cloud Data Platforms: Understanding of cloud-based data architecture and data services across AWS, Azure, or GCP.
• Data Integration: Strong understanding of data integration patterns, APIs, batch processing, and real-time data processing.
• Security & Compliance: Knowledge of data security, privacy, access controls, encryption, and compliance frameworks.
• Performance Tuning: Ability to identify and resolve database and data pipeline performance bottlenecks.
• Analytical & Strategic Thinking: Ability to understand business requirements and translate them into scalable technical and architectural solutions.
• Communication Skills: Strong verbal and written communication skills, with the ability to explain complex architectural concepts to both technical and non-technical stakeholders.
• Architecture Tools: Experience with data modeling and architecture tools such as ER/architecture diagramming tools.