Data Warehouse Developer

Responsibilities:

• Understands complex business problems and develops logical and physical database models to support design of enterprise systems which support and facilitate the transfer of data from operational to analytical systems.
• Uses SQL Server Relational Database Engine and the T-SQL query language to create new database objects as needed, including Primarily Tables, Views, and Stored Procedures.
• Understands and leverages best-practice techniques to ensure proper provision for storage and performance requirements to ensure database systems remain highly available and efficient.
• Performs ad-hoc analysis using T-SQL query language within the database systems using a process oriented approach.
• Investigates existing database objects to identify and remediate performance issues.
• Performs exercise to migrate data points from legacy environment to the new SQL environment to streamline the process/ data.
• Understands the new trend in Business Intelligence/ Data analytics and participates in discussion with supervisor/ peers on critical thinking to take current BI platform to it.
• Understands the concept of Data lakes and experience with migrating legacy system to Data Lake.

Key Skills:

• SQL.
• Business intelligence.
• Data analysis.
• ETL .
• Analyzing and reporting techniques.