Position Description:

We are looking for a well-qualified Lead MSBI Developer to design, analyze, develop, troubleshoot and maintain SQL stored procedures, databases and related utilities within the software environment. Candidate will be accountable for creating SQL scripts and SSIS packages that improve and optimize database transactions within the business model. In addition, candidate will be responsible for ensuring high data integrity as well as optimizing database performance within the environment.

Mandatory Skills & Competencies: 

• 6+ years experience with SQL Server Integration Services (SSIS).
• SQL Development experience in environments that may include a combination of SQL Server, Oracle, MySQL and Postgres environments.
• Microsoft SQL Server Integration Services (SSIS) 2014 and above
• Microsoft SQL Server 2014 and above
• Source Control (GIT or TFS)
• Azure SQL Data Warehouse (nice to have)
• Microsoft SQL Server Analysis Services (SSAS) / Azure Analysis Services
• Experience in processing various source and destination types Flat Files SQL databases Web APIs (SOAP, REST)
• Experience in complex ETL transformations, including using C# for SSIS scripting
• Experience in third party SSIS tools
• Knowledge of Agile development methodology