Role: Data Warehouse Engineer
Location: San Jose, Austin, Cary (Initial REMOTE)
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
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.