> Markdown version of [/jobs/ext/1193189-data-warehouse-engineer](https://www.wearedevelopers.com/jobs/ext/1193189-data-warehouse-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Warehouse Engineer - **Company:** Cadence Design Systems, Inc. - **Location:** San Jose, CA, United States - **Experience:** Experienced - **Salary:** $101,500.0 - $188,500.0 - **Contract:** Permanent contract - **Skills:** Data Analysis, Databases, Data Integrity, Extract Transform Load (ETL), Data Warehousing, Relational Databases, Database Design, Database Storage Structures, Software Design Documents, Python (Programming Language), Microsoft SQL Server, SQL Azure, Oracle (Applications), Pentaho Data Integration, Performance Tuning, Query Optimization, Shell Script, SQL Stored Procedures, SQL Databases, Web Application Frameworks, Azure Data Factory, Database Optimization, Information Technology, Optimization Algorithms, Data Management, Infor - **Published:** July 6, 2026 - **Apply:** https://www.juju.com/job/00000000ge8dhn ## About the Role A hardworking, highly motivated Data warehouse engineer and should have collaboration skills, ability to work across multiple domains and software disciplines to achieve results. This is an experienced and hands-on Data Warehouse developer position that requires research, analysis, design, and development of solutions per our business requirements. To work closely with business users, collect business requirements, prepare design documents, develop ETL logic and validation scripts to ensure 100% data accuracy, design security control, and deploy and monitor solutions in production. Role: Data Warehouse EngineerLocation: San Jose, CA (onsite position) Key Responsibilities* Data Modelling - Designing and developing data models to efficiently store and retrieve information. * ETL Development - Creating and optimizing ETL processes to extract, transform, and load data from various sources ensuring data consistency and quality* Design, implement and maintain Data Pipelines using ADF* Database Design and Implementation: Designing and implementing relational and multidimensional database structures within the data warehouse. * SQL Query Development: Writing efficient SQL queries, stored procedures, and functions to extract, manipulate, and analyze data. * Database/ Performance Optimization: Optimizing database performance through indexing, query tuning, and other optimization techniques. * Data Management: Ensuring data integrity, security, and consistency across multiple environments. * Troubleshooting and Problem Solving: Troubleshooting and resolving Datawarehouse-related issues and errors.* Reporting and Analysis: Developing and providing reports and dashboards based on data warehouse data. Skills and Qualifications:* 7+ years of experience in DW/BI space in both designing the model and building analytics. At least executed two end-to-end implementations. At least worked for min. 2 year in Azure SQL and ADF * SQL / Relational Database Proficiency: Strong knowledge of SQL syntax, database design principles, and SQL Server, Oracle or other database systems. * Data Management: Experience with data modeling, data warehousing, and ETL (Extract, Transform, Load) processes* Proficient in Infor Omni-Channel Campaign Management- Enterprise Marketing Suite - creating jobs, ETL process in Infor Admin, setting up jobs, creation of reports, creating/updating users and Groups* Preferred Understanding of IBM WAS (Web Application server) - node agents, manager, applications* Strong understanding of Azure Data Factory: Expert-level knowledge of Azure Data Factory's features, capabilities, and best practices.* Master in Azure SQL stack architecture (SQL Server, SQL Warehouse and Azure Data factory)* Understanding of data analysis principles and reporting techniques. * Preferred knowledge of python, Pentaho, or shell scripting* Problem-solving and Analytical Skills: Ability to identify and resolve data warehouse issues and analyze complex data sets. * Communication Skills: Ability to communicate technical concepts to both technical and non-technical audiences. * Functional knowledge of common business processes like quote to cash, clickstream analysis, revenue, booking, billing, etc. is desirable. Education: Bachelor's degree in computer science, a related field or equivalent experience. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Hacking MSSQL on Cloud. All of them. How I became sysadmin on Azure, AWS, GCP and Alibaba.](https://www.wearedevelopers.com/videos/100339-hacking-mssql-on-cloud-all-of-them-how-i-became-sysadmin-on-azure-aws-gcp-and-alibaba) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Azure-Well Architected Framework - designing mission critical workloads in practice](https://www.wearedevelopers.com/videos/1529-azure-well-architected-framework-designing-mission-critical-workloads-in-practice) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)