ETL Manager - IT

Duties and Responsibilities :

- Design and deploy data table structures, forms, reports, and queries

- Query, analyze, and profile data from source to target to assess data integrity gaps

- Designs, develops, tests, and implements software programs, interfaces, reports and controls

- Manage the data model, data architecture, design & development for availability, upgrades, maintenance, performance and security of the Database infrastructure

- Work collaboratively with business unit partners to assess reporting needs and solutions, and implement a strategy for continuous improvement of the historical reporting, analytics and dashboards

- Analyze large customer data sets using a variety of database query and visualization tools.

- Deploy analytic models within the various self-service reporting systems and environments

- Develop, enhance and maintain large data sets processed through the MS BI stack.

- Design and develop complex ETL packages utilizing MS SSIS.

- Design and develop complex MS SSRS reports/Tableau

- Design and develop MS SSAS cubes.

Job Specification :

- Engineering/Science graduate with 10+ experience as Database Developer (SSAS,SSRS,SSIS)

- Expert knowledge of: MSSQL, No SQL Server,

- Experience extracting and manipulating data from relational databases with advanced SQL stored procedures.

- Experience working in any of the enterprise class BI, ETL and Reporting tools like SQL Server Reporting Services (SSRS)/Tableau/Power BI/SAS BI/SQL Server Integration Services (SSIS)/Informatica /Pentaho, etc.

- Experience extracting and manipulating data from relational databases with advanced SQL, stored procedures.

- Experience in coding advanced SQL queries, ETL automation, and stored procedures to support business inquiries

- Good Experience in Tableau Projects. Requirement gathering, data modeling scripting, developing and testing dashboards using Tableau