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.
We’re doing work that matters. Help us solve what others can’t.
Data Warehouse Engineer • SAN JOSE
Launch Your Data Career with Proof, Not PromisesAt SynergisticitIf you're serious about starting a high-impact, high-paying career in Data Science, Analytics, or Engineering, it's time to stop gues... Show more
Data EngineerWe're hiring a Data Engineer to design, build, and operate the data pipelines and platform that power analytics and AI / ML use cases.You'll own batch and streaming ingestion, transfor... Show more
Certified Databricks ConsultantLocation:TX/GA/CADuration:Long-termClient:IBM/AT&TSkills:Need certified Databricks consultant with good experience in Spark and PySpark.Experience with Azure, Pyt... Show more
This role provides technical leadership in designing and optimizing ETL/ELT frameworks using Azure data services (Fabric, Data Lake, Data Factory), integrating data from ERP, CRM, and operational s... Show more
Job TitleScope of work:Provide operational network support for existing and new network components including but not limited to troubleshooting network problems, customer incident and request manag... Show more
A leading AI-driven data solutions company in California is seeking a Senior Software Engineer to enhance AI capabilities and build scalable data infrastructures.You will design robust data systems... Show more
Joby Flight Training Simulator EngineerImagine a piloted air taxi that takes off vertically, then quietly carries you and your fellow passengers over the congested city streets below, enabling you ... Show more
Data EngineerLocation:San Ramon, CA (100% Onsite)Duration:6-12 MonthsPositions:2Start Date:1/9/23Job Description:Integrate, extract the data using ETL and inject using AWS, build pipeline from AWS ... Show more
Staff Software Engineer, Data FrameworksAre you a seasoned engineer passionate about transforming data into a powerful business asset? Do you thrive in environments where you can lead by example, m... Show more
Store Processor FT - Scotts Valley.Scotts Valley 19 - Scotts Valley, CA 95066.Hourly Position Type Part Time Job Shift Day Education Level Not Specified Travel Percentage Negligible Category Retail... Show more
Data Solution ArchitectLocation:Contract - Long Term, Dublin, CAType:Hybrid 3 days in Onsite RoleNeed & Responsibilities:The position is for a Solution Data Architect focused on the SVT (Single... Show more
Software Principal EngineerThe Software Engineering team delivers next-generation application enhancements and new products for a changing world.Working at the cutting edge, we design and develop s... Show more
Summary Allocate is looking for a Lead AI Data Engineer to design and implement the foundational data infrastructure that will power our AI-driven portfolio analysis and investment recommendation a... Show more
Data EngineerLocation:RemoteExperience:4YearsAbout the Role:A Fintech is seeking a strong and passionate data engineer with experience in large scale system implementation, with a focus on complex ... Show more
About the job Remote Data EngineerRemote Data Engineer needs 10 years experienceRemote Data Engineer requires :Must be local top Santa ClaraCloud Platform Expertise (GCP Focus) :Extensive hands-on ... Show more
Senior Software Engineer - Data InfrastructureApplied Intuition, Inc.Founded in 2017 and now valued at $15 billion, the Silicon Valley company is creating the digital infrastructure needed to bring... Show more
Marketing Technology Team PositionThe Marketing Technology team has the mandate of increasing the rate of customer acquisition, retention, and revenue by optimizing products and inventing new marke... Show more
What You'll DoDesign, build, and maintain large-scale data pipelines (batch and streaming) for robotics foundation model training and evaluation at petabyte scaleOwn core data infrastructure :data ... Show more
Viridian Staffing's client is seeking a controller to serve as their first dedicated accounting leader within a fast-growing, innovation-driven organization.This is a unique opportunity for an expe... Show more
Controller (Hands-On Build Role | Hardware / Manufacturing).Location: Scotts Valley, CA (Onsite 45 days/week) Relocation support provided Salary: $230,000 $270,000 base + meaningful equity.We are ... Show more
