Data Warehouse Engineer jobs in United States
cer-icon
Apply on Employer Site
company-logo

Cadence · 1 week ago

Data Warehouse Engineer

Cadence is a company focused on hiring and developing leaders and innovators in technology. They are seeking a Data Warehouse Engineer to design, develop, and maintain data solutions, ensuring data accuracy and integrity while collaborating with business users to meet requirements.

AerospaceElectronic Design Automation (EDA)HardwareMobileSemiconductorSoftware
check
Growth Opportunities
check
H1B Sponsor Likelynote

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

Qualification

Data Warehouse DevelopmentETL DevelopmentAzure Data FactorySQL ProficiencyData ManagementDatabase DesignData ModelingAnalytical SkillsFunctional KnowledgePython KnowledgePentaho KnowledgeShell ScriptingIBM WAS UnderstandingProblem-solving SkillsCommunication Skills

Required

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
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
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
Education: Bachelor's degree in computer science, a related field or equivalent experience

Preferred

Understanding of IBM WAS (Web Application server) – node agents, manager, applications
Preferred knowledge of python, Pentaho, or shell scripting
Functional knowledge of common business processes like quote to cash, clickstream analysis, revenue, booking, billing, etc. is desirable

Company

Cadence is a market leader in AI and digital twins, pioneering the application of computational software to accelerate innovation in the engineering design of silicon to systems.

H1B Sponsorship

Cadence has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (306)
2024 (221)
2023 (282)
2022 (330)
2021 (233)
2020 (209)

Funding

Current Stage
Public Company
Total Funding
unknown
1998-02-20IPO

Leadership Team

leader-logo
Paul Cunningham
Senior Vice President and General Manager
linkedin
leader-logo
Tom Beckley
Senior Vice President, Custom IC & PCB Group
linkedin
Company data provided by crunchbase