Data Warehouse Engineer

Cadence Design Systems, Inc. • San Jose, CA • 1d ago

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.

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.

We're doing work that matters. Help us solve what others can't.

Additional Jobs (https://cadence.wd1.myworkdayjobs.com/addl_jobs)

Equal Employment Opportunity Policy:

Cadence is committed to equal employment opportunity throughout all levels of the organization.

Read the policy(opens in a new tab) (https://www.cadence.com/content/dam/cadence-www/global/en_US/documents/company/careers/equal-employment-opportunity-policy.pdf)

We welcome your interest in the company and want to make sure our job site is accessible to all. If you experience difficulty using this site or to request a reasonable accommodation, please contact staffing@cadence.com.

Job Applicant If you are a job seeker creating a profile using our careers website, please see the privacy policy(opens in a new tab) (https://www.cadence.com/en_US/home/privacy/privacy-policy.html) .

E-Verify Cadence participates in the

E-Verify program in certain U.S. locations as required by law. Download More Information on E-Verify (64K) (https://www.cadence.com/content/dam/cadence-www/global/en_US/documents/company/careers/e-verify-participation-poster.pdf)

Cadence plays a critical role in creating the technologies that modern life depends on. We are a global electronic design automation company, providing software, hardware, and intellectual property to design advanced semiconductor chips that enable our customers create revolutionary products and experiences.

Thanks to the outstanding caliber of the Cadence team and the empowering culture that we have cultivated for over 25 years, Cadence continues to be recognized by Fortune Magazine as one of the 100 Best Companies to Work For. ? Our shared passion for solving the world's toughest technical challenges, our dedication to pushing the limits of the industry, and our drive to do meaningful work differentiates the people of Cadence.

Cadence is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, basis of disability, or any other protected class.

Cadence is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, basis of disability, or any other protected class.

Similar Jobs

Leader, Manufacturing Quality Engineering

Cisco • San Jose, CA • 4h ago

IT & Engineering

The application window is expected to close on: January 11, 2026. NOTE: Job posting may be removed earlier if the position is filled or if a sufficient number of applications are received. Candidate must be local to the...

4h ago

Go to Apply

Mechanical Engineering Technical Leader

Cisco • San Jose, CA • 5h ago

IT & Engineering

Meet the Team Designs and analyzes mechanical systems, equipment and packaging. Conducts feasibility studies and testing on new and modified designs. Directs support personnel in the preparation of detailed design, desig...

5h ago

Go to Apply

Google • Sunnyvale, CA • 16h ago

IT & Engineering

Business Data Scientist, Statistics, Platform Analytics, Google Cloud corporatefare_ Google place Sunnyvale, CA, USA; San Francisco, CA, USA Mid Experience driving progress, solving problems, and mentoring more junior te...

16h ago

Go to Apply

Senior Data Scientist, Product, Consumer Shopping

Google • Mountain View, CA • 16h ago

IT & Engineering

Senior Data Scientist, Product, Consumer Shopping corporatefare_ Google place Mountain View, CA, USA; New York, NY, USA Mid Experience driving progress, solving problems, and mentoring more junior team members; deeper ex...

16h ago

Go to Apply

Member of Technical Staff - Data Scientist

Microsoft Corporation • Mountain View, CA • 16h ago

IT & Engineering

Overview We're?looking for data scientists to help build the next generation of post-training methods for frontier models at Microsoft AI.?You'll?join a small, high-impact team working across all stages of post-training,...

16h ago

Go to Apply

Subscribe to get new jobs sent directly to you
(no charge, cancel anytime)

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.