Senior Analyst – SQL Development is responsible for understanding business requirements ,designing and developing database solutions for manageability, scalability and performance. He will work closely with business analysts, project manager, other development team members to build and deliver database solutions. The role also entails technical mentoring of other SQL Development team members.
Understand data model of the products within the insurance domain
Develop Conceptual, Logical and Physical Design of the database based on business requirements
Develop and test stored procedures, views, triggers and functions
Optimize performance stored procedures, views, triggers and functions
Develop and maintain SQL Server Integration Services (SSIS) packages for Extraction Transform and Loading (ETL) processes
Develop, maintain and enhance SSRS reports, queries and data exports
Perform detailed data analysis on data related defects
Provide extracts business users the data required for metrics and analysis
Create and maintain data models and documentation for all projects
Experience with Microsoft SQL Server Management Studio (SSMS), TSQL and Stored Procedures
Experience working with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
Experience in Data modeling principles and techniques
Experience in performance optimization of Stored Procedures and SQL Queries
4 or more years of experience as a Database Developer.
Design and develop Stored Procedures
Strong oral and written communication skills
Strong trouble shooting and problem-solving skills
Strong analytical skills
Should be a quick learner.
Experience with Insurance and/or Financial Reporting systems will be an added advantage