Data Warehouse Engineer - Onsite San Jose, Azure & ETL Lead

Cadence Design Systems; San Jose (CA); On-site; USD 102,000 - 189,000; Full time

Benefits offered by this job

Paid vacation

401(k) plan with employer match

Employee stock purchase plan

Medical, dental and vision plans

Job summary

Cadence Design Systems is seeking a Data Warehouse Engineer to join our on-site team in San Jose, CA. The role focuses on designing and developing data models, ETL processes, and data pipelines using Azure Data Factory and Azure SQL.

You will ensure data quality, security, and scalable warehouse architecture while collaborating across domains. The ideal candidate has 7+ years in DW/BI with end-to-end implementations, strong SQL skills, and experience with Azure stack.

Qualifications

• Bachelor's degree in computer science, a related field or equivalent experience.
• 7+ years of experience in DW/BI space with end-to-end implementations.
• Experience with Azure SQL and Azure Data Factory."

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: Indexing, query tuning, and other optimization techniques.
• Data management: Ensuring data integrity, security, and consistency across multiple environments.
• Troubleshooting and problem solving: Resolve Datawarehouse issues and errors.
• Reporting and analysis: Develop reports and dashboards based on data warehouse data.

Skills

DW/BI experience

SQL proficiency

Data modeling

ETL development

Azure SQL

Azure Data Factory

Communication skills

Data governance

SQL Server

Oracle

Education

Bachelor's degree in computer science

Tools

Azure Data Factory

Azure SQL

SQL Server

Oracle

Infor Omni-Channel Campaign Management

IBM WAS

Pentaho

Python

Shell scripting

Job description

Cadence Design Systems is seeking a Data Warehouse Engineer to join our on-site team in San Jose, CA. The role focuses on designing and developing data models, ETL processes, and data pipelines using Azure Data Factory and Azure SQL.

You will ensure data quality, security, and scalable warehouse architecture while collaborating across domains. The ideal candidate has 7+ years in DW/BI with end-to-end implementations, strong SQL skills, and experience with Azure stack.