Manage end to end implementation of Datawarehouse and ETL on premise/cloud.
Expert skills and ability to work and provide guidance to team on Database Design/Modelling
In-depth skills to design, write and modify SSIS packages
In-depth skills on SQL/TSQL (performance tuning and troubleshooting)
Advanced knowledge on SSAS to develop cube and tabular models with MDX/DAX Query Skills
Advanced Skills in SSRS to Create reports, data and analysis based on business needs and available data elements.
Expert knowledge in developing parameterized, Chart, Graph, drill down reports using SSRS.
Intermediate Skills in Power BI with ability to create Dashboards for Data Analysis based on the business needs
Setup TFS CI/CD for SQL Automation and Automation via scripting tools such as PowerShell (in addition to T-SQL)
Performance tuning of DB Objects, ETL and SSRS Reports.
Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end.

Requirements

Bachelor’s/Master’s degree in Computer Science / Computer Engineering or equivalent experience
9+ years’ experience with SQL Server database systems including complex warehouse design, experience with designing ETL extracts from various data sources.
8+ years of SQL / TSQL development and fine-tuning experience.
4+ years Microsoft BI Stack (SSRS, SSIS, SSAS), including development of reports (RDLs, complex stored procedures, subscriptions, ETL packages using SSIS & T-SQL queries)
Effectively prioritise and execute tasks in a high-pressure environment
Must have experience of Agile development methodologies
Excellent oral and written communication skills.

Benefits

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Datawarehouse implementationETLDatabase DesignSSISSQLTSQLSSASMDXDAXSSRS

Soft Skills

problem resolutiontask prioritizationexecution under pressurecommunication

Certifications

Bachelor’s degreeMaster’s degree