Data Warehouse Architect

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.

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.

• 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 Quick Sight
• Ensure data difference quality, governance and security best practices across platforms
• Support performance tuning, cost optimization and platform scalability initiatives

• 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 Quick Sight 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

• 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

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.

• Medical insurance
• Dental insurance
• Vision insurance
• 401(k) retirement plan
• Long‑term disability insurance
• Short‑term disability insurance
• Personal days accrued each calendar year
• Paid time off benefits meeting paid sick and safety time laws
• 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 chalet stranden
• Ascendion Learning Management System
• Tuition Reimbursement Program

Mid‑Senior level

Full‑time

Finance

Financial Services and Banking