IT-Sr Systems Engineer

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