Data Warehouse Engineer
Cadence Design Systems, Inc.
SAN JOSE
hace 1 día

At Cadence, we hire and develop leaders and innovators who want to make an impact on the world of technology.

Job Responsibilities :

Manage all warehouse data, design architecture, and prepare appropriate documents to develop schema data model.

Coordinate with business users and prepare documents to plan and control various volumes of data.

Maintain data warehouse systems and provide production support.

Evaluate all data and perform various tests on data warehouse and ensure effective implementation.

Administer all data and ensure compliance with standards and policies. Maintain high quality of all deliverables and provide efficient guidance to all database architecture.

Job Qualifications :

10+ Years in DW / BI space in both designing the model and building analytics. At least executed two end-to-end implementations.

At least worked for one year in Azure SQL and ADF and for 2 year in building Tableau model / reports / dashboards

Experience in developing and optimizing stored procedures and functions using T-SQL for data migration and transformation

Master in Azure SQL stack architecture (SQL Server, SQL Warehouse and Azure Data factory)

Solid knowledge of data warehouse systems (star schema, snowflake schema, dimensions, measures, slowly changing dimensions, etc. is a must).

Administration experience of Tableau server is mandatory

Technical knowledge of python, Pentaho, or shell scripting is required

Ability to interact with business users to understand business requirements, document them, and provide an optimal solution.

Past experience in leading a technical team is highly desired.

Knowledge of other analytics platforms like Epiphnay, SAP BW, etc. is a plus.

Functional knowledge of common business processes like quote to cash, procure to pay, hire to retire, clickstream analysis, revenue, booking, billing, etc. is desirable.

Production support experience in investigating errors / exceptions and resolving the errors at the root level.

Extremely good verbal and written communication skills.

We’re doing work that matters. Help us solve what others can’t.

Reportar esta oferta
checkmark

Thank you for reporting this job!

Your feedback will help us improve the quality of our services.

Inscribirse
Mi Correo Electrónico
Al hacer clic en la opción "Continuar", doy mi consentimiento para que neuvoo procese mis datos de conformidad con lo establecido en su Política de privacidad . Puedo darme de baja o retirar mi autorización en cualquier momento.
Continuar
Formulario de postulación