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. • Datab [... source excerpt omitted ...] hooting 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 [... source excerpt omitted ...] lso 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.