Data Warehouse Engineer

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 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 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. 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. Additional 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) 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
• [email protected]. Privacy Policy: 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). 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) 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.