Data Solution Architect

Rarr Technologies; Pune District; Hybrid; INR 2,500,000 - 4,200,000; Full time

Job summary

Rarr Technologies in Pune seeks a Senior Data Architect to design and govern data architectures, modeling, and integration across platforms. You will translate business needs into scalable data solutions while collaborating with data engineers and stakeholders.

The role emphasizes data warehouses, data lakes, ETL/ELT pipelines, data governance, and security, enabling compliant and efficient data workflows in a fast-paced environment.

Qualifications

• Strong expertise in data modeling and database architecture.
• Hands-on SQL and relational DBMS experience.
• Experience with Snowflake or Redshift and data warehouses.
• Familiarity with ETL/ELT processes and data pipelines.
• Understanding of cloud data platforms (AWS, Azure, GCP).
• Knowledge of data security, privacy, and compliance.

Responsibilities

• Design and develop data models, schemas, and architecture diagrams.
• Define scalable data architecture frameworks for collection, storage, processing, integration, and consumption.
• Design and implement data warehouses, data lakes, ETL/ELT pipelines, and data integration solutions.
• Ensure GDPR, HIPAA and data privacy compliance across platforms.
• Monitor and optimize database and data platform performance for large-scale data.
• Establish governance standards for data quality, security, metadata, accessibility, and lifecycle.
• Evaluate data technologies and recommend scalable, cost-effective solutions.
• Collaborate with stakeholders, data engineers, developers, and teams to align architecture with business goals.
• Create and maintain architecture diagrams, technical specs, data models, and design docs.
• Identify challenges and implement robust solutions to improve reliability, scalability, and maintainability.

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.