Build, maintain and enhance the client data warehouse model.
Generate SQL code to extract, transform and load data from production data sources to the data warehouse.˙
Analyze data to identify business problems and provide solutions.˙
Analyze business requirements and functional specifications for technical design; develop detailed designs and build the data models and data programs for the projects˙.
Perform the data modelling for the OLAP (data warehouse/star schemas) system to bring in the data from the various data source such as MIS ,ERP.
Provide consultation services quarterly for quality assurance and system improvements.˙
Assist in the design of crisp, clean, efficient, and intuitive user interfaces.˙
Ability to write complex SQL queries and stored procedures to answer complicated business questions.˙