Data Warehouse Engineer
- Pay
- $101,500 – $188,500 per year
- Location
- San Jose, CA · On-site
- Job type
- Full-time
- Level
- Senior
- Experience
- 7+ years
- Education
- Bachelor's degree
- Listed
- 4 days ago
Skills & highlights for this role
- Data Modelling
- ETL Development
- Azure Data Factory
- SQL
- Relational Database Design
- Database Performance Optimization
- Azure SQL
- Data Warehousing
- Data Pipelines
- Reporting and Dashboards
- Data Analysis
- Troubleshooting
- Communication
Also useful
- Python
- Pentaho
- Shell Scripting
- Infor Omni-Channel Campaign Management
- IBM WAS
- Business process knowledge (quote to cash, clickstream analysis, revenue, booking, billing)
Role
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 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.
Pay and benefits
The annual salary range for California is $101,500-$188,500. You may also be eligible to receive incentive compensation: bonus, equity, and benefits. Please note that the salary range is a guideline and compensation may vary based on factors such as qualifications, skill level, competencies and work location. Our benefits programs include: paid vacation and paid holidays, 401(k) plan with employer match, employee stock purchase plan, a variety of medical, dental and vision plan options, and more.
We’re doing work that matters. Help us solve what others can’t.
About Cadence
At Cadence, we hire and develop leaders and innovators who want to make an impact on the world of technology.
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.
From Cadence's careers page, first listed on Rolev.ai on November 9, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this Data Warehouse Engineer role at Cadence, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
Common questions
What is the salary for the Data Warehouse Engineer role at Cadence?
The Data Warehouse Engineer posting at Cadence states compensation of $101,500 – $188,500 per year. It is listed as a full-time position. Final pay may depend on location, experience, and interview evaluation on Cadence's official career site.
Where is the Data Warehouse Engineer job at Cadence located?
This Data Warehouse Engineer position at Cadence is located in San Jose, CA (On-site). Always check Cadence's application page for specific state eligibility or relocation policies.
What qualifications are required for Data Warehouse Engineer at Cadence?
For the Data Warehouse Engineer role, Cadence highlights 7+ years of relevant experience; a bachelor's degree; experience with Data Modelling, ETL Development, Azure Data Factory, SQL, Relational Database Design, Database Performance Optimization. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.
How do I apply for the Data Warehouse Engineer position at Cadence?
This listing links directly to Cadence's Workday application page. You can apply directly on Cadence's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the Workday application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.