Talent.com
Data Warehouse and Lake Architect
Data Warehouse and Lake ArchitectAurigo Software Technologies • Republic Of India, IN
Data Warehouse and Lake Architect

Data Warehouse and Lake Architect

Aurigo Software Technologies • Republic Of India, IN
30+ days ago
Job description

Role Summary:

We are seeking an experienced Data Architect to design and implement our enterprise data architecture, with a focus on Data Warehouse/Data Lake / Data Mesh. This position offers an opportunity to shape the data foundation of our organization, working with cutting-edge technologies and solving complex data challenges in a collaborative environment.


Key Responsibilities:

  • Design, develop, and maintain scalable enterprise data architecture incorporating data warehouse, data lake, and data mesh concepts
  • Create and maintain data models, schemas, and mappings that support Reporting, business intelligence, analytics, and AI/ML initiatives
  • Establish data integration patterns for batch and real-time processing using AWS services (Glue, DMS, Lambda), Redshift, Snowflake or Data Bricks.
  • Define technical specifications for data storage, data processing, and data access patterns
  • Develop data models and enforce data architecture standards, policies, and best practices
  • Partner with business stakeholders to translate requirements into architectural solutions
  • Lead data modernization initiatives, including legacy system migrations
  • Create roadmaps for evolving data architecture to support future business needs
  • Provide expert guidance on complex data problems and architectural decisions


Required Qualifications:

Education & Experience

  • Bachelor’s degree in computer science, Information Systems, or related field;
    Master’s degree preferred
  • 8+ years of experience in data architecture, database design, data modelling or related roles
  • 5+ years of experience with cloud data platforms, particularly AWS data services
  • 3+ years of experience architecting MPP database solutions (Redshift, Snowflake, etc.)
  • Expert knowledge of data warehouse architecture and dimensional modelling
  • Strong understanding of AWS data services ecosystem (Redshift, S3, Glue, DMS, Lambda)
  • Experience with SQL Server and migration to cloud data platforms
  • Proficiency in data modelling, entity relationship diagrams, and schema design
  • Working knowledge of data integration patterns and technologies (ETL/ELT, CDC)
  • Experience with one or more programming/scripting languages (Python, SQL, Shell)
  • Familiarity with data lake architectures and technologies (Parquet, Delta Lake, Athena)
  • Excellent verbal and written communication skills, with ability to translate complex technical concepts to varied audiences
  • Strong stakeholder management and influencing skills
  • Experience implementing data warehouse, data lake and data mesh architectures
  • Good to have knowledge of machine learning workflows and feature engineering
  • Understanding of regulatory requirements related to data (Fed Ramp, GDPR, CCPA, etc.)
Create a job alert for this search

Data Warehouse and Lake Architect • Republic Of India, IN

Similar jobs

Principal Data Warehouse Architect (Snowflake)

USEReadyRepublic Of India, IN

USEReady helps businesses to be self-reliant on data.Growing over 3000% since inception, USEReady achieved #113 rank in Inc 500 2015 and honoured top 100 companies in North America 2015 by Red Herr...Show more

 • Promoted

Data Warehouse Architect

DeloitteRepublic Of India, IN

Every day, your work will make an impact that matters, while you thrive in a dynamic culture of inclusion, collaboration and high performance.As the undisputed leader in professional services.Deloi...Show more

 • Promoted

Data Warehouse Solutions Architect

HireginieRepublic Of India, IN

Like the multiple facets of a diamond, this corporate goes beyond the value chain by providing superior products, customer care and services that are acknowledged within the global jewelry industry...Show more

 • Promoted

Data Warehouse Solutions Engineer

Tredence Inc.Chennai, Republic Of India, IN

Primary Roles and Responsibilities:.Developing Modern Data Warehouse solutions using Databricks and Azure Stack.Ability to provide solutions that are forward-thinking in data engineering and analyt...Show more

 • Promoted

Databricks Solutions Architect

Tata Consultancy ServicesRepublic Of India, IN

