Data Warehouse Architect

MEDIUM DemandLOW AI RiskGROWING in SL· Rs.170k+ /mo

Ideal for data engineers who want to move up to architecture, designing the foundations that power all analytics and AI in an organisation.”

About This Role

Designing large-scale storage systems for high-performance data retrieval.

A Day in the Life

Design and build enterprise data warehouse infrastructure, define data models, integrate multiple data sources, and ensure data is reliable and accessible for analytics.

Design star and snowflake schema data models
Architect cloud or on-premises data warehouse
Develop and optimise ETL/ELT pipelines
Define data governance standards
Collaborate with BI and data science teams
Manage data warehouse performance tuning
Migrate legacy data systems to cloud platforms
Document data architecture and lineage

Work Environment

HYBRIDTeam: SMALLBUSINESS CASUALRemote: HIGH

Technical architecture role with significant design responsibility. Works with senior data engineers, architects, and BI teams.

Typical hours: 45h/week · WLB score 7/10 · OCCASIONAL overtime

Migration projects can be intense. Day-to-day architecture work is well-paced.

Skills Required

Technical Skills

Data WarehousingETL DevelopmentSQL DatabaseApache SparkAWSMicrosoft AzureGoogle Cloud (GCP)

Soft Skills

Analytical ThinkingAttention to DetailCommunication SkillsProblem Solving

Tools & Software

SnowflakeAWS RedshiftAzure SynapsedbtApache AirflowSparkPostgreSQLLooker

Salary in Sri Lanka (LKR / month)

Entry LevelRs.100k – Rs.150k/mo

Mid-LevelRs.170k – Rs.270k/mo

SeniorRs.270k – Rs.500k/mo

Entry: Data EngineerMid: Senior Data Engineer / DW ArchitectSenior: Lead Data Warehouse Architect

Typical progression: 4yr to mid · 8yr to senior

Global Salary (USD / year)

Entry Level$5k – $8k/yr

Mid-Level$10k – $18k/yr

Senior$18k – $35k/yr

Top Markets

USAUKAustraliaUAESingapore

Market Outlook

GROWING

Cloud data warehouse migration projects creating strong demand for architects in Sri Lanka.

Hiring: MEDIUM

VirtusaWSO2IFSDialog AxiataCommercial Bank99x Technology

GROWING

One of the most in-demand data roles globally as enterprises move to cloud data lakes and warehouses.

Entry Requirements

Sri Lanka

Min. EducationDegree

Experience3+ years data engineering

Preferred

B.Sc. ITAWS Data AnalyticsDP-203dbt Certification

Global

Min. EducationDegree

Experience5+ years data engineering

Preferred

AWS Data Analytics SpecialtyGoogle Professional Data EngineerDP-203

Helpful Certifications

AWS Certified Data AnalyticsDP-203 Azure Data EngineerGoogle Professional Data Engineerdbt Certification

Entrepreneurship & Freelancing

Freelance: HIGHRemote: HIGHCapital: LOW

Freelance earnings: $50–$150/mo (USD)

Platforms (SL)

UpworkLinkedIn

Business Ideas

Data engineering consultancy
Cloud migration firm
Data platform SaaS

Side Income Ideas

Freelance data architectureCloud data consultingOnline data engineering courses

Strong remote freelance market for cloud data architects.

Risks & Challenges

AI / Automation Risk

LOW

LONG TERM

Burnout Risk

LOW

Job Security (SL)

HIGH

Architecture decisions require deep human expertise. AI-assisted development is a tool, not a replacement.

Burnout Causes

Large-scale migration complexityTechnical debt in legacy systems

Physical Health Risks

Sedentary work

Mental Health Risks

Complexity pressure from large systems

How to Mitigate

Get cloud data certifications (AWS/Azure/GCP)
Learn dbt and modern data stack
Build Snowflake or Redshift expertise

Is This Career For You?

Data engineers looking to grow into senior architect roles designing enterprise-scale data platforms.

Personality Types

INTJISTJINTP

Core Motivations

Building reliable data foundationsDesigning elegant data architecture

What You'll Love

High salaries
Critical infrastructure ownership
Strong remote work potential

What's Challenging

Legacy system complexity
Scale and performance challenges