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.
