SSIS/SSRS/PowerBI Developer | Sunixa Solutions Inc.

MSBI Lead who has experience in developing enterprise ETL solutions and demonstrates expert-level knowledge in SQL Server

The successful candidate will be responsible for all phases of in-house application development and third-party package customization and implementation.

This includes business requirement analysis, program design, coding, testing, implementing and maintaining/supporting the systems.

8-10 years experience with ETL tools (SSIS) and Data Integration projects.

3-5 years experience with tools (SSRS/ PowerBI).

The task will include, but not be limited to:Writes advanced SQL including some query tuning experience designing and building complete ETL/SSIS processes moving and transforming data for ODS, Staging, and Data Warehousing.

System design and technical specification writing develop reports SSRSDevelop and execute Unit test cases.

Support user acceptance test.

Create application and data migration plans.

Prepare production release documentation.

System/User SupportRespond to production troubles and user inquiries or see potential issues and address them-hour support is required to respond to troubles during nightly processing, etc.

Occasional weekend work is required to participate in production support monthly rotation scheduleDocumentationMaintain required documentation, which includes system environment diagram, system specification/design document, test plan/test cases/test evaluation, operations manual, etc.