Data Warehouse Engineer

Position Overview

At Cadence, we hire and develop leaders and innovators who want to make an impact on the world of technology. We are seeking a hardworking, highly motivated Data Warehouse Engineer with strong collaboration skills and the ability to work across multiple domains and software disciplines. This experienced, hands-on role involves research, analysis, design, and development of data solutions based on business requirements. You will work closely with business users to collect requirements, prepare design documents, develop ETL logic and validation scripts ensuring 100% data accuracy, design security controls, and deploy and monitor solutions in production.

Role: Data Warehouse Engineer Location: 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 techniques.
• Data Management – Ensuring data integrity, security, and consistency across multiple environments.
• Troubleshooting and Problem Solving – Resolving data warehouse-related issues and errors.
• Reporting and Analysis – Developing and providing reports and dashboards based on data warehouse datasets.

Required Qualifications

• 7+ years of experience in the DW/BI space, including designing models and building analytics with at least two end-to-end implementations and a minimum of 2 years in Azure SQL and ADF.
• SQL/Relational Database Proficiency – Strong knowledge of SQL syntax, database design principles, and experience with 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, including creating jobs, managing ETL processes, setting up jobs, report creation, and managing users/groups.
• Strong understanding of Azure Data Factory – Expert-level knowledge of its features, capabilities, and best practices.
• Mastery of Azure SQL stack architecture (SQL Server, SQL Warehouse, and Azure Data Factory).
• Understanding of data analysis principles and reporting techniques.
• Problem-solving and Analytical Skills – Ability to identify and resolve data warehouse issues and analyze complex data sets.
• Communication Skills – Ability to clearly convey technical concepts to both technical and non-technical audiences.
• Functional knowledge of common business processes (e.g., quote to cash, clickstream analysis, revenue, booking, billing, etc.).
• Education – Bachelor's degree in Computer Science, a related field, or equivalent experience.

Preferred Qualifications

• Understanding of IBM WAS (Web Application Server) – Knowledge of node agents, manager, and applications.
• Familiarity with Python, Pentaho, or shell scripting.