Data Warehouse Architect

Ascendion

Plano (TX)

On-site

USD 71,400 - 90,440

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) retirement plan

Personal days

Paid time off

Tuition Reimbursement Program

Job summary

A digital engineering solutions company in Texas seeks a Data Warehouse Developer/Architect. This role focuses on designing, building, and optimizing enterprise-grade data solutions using Snowflake and Databricks. Ideal candidates will translate complex business requirements into scalable data models and will have strong expertise in ETL/ELT pipeline development, SQL, and cloud platforms like AWS. The position offers a salary range of $71,400 to $90,440, alongside benefits like medical, dental, vision insurance, and a robust paid vacation policy.

Qualifications

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.

Responsibilities

Design and develop scalable data warehouse architectures using Snowflake.
Build and optimize robust data metrics aligned with business requirements.
Develop and maintain ETL/ELT pipelines focused on performance.

Skills

Snowflake and Databricks architectures

Data warehousing concepts

ETL/ELT pipelines

SQL proficiency

Tableau

Amazon QuickSight

Job description

Company Overview

Ascendion is a full‑service digital engineering solutions company that designs and manages software platforms and products that power growth and deliver captivating experiences to consumers and employees. We accelerate transformation for enterprise clients across engineering, cloud, data, experience design and talent solution capabilities. Headquartered in New Jersey, our workforce of 6,000+ Ascenders delivers solutions worldwide.

About the Role

Job Title: Data Warehouse Developer/Architect

Job Summary: We are seeking a skilled Data Warehouse Developer/Architect to design, build and optimize enterprise‑grade data solutions 专. This role focuses on translating complex business requirements into scalable, high‑performance data models, pipelines and metrics using modern cloud data platforms. The ideal candidate will have strong 돌 expertise in Snowflake, Databricks and BI visualization tools, with a deep understanding of data architecture, governance and analytics best practices.

Key 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 datadifference quality, governance and security best practices across platforms
Support performance tuning, cost optimization and platform scalability initiatives

Required Skills & Qualifications

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 Qualifications

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

Salary Range

The salary for this position is between $71,400 and $90,440 annually. Factors that may affect pay within this range include geography/market, skills, education, experience and other qualifications of the successful candidate.

Benefits