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. 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 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 Seniority Level Mid‑Senior level Employment Type Full‑time Job Function Finance Industries Financial Services and Banking #J-18808-Ljbffr Ascendion