Data Warehouse Architect jobs in United States
cer-icon
Apply on Employer Site
company-logo

Ascendion · 4 days ago

Data Warehouse Architect

Ascendion is a full-service digital engineering solutions company that focuses on delivering captivating experiences through innovative software platforms. They are seeking a skilled Data Warehouse Architect to design and optimize enterprise-grade data solutions, translating complex business requirements into scalable data models and pipelines using modern cloud data platforms.

Augmented RealityCloud ComputingConsultingSoftware Engineering
check
H1B Sponsor Likelynote
Hiring Manager
Muskan Khatun
linkedin

Responsibilities

Design and develop scalable data warehouse and lakehouse architectures using Snowflake and Databricks
Build and optimize robust data metrics and semantic models aligned with business requirements
Develop and maintain ETL/ELT pipelines with a focus on performance, reliability, and scalability
Implement comprehensive metadata management, data lineage, and documentation standards
Apply advanced data modeling techniques (dimensional, star/snowflake, fact & dimension modeling)
Partner with business stakeholders to translate analytical needs into technical solutions
Build and enhance dashboards and reports using Tableau and Amazon QuickSight
Ensure data quality, governance, and security best practices across platforms
Support performance tuning, cost optimization, and platform scalability initiatives

Qualification

SnowflakeDatabricksETL/ELT pipelinesSQLTableauAmazon QuickSightData modeling techniquesCloud platformsData governance frameworksData catalog toolsStreaming data processingCI/CD pipelinesAnalytical skillsProblem-solving skillsCommunication skills

Required

Strong experience with Snowflake and Databricks architectures
Expertise in data warehousing concepts and data modeling techniques
Hands-on experience building ETL/ELT pipelines
Proficiency in SQL and working with large-scale datasets
Experience with Tableau and Amazon QuickSight for dashboard development
Knowledge of metadata management, data lineage, and documentation practices
Familiarity with cloud platforms (AWS preferred)
Strong analytical, problem-solving, and communication skills

Preferred

Experience with data governance frameworks and data catalog tools
Knowledge of streaming or near-real-time data processing
Exposure to CI/CD pipelines for data platforms
Background in enterprise analytics or large-scale data environments

Benefits

Medical insurance
Dental insurance
Vision insurance
401(k) retirement plan
Long-term disability insurance
Short-term disability insurance
Personal days accrued each calendar year. The Paid time off benefits meet the paid sick and safe time laws that pertains to the City/ State
12-15 days of paid vacation time
6-8 weeks of paid parental leave after a year of service
9 paid holidays and 2 floating holidays per calendar year
Ascendion Learning Management System
Tuition Reimbursement Program

Company

Ascendion

twittertwitter
company-logo
Ascendion is a trusted ally for enterprise business and technology leaders engineering the digital future.

H1B Sponsorship

Ascendion has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (172)
2024 (193)
2023 (93)

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Karthik Krishnamurthy
Chief Executive Officer and Founder
linkedin
leader-logo
Daryush Laqab
Chief AI Officer
linkedin
Company data provided by crunchbase