Senior Business Intelligence Specialist

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

Job summary

A leading company in Toronto is seeking a Senior Business Intelligence Specialist for a 5-month hybrid contract. The role requires extensive experience in Microsoft software development and ETL processes. Candidates should have a solid background in SQL, Azure tools, and the ability to produce technical documentation. This opportunity offers a platform to showcase your skills in a dynamic environment, working closely with client teams to deliver key data management solutions.

Qualifications

• Minimum 7+ years experience in Microsoft software and ETL development.
• Experience in creating Functional Design Documents (FDD) & Detailed Design Documents (DDD).
• Ability to present technical requirements to the business.

Responsibilities

• Support ETL tool development; assist with defect fixing and testing.
• Conduct Knowledge Transfer and training sessions for team members.
• Develop documentation as part of Knowledge Transfer activities.

Skills

Microsoft software development

Extract, Transform & Load (ETL)

Oracle interfaces

SQL

Azure DevOps

Python

Data validation

Tools

Microsoft SSIS

Azure Databricks

Azure Data Lake

Azure Synapse

ADF pipelines

SQL Server

Oracle

Oracle Golden Gate

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 :

• Minimum 7+ demonstrated experience in Microsoft specific software development.
• Minimum 7+ demonstrated experience in Extract, Transform & Load (ETL) software development.
• Demonstrated experience in creating both Functional Design Documents (FDD) & Detailed Design Documents (DDD).
• Demonstrated experience with Oracle and Microsoft interfaces.
• 7+ years in ETL tools such as Microsoft SSIS, Azure Databricks, Python, Azure Data Lake, Azure Synapse, ADF pipelines, SQL Server, Oracle.
• Ability to present technical requirements to the business.
• 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.

J-18808-Ljbffr

Create a job alert for this search

Senior Intelligence • Toronto, ON, Canada