IT-Sr Systems Engineer

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

Data Warehouse Engineer

Cadence is looking for a hardworking, highly motivated Data warehouse engineer. This high-performing individual 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.

You will build Cadence enterprise data platform to support data-driven culture. You will 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.

• 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 min. 2 year in Azure SQL and ADF and for 3+ 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)
• Technical knowledge of python, Pentaho, or shell scripting is required

• Predictive modeling & analytics
• Ability to draw data insights
• Experience in prescriptive analytics (e.g. identifying the best course of action for a given condition)

• 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.
• Self-motivated, passionate for technology, and strong driver for results and continual improvement.

• 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 desired.
• Knowledge of other analytics platforms like Epiphany, 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.