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).
• Minimum 7+ demonstrated experience in Microsoft specific software development and a number of years of practical experience (minimum 7+ years).
• Minimum 7+ demonstrated experience in Extract, Transform & Load and Extract, Load and Transforms software development and a number of years of practical experience
• Demonstrated experience in creating both Functional Design Documents (FDD) & Detailed Design Documents (DDD).
• Demonstrated experience with Oracle and Microsoft interfaces
If you are available, please send your resume to [email protected] OR refer someone interested.
Title: Business Intelligence Specialist – Senior
Period: 5 Months
Start Date – 2022-10-17
End Date: 2023-03-31
Working Hrs.: 7.25 Hrs. / day
Assignment Type: – Hybrid – Candidate is required to come to office – 3 days a week
7+ years in ETL tools such as Microsoft SSIS, and data warehousing, and
Azure Databricks, Python, Azure Data Lake
Azure Synapse, ADF pipelines
Ability to present technical requirements to the business
Nice to have – Oracle Golden Gate
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 and a number of years of practical experience (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 the pre-defined and adhoc 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