Skip to main contentA logo with &quat;the muse&quat; in dark blue text.

IT-Sr Systems Engineer

AT Cadence
Cadence

IT-Sr Systems Engineer

Noida, India

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.

Want more jobs like this?

Get Data and Analytics jobs in Noida, India delivered to your inbox every week.

By signing up, you agree to our Terms of Service & Privacy Policy.


Role: Data Warehouse Engineer

Location: India, San Jose, Austin, Cary

Must Haves:

  • 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

Preferred skills:

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

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

Qualifications:

  • 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.

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.

Client-provided location(s): Noida, Uttar Pradesh, India
Job ID: Cadence-R40149
Employment Type: Full Time

Perks and Benefits

  • Health and Wellness

    • Dental Insurance
    • Vision Insurance
    • Life Insurance
    • Short-Term Disability
    • Long-Term Disability
    • FSA
    • HSA With Employer Contribution
    • Fitness Subsidies
    • On-Site Gym
    • Mental Health Benefits
    • Virtual Fitness Classes
    • Health Insurance
  • Parental Benefits

    • Birth Parent or Maternity Leave
    • Non-Birth Parent or Paternity Leave
    • Fertility Benefits
    • Adoption Assistance Program
    • Family Support Resources
    • Adoption Leave
  • Work Flexibility

    • Flexible Work Hours
    • Hybrid Work Opportunities
  • Office Life and Perks

    • Casual Dress
    • On-Site Cafeteria
    • Holiday Events
  • Vacation and Time Off

    • Paid Vacation
    • Unlimited Paid Time Off
    • Paid Holidays
    • Personal/Sick Days
    • Leave of Absence
    • Volunteer Time Off
  • Financial and Retirement

    • 401(K) With Company Matching
    • Stock Purchase Program
    • Performance Bonus
    • Financial Counseling
  • Professional Development

    • Tuition Reimbursement
    • Promote From Within
    • Mentor Program
    • Access to Online Courses
    • Internship Program
    • Leadership Training Program