Must have experience at least end to end implementation of.Databrick cloud data warehouse.Databrick data modelling, ELT using Databrick SQL.Procedures and standard DWH and ETL concepts.Expertise in...Show more

 • Promoted

Data Lakehouse Architect

ThreatXIntelChennai, Republic Of India, IN

Cybersecurity, IT Staffing, and Consulting company delivering end-to-end technology and security solutions.ThreatXIntel is the official hiring partner.The ideal candidate should be capable of build...Show more

 • Promoted

Data Lake Solutions Architect

Persistent SystemsRepublic Of India, IN

We are seeking a Data Engineer/Developer to join our IS/IT squad, working under the guidance of a Team Leader to deliver high‑quality data solutions.In this role, you will be responsible for design...Show more

 • Promoted

Lead Data Warehouse Developer (Snowflake)

Programmers.ioJaipur, Republic Of India, IN

We are seeking a Senior SQL Developer with deep Snowflake expertise to support and enhance our cloud data platform.This role demands advanced SQL proficiency, hands-on experience with Snowflake dat...Show more

 • Promoted

Senior Data Warehouse Architect

Calfus Inc.Republic Of India, IN

At Calfus, we are known for delivering cutting-edge AI agents and products that transform businesses in ways previously unimaginable.We empower companies to harness the full potential of AI, unlock...Show more

 • Promoted

Data Architect

Aurigo Software TechnologiesRepublic Of India, IN

We are seeking an experienced Data Architect to design and implement our enterprise data architecture, with a focus on Data Warehouse/Data Lake / Data Mesh.This position offers an opportunity to sh...Show more

 • Promoted

Senior Data Architect

ThreatXIntelChennai, Republic Of India, IN

Cybersecurity, IT Staffing, and Consulting company delivering end-to-end technology and security solutions.ThreatXIntel is the official hiring partner.We are looking for a highly experienced.Snowfl...Show more

 • Promoted

Cloud Data Warehouse Architect

Apex SystemsRepublic Of India, IN

Must-Have Skills & Responsibilities.Snowflake architecture solutions.RBAC (Role-Based Access Control).Work closely with data engineering and business teams.Show more

 • Promoted

Lakehouse Data Architect

ALESAYI HOLDING | العيسائي القابضةChennai, Republic Of India, IN

Build and maintain all data pipelines feeding the Databricks lakehouse, ensuring clean, timely, and governed data flows from every source across the Investment Division’s five portfolio clusters an...Show more

 • Promoted

Senior Data Warehouse Architect

Persistent SystemsRepublic Of India, IN

We are seeking an experienced Data Engineer with strong expertise in Databricks, PySpark, Snowflake, and Data Warehousing (DWH) to design, build, and maintain scalable data pipelines and analytics ...Show more

 • Promoted

Data Pipeline Architect

Tata Consultancy ServicesChennai, Republic Of India, IN

Location- Chennai, Hyderabad, Bangalore.Desired Competencies (Technical/Behavioral Competency).Strong experience in programming languages such as Python, Java, or Scala for data manipulation and en...Show more

 • Promoted

Principal Data Warehouse Architect

CYAN360Republic Of India, IN

Position: SAP BW HANA Consultant.Work Timings: 4:30 PM to 12:30 AM IST.Minimum 10+ years experience on SAP BW HANA consultant with some BODS understanding.Must have experience with HANA SCRIPTING a...Show more

 • Promoted

Data Platform Solutions Architect

Apex SystemsRepublic Of India, IN

Must-Have Skills & Responsibilities.Snowflake architecture solutions.RBAC (Role-Based Access Control).Work closely with data engineering and business teams.Show more

 • Promoted

Enterprise Data Architect

Aurigo Software TechnologiesRepublic Of India, IN

We are seeking an experienced Data Architect to design and implement our enterprise data architecture, with a focus on Data Warehouse/Data Lake / Data Mesh.This position offers an opportunity to sh...Show more