Overview

Our client is a leading full-service global Contract Research Organization.
You will be an integral part of data & analytics team which helps the organization to monitor different aspects of the company and make data driven decisions.

Responsibilities:


- Meet with Subject Matter Experts, Product Managers and Application Developers to gather business requirements
- Design, model and develop across both Relational Databases and Data Warehouse and Synapse
- Develop SQL/Synapse views, stored procedures and tables, etc.
- Work with Data Lakes
- Maintain, monitor, upgrade and secure the SQL Server/Azure platform in partnership with an established vendor
- Develop ETL (extract, transform and load) processes to populate Data Marts and Warehouses
- Azure Data Factory
- Develop systems integrations across traditional databases and modern Cloud APIs
- Follow established Software Development Lifecycle (SDLC) activities and AGILE including Analysis, Design, Development, UAT, Pilot, Testing & lessons learned
- Troubleshoot data integrations/data feeds between systems
- Create reports and dashboards using technologies such as PowerBI and Microsoft Reporting Services
- Maintain required SDLC documentation, test scripts, training materials, etc.
- Document databases models, system processes, and maintenance procedures

Required Qualifications:


- 5+ years’ experience in SQL Server Database Management
- 5+ years’ experience in SQL Server Database Development and SQL scripting (T-SQL)
- 5+ years’ experience in ETL development using Microsoft SQL Server Integration Services (SSIS) or similar
- 5+ years’ experience developing reports and dashboards using PowerBI and Microsoft Reporting Services (SSRS)
- Good English