L

Senior Data Engineer - Enterprise Data Warehouse

Visa Sponsorship
This Job is No Longer Active This position is no longer accepting applications
AI Summary

We are seeking a Senior Data Engineer to design, implement, and maintain enterprise-scale data warehouses. You will be responsible for data architecture, ETL/ELT pipelines, and data governance. The ideal candidate has 8-12 years of experience in data engineering and 3+ years designing enterprise data warehouses.

Key Highlights
Design and implement enterprise-scale data warehouses
Develop and optimize ETL/ELT pipelines
Ensure data quality, security, and governance
Provide technical leadership and mentoring
Key Responsibilities
Design and implement enterprise data warehouse architecture
Develop and optimize ETL/ELT pipelines
Ensure data quality, security, and governance
Provide technical leadership and mentoring
Technical Skills Required
Enterprise Data Warehouse Architecture Dimensional Modelling Advanced SQL Query Optimization ETL/ELT Engineering Data Governance Data Security
Benefits & Perks
Visa sponsorship
Nice to Have
Familiarity with IAM concepts and access controls

Job Description


Visa sponsorship provided.


Required Skills

· Data Architecture & Modelling


o Enterprise data warehouse architecture (on-prem, cloud, or hybrid)

o Dimensional modelling (star & snowflake schemas)

o Fact/dimension design, slowly changing dimensions (SCD Types 1–3)

o Understanding of data lake patterns


· Database & Performance

o Advanced SQL (Oracle & MSSQL)

o Query optimisation, indexing strategies, partitioning

o Handling large data volumes and complex joins

o Capacity planning and performance benchmarking


· ETL / ELT Engineering

o Design and implementation of ETL/ELT pipelines

o Experience with tools such as SSIS, Informatica, Azure Data Factory

o Change data capture (CDC) strategies

o Error handling, and logging

· Data Governance & Security

o Data quality frameworks (completeness, accuracy, timeliness)

o Row-level and column-level security

o Data lineage and metadata management

o Familiarity with IAM concepts and access controls (a plus)


· Leadership & Delivery

o Technical leadership and mentoring

o Code reviews and design authority

o Stakeholder communication and design walkthroughs

o Documentation standards


3. Required Experience

· 8–12 years in data engineering / DW roles

· 3+ years designing enterprise-scale data warehouses

· Proven experience delivering DW projects end-to-end

  • · Experience supporting analytics or regulatory reporting environments

Similar Jobs

Explore other opportunities that match your interests

Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Mid-Senior level

delta computer consulting

Los Angeles Metropolitan Area

Senior Data Scientist, AI Foundations Specialist Models

Data Science
11h ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

Capital One

United State

Principal Associate, Data Scientist

Data Science
11h ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

Capital One

United State

Subscribe our newsletter

New Things Will Always Update Regularly