Business Intelligence Specialist

1 week ago


Toronto, Ontario, Canada Cleo Consulting Full time

Assignment:
RQ Business Intelligence Specialist - Senior


Start Date:


End Date:


Office Location: 315 Front St. West

Organization:
Children, Youth & Social Services Cluster


Ministry:
Ministry of Children, Community and Social Services


# Business Days:
plus Extension # of Days: 202.00


Title:
Business Intelligence Specialist - ETL Tester


Must haves:

  • 7+ years in ETL tools such as Microsoft SSIS, stored procedures (Must Have)
-
2+ Azure Data Lake and Data Warehouse, and building Azure Data Factory pipelines (Must Have):


  • 2+ years Python (Must Have)

Description

Skills

Please note this role is part of a Hybrid Work Arrangement and resource(s) will be required to work at a minimum of 3 days per week at the Office Location.

Experience:

  • Design & develop the test plan & test cases for Data warehouse, Datamart & Data Lake projects
  • Experience in testing data validation scenarios and Data ingestion, pipelines, and transformation processes (e.g.,ETL).
  • Experience in writing complex SQL queries, ability to determine the types of testing that must be conducted (i.e, data validation, regression, etc.), including evaluating the testability of requirements and create a comprehensive test plan that supports the business and technological solutions being delivered.
  • An understanding of Azure Data Factory Pipelines & Databricks Notes testing, Cloud data/Data Lake testing
  • Identification and Test Data Preparation Techniques.
  • Review and understand Business Requirements/Source-ToTarget mapping.
  • Ability to transform complex Business logic into SQL or PL/SQL queries
  • Ability to run, read from, debug batch processes
  • Thorough knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle etc

Evaluation Criteria

Design Documentation and Analysis Skills (45%)

  • 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.

Development, Database and ETL experience (45%)

  • Demonstrated experience in test case life cycle development and a number of years of practical experience (minimum 7+ years)
  • Proven experience in developing in test plan, test cases for ETL projects
  • Experience in testing data vault and dimensional data mart schemas
  • Demonstrated experience in testing Extract, Transform & Load and development and a number of years of practical experience (minimum 7+ years)
  • Experience in providing ongoing support on defect retest and regression testing
  • Experience in testing data ingesting and change data capture using Golden Gate (an asset but not mandatory)
  • Assist in the development of the predefined and adhoc reports testing
  • Demonstrated experience with Oracle and Microsoft interfaces
  • Proficient in SQL and Azure DevOps
  • Implementing logical and physical data models

