Senior Business Intelligence Specialist

2i Solutions, Inc; Toronto; Hybrid; CAD 80,000 - 120,000; Full time

Job summary

This innovative firm is seeking a Senior Business Intelligence Specialist for a dynamic 5-month contract in Toronto. In this hybrid role, you will leverage your extensive experience in Microsoft software development and ETL processes to create essential design documentation and provide ongoing support for Azure pipelines. You'll collaborate with clients and developers to refine business requirements and ensure successful knowledge transfer. Join a forward-thinking team where your expertise in tools like Microsoft SSIS, Azure Databricks, and Oracle will drive impactful data solutions. If you thrive in a collaborative environment and are ready to make a difference, this opportunity is perfect for you.

Qualifications

• 7+ years of experience in Microsoft software development and ETL.
• Experience in creating FDD and DDD documentation.

Responsibilities

• Develop and support ETL processes and Azure pipelines.
• Create and maintain design documentation and conduct knowledge transfer.

Skills

Microsoft specific software development

ETL software development

Creating Functional Design Documents (FDD)

Creating Detailed Design Documents (DDD)

Presenting technical requirements

Oracle Golden Gate

Tools

Microsoft SSIS

Azure Databricks

Azure Data Lake

Azure Synapse

ADF pipelines

SQL Server

Oracle

Azure DevOps

Job description

We have an excellent 5 months contract opportunity for a Senior Business Intelligence Specialist in Toronto.
It’s a hybrid role (3 days a week).

Must Haves:

1. Minimum 7+ demonstrated experience in Microsoft specific software development.
2. Minimum 7+ demonstrated experience in Extract, Transform & Load (ETL) software development.
3. Demonstrated experience in creating both Functional Design Documents (FDD) & Detailed Design Documents (DDD).
4. Demonstrated experience with Oracle and Microsoft interfaces.
5. 7+ years in ETL tools such as Microsoft SSIS, Azure Databricks, Python, Azure Data Lake, Azure Synapse, ADF pipelines, SQL Server, Oracle.
6. Ability to present technical requirements to the business.
7. Nice to have – Oracle Golden Gate.

Evaluation Criteria

Data Design and Development (25 points)

Demonstrated experience in Microsoft specific software development and a number of years of practical experience (minimum 7+ years). Proven experience in developing in Azure DevOps. Experience in application mapping to populate data vault and dimensional data mart schemas.

ETL experience (25 points)

Demonstrated experience in Extract, Transform & Load and Extract, Load and Transforms software development (minimum 7+ years). Experience in providing ongoing support on Azure pipeline/configuration and SSIS development. Experience building data ingesting and change data capture using Golden Gate. Assist in the development of predefined and ad hoc reports and meet the coding and accessibility requirements.

Design Documentation and Analysis Skills (20 points)

Demonstrated experience in creating both Functional Design Documents (FDD) & Detailed Design Documents (DDD). Experience in Fit-Gap analysis, system use case reviews, requirements reviews, coding exercises and reviews. Experience in the development and maintaining a plan to address contract deliverables, through the identification of significant milestones and expected results with weekly status reporting. Work with the Client & Developer(s) assigned to refine/confirm Business Requirements. Participate in defect fixing, testing support and development activities for ETL tool. Assist with defect fixing and testing support for Power BI reports. Analyze and document solution complexity and interdependencies by function including providing support for data validation.

Database Related (20 points)

Demonstrated experience with Oracle and Microsoft interfaces. Proficient in SQL and Azure DevOps. Implementing logical and physical data models.

Knowledge Transfer (10 points)

The Developer must have previous work experience in conducting Knowledge Transfer and training sessions, ensuring the resources will receive the required knowledge to support the system. The resource must develop learning activities using review-watch-do methodology & demonstrate the ability to prepare and present. Development of documentation and materials as part of a review and knowledge transfer to other members. Development and facilitation of classroom-based or virtual instructor demo-led sessions for Developers. Monitor identified milestones and submission of status reports to ensure Knowledge Transfer is fully completed.