Enterprise Data Warehouse Architect

Narwal; India; On-site; INR 4,200,000 - 5,600,000; Full time

Job summary

Narwal is seeking a Senior Data Architect to design and govern the enterprise data warehouse, shaping data models, standards, and scalable data solutions. You will collaborate with analytics teams to enable robust data infrastructure.

With 12–18 years of experience, you will lead ETL development, optimize data flows, and ensure data quality and governance across cloud and on‑prem environments. Based in India.

Qualifications

• BE/B.Tech. in Computer Science with hands on knowledge of T-SQL, PL/SQL, Azure DW, Azure Data Factory
• Extensive experience in data warehousing architecture and ETL design
• Strong knowledge of SQL/NoSQL and data modelling
• Familiarity with data governance and regulatory requirements (e.g., GDPR/HIPAA)
• Ability to communicate complex technical concepts to business stakeholders

Responsibilities

• Design the enterprise data warehouse architecture for scalability, performance, and data integrity
• Lead ETL development and optimization for high performance
• Define data models, data flow diagrams, and database designs to support business needs
• Establish data quality standards and governance policies across the organization
• Collaborate with analysts, data scientists, and BI developers to align architecture with requirements

Skills

Data warehousing

SQL/NoSQL

ETL tools

Cloud platforms

Dimensional modelling

Data governance

Communication

Problem-solving

Education

BE/B.Tech. in Computer Science

Tools

Informatica

Talend

Azure Data Factory

Azure Data Warehouse

Job description

About Company

Narwal, with its Global Delivery Model, strategically expands its reach across North America, the United Kingdomand an offshore development centre in India. Delivery cutting edge AI, Data and Quality Engineering solutions and consistently surpassing expectations, Narwal has achieved remarkable triple-digit growth rates year after year, earning accolades such as Inc. 5000, Best IT Services Company, Best Data Technology Company, and Partner of the Year with Tricentis.

About Company

Narwal, with its Global Delivery Model, strategically expands its reach across North America, the United Kingdomand an offshore development centre in India. Delivery cutting edge AI, Data and Quality Engineering solutions and consistently surpassing expectations, Narwal has achieved remarkable triple-digit growth rates year after year, earning accolades such as Inc. 5000, Best IT Services Company, Best Data Technology Company, and Partner of the Year with Tricentis.

Our Vision

To be an expert in AI, Data and Quality Engineering transformations, bold in our thinking and authentic in our relationships.

Experience

12- 18 years

Skills and Competencies

• Technical Skills: Expertise in data warehousing concepts, database management (SQL/NoSQL), ETL tools (e.g., Informatica, Talend, Azure Data Factory), and cloud platforms (e.g., AWS, Azure, GCP).
• Data Modelling: Strong knowledge of dimensional modelling, star schema, and snowflake schema design.
• Data Governance: Knowledge of data privacy regulations (GDPR, HIPAA) and governance frameworks.
• Communication: Ability to translate complex technical concepts into business-friendly terms.
• Problem-Solving: Strong analytical skills to troubleshoot data and performance issues effectively.

Qualification

• BE/B.Tech. in Computer Science with hands on knowledge of T-SQL, PL/SQL, Azure DW, Azure Data Factory

Key Responsibilities

• Data Architecture Design:
  • Design the overall architecture for the enterprise data warehouse, ensuring scalability, performance, and data integrity.
  • Define standards and best practices for data modelling, storage, and access patterns.
  • Develop logical and physical data models, data flow diagrams, and database design that support business needs.
• ETL Process Development:
  • Lead the design and development of ETL (Extract, Transform, Load) processes to integrate data from various sources into the data warehouse.
  • Establish ETL workflows that ensure efficient, error‑free, and high-performance data extraction and transformation.
  • Optimize ETL processes for maximum performance and minimal downtime during data loads.
• Data Integration and Transformation:
  • Ensure the smooth integration of structured and unstructured data from disparate systems, including on-premises and cloud-based solutions.
  • Define data transformation rules to clean, normalize, and enrich data before loading it into the warehouse.
  • Oversee the integration of real‑time and batch data pipelines for continuous data ingestion.
• Data Quality and Governance:
  • Establish data quality standards and implement processes to ensure the accuracy, consistency, and reliability of data.
  • Collaborate with the data governance team to define and enforce data governance policies across the organization.
  • Implement monitoring and validation systems to detect and resolve data anomalies or discrepancies.
• Collaboration with Stakeholders:
  • Work closely with business analysts, data scientists, and BI developers to understand their data requirements and align the architecture to support these needs.
  • Partner with IT teams to ensure seamless integration between data systems and support application development initiatives.

Narwal, with its Global Delivery Model, strategically expands its reach across North America, the United Kingdom, and an offshore development center in India. Delivery cutting edge AI, Data, and Quality Engineering solutions and consistently surpassing expectations. Narwal has achieved remarkable triple-digit growth rates year after year, earning accolades such as Inc. 5000, Best IT Services Company, Best Data Technology Company, and Partner of the Year with Tricentis.

Our Vision

To be an expert in AI, Data, and Quality Engineering transformations, bold in our thinking and authentic in our relationships.