Knowledge Transfer (10%)

  • The ETL tester 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 reviewwatchdo 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


  • Toronto, Ontario, Canada Altus Group Full time

    Job Category:SoftwareOpportunity Awaits at Altus GroupThe OpportunityThis is your chance to develop, build, and grow business intelligence at a global tech company. In this role, you will work closely with teams across the organization, translating their business needs into BI and Analytics solutions. As our next BI Specialist, you will deliver insights,...


  • Toronto, Ontario, Canada Net2Source Inc. Full time

    Job Title:Business Intelligence Specialist Duration: 8 Months Location: Toronto, Ontario, Canada (3 days onsite and 2 days WFH)MUST HAVES:Experience with a wide range of methods, tools, and techniques for business analysis such as, but not limited to business functional modeling, business even


  • Toronto, Ontario, Canada Teacup Tech Systems Inc Full time

    RQ Business Intelligence Specialist - Senior Toronto, ON, Canada Job Openings RQ Business Intelligence Specialist - Senior About the job RQ Business Intelligence Specialist - Senior Experience in business intelligence software development and a number of years of practical experience (minimum 3+ years) Experience in providing with recommend best option...


  • Toronto, Ontario, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled Business Intelligence Specialist - Intermediate for one of our clients.Position: Business Intelligence Specialist - IntermediateLocation: Toronto, Ontario (Hybrid)Duration: Long Term ContractMust Haves: Power BI Experience Microsoft Dynamics 5 years of experienceExperience and...


  • Toronto, Ontario, Canada TD Bank Full time

    TD DescriptionStay current and competitive. Carve out a career for yourself. Grow with us.Department OverviewWhat does TD Data & Analytics stand for? For starters, we believe in visionary leadership and insights. We believe in using every resource at our disposal to better serve our clients, and this includes our vast data. Key objectives include driving...


  • Toronto, Ontario, Canada Drake International Full time

    Title: Senior Business Intelligence SpecialistLocation: Toronto, ON, Canada (Hybrid)Type: Long Term ContractIntroduction:Join a rock-solid organization as our client's next Business Intelligence Specialist and sit at the center of projects that drives decisions. You'll help one of Canada's most trusted government organizations work on the latest project, and...


  • Toronto, Ontario, Canada V-Tech Solutions Full time

    Job Title:Bi Specialist**Location:Toronto, Ontario (Hybrid)**Duration: 6 Months ContractOntario Tourism Marketing Partnership Corporation (operating as Destination Ontario) would like to engage the People Placement Service to procure a resource that can help our President & CEO's Office in establishing and implementing standardized measurement and reporting...


  • Toronto, Ontario, Canada TD Bank Full time

    Business Intelligence Specialist - Cybersecurity Technology & Risk:BRJob Category - Primary Enterprise Data & AnalyticsWork Location Front Street West CorporateEmployment Type RegularCity TorontoTime Type Full TimeProvince/State OntarioHours 37.5Workplace Model HybridPay DetailsDepartment Overview The Enterprise Protect Reporting Factory (EPRF) resides in...


  • Toronto, Ontario, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled Business Intelligence Specialist - Senior for one of our clients.Position: Business Intelligence Specialist - SeniorLocation: Toronto, ON (Hybrid)Duration: Long Term ContractMust haves: Data Warehouse/Lakehouse Concepts: Strong understanding of data warehousing principles,...


  • Toronto, Ontario, Canada Dawn InfoTek Inc. Full time

    Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients.Responsibilities: Assist with gathering business and information requirements. Provide...


  • Toronto, Ontario, Canada Lancesoft Full time

    Must Haves: Create a cohesive performance measurement and reporting framework through consultations with stakeholders across DO business areas. Design, refine, and validate key performance indicators (KPIs) to accurately reflect business objectives. Create and deploy user-friendly reporting tools such as dashboards tailored to the diverse needs of DO's...


  • Toronto, Ontario, Canada Canada Life Assurance Company Full time

    Cyber Threat Intelligence Specialist**Description: - Permanent Full TimeGreat-West Lifeco Inc. (Lifeco) is an international financial service holding company with interests in life insurance, health insurance, retirement and investment services, asset management, and reinsurance businesses. Lifeco has operations in Canada, the United States, Europe and Asia...


  • Toronto, Ontario, Canada Munich Re Full time

    Our team at Munich Re is responsible for rethinking and reshaping the way we look at our core business and we are seeking a Business Intelligence Specialist to join our team. As a member of our Data and BI team you will be working on data delivery, transformation, and BI analytics for Munich Re Life and Health by working collaboratively across a variety...


  • Toronto, Ontario, Canada Accentio Group Full time

    Head of Business Intelligence Our client is one of the fastest growing Canadian tech companies. As a Head of Business Intelligence, you should have a vision for how BI helps move the company faster and make better business decisions. You will lead business/functional analysts, programmer/analysts, database/data warehouse administrators, and data...


  • Toronto, Ontario, Canada WCG Services Full time

    Program:Cooperate**:Location:Canada wide**:Who we're looking for:Business Intelligence & Reporting ManagerLike WCG, you believe in the power of work to transform lives. As the Business Intelligence & Reporting Manager, you're part of a team that makes a difference by establishing and maintaining systems which increase the efficiency and effectiveness of our...


  • Toronto, Ontario, Canada Randstad Full time

    This is a contract position for a Business Intelligence Specialist - Power BI Developer for our public sector client.Work location: Downtown Toronto Duration: Twelve Months 7.25 hours/day This is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of...


  • Toronto, Ontario, Canada Toronto Parking Authority Full time

    POSITION SUMMARY Reporting to the Senior Specialist, Operations Business Intelligence, the Analyst, Business Intelligence and Reporting is integral to TPA's success as a data informed organization. The Analyst works closely with all departments to maintain, implement, and drive a business intelligence and revenue management culture within the organization,...


  • Toronto, Ontario, Canada Toronto Parking Authority Full time

    POSITION SUMMARY Reporting to the Senior Specialist, Operations Business Intelligence, the Analyst, Business Intelligence and Reporting is integral to TPA's success as a data informed organization. The Analyst works closely with all departments to maintain, implement, and drive a business intelligence and revenue management culture within the organization,...


  • Toronto, Ontario, Canada Altis Technology Full time

    Senior Business Intelligence Developer – MicroStrategy Project: Insight Med EchoBackground: BI reporting changes to incorporate Med Echo data into Insight. We are seeking a skilled Senior Developer to join our team and contribute to this project.Responsibilities:Design, develop, test, and deploy MicroStrategy-based visualizations, documents, dossiers, and...


  • Toronto, Ontario, Canada FLEETCOR Full time

    What We NeedFLEETCOR is currently looking to hire a Business Intelligence Analyst (FP&A) within our Corpay division. This position falls under our Corpay Cross Border line of business and is located in 212 King Street West, Toronto ON. We are thrilled to announce we are setting up a key new Function to focus on Analytics and Strategy within our Data,...