Duties and Responsibilities:

Coordinates with different counterparts regarding data sources and other related reports. Structure, manage and extract data from multiple applications Creates, design and maintain data model and databases.  Completes other duties and projects as required.  Analyzes technical requirements of the reports that he is creating. Automates processes such as data extraction, transformation and loading. Creates report structure and definition using BI tools.  Manage the data warehouse that the team is maintaining. Creates and maintain ETL’s for data extraction. Manage projects from the design phase involving user and manager input to the deployment phase as well as the continued maintenance phase. Prepares functional system design documents, such as flowcharts and dataflow diagrams. Conducts functional unit and integration testing prior to validate accuracy and consistency. Evaluates test results prior to seeking approval of the project owners. Develops training material with any new policies and changes made to either database, applications, ETLs and processes.  Devise and assist end-user training for all new releases and upgrades of applications. 

Requirements:

Advanced level on:SQL primarily T-SQL SQL Server Reporting Services (SSRS)PowerBIIntermediate level on:Microsoft Azure services (Data Factory, Pipelines, Data Lake, DevOps)SQL Server Integration Services (SSIS)Knowledgeable on:Oracle SQL ServiceNowWindows CommandSoftware Development Life Cycle (SDLC)Technical writing