Business Intelligence Specialist – Senior

4 weeks ago

Toronto, Ontario, Canada Arthur Grand Technologies Inc Full time
Company Description

Arthur Grand Technologies ) is in the business of providing staffing and technology consulting services. We have doubled our revenue year over year for the past 5 years. This speaks to the long-lasting relationship and customer satisfaction that we have built in this short span of time. Our company is managed by a team of professionals who worked for big 5 consulting firms for 20+ years.

We are a minority owned staff augmentation and technology consulting company

To keep our valued employees, we need to keep them engaged in challenging, interesting work, offer market-relevant benefits and provide continued opportunities for professional growth.


Job Description

Position:- Business Intelligence Specialist – Senior – (2 Open Positions)

Location: 315 Front St. West, Toronto, Ontario (Hybrid)

Hybrid - 3 days on site and 2 days remote

Duration: Long Term Contract

MUST HAVES:

Experience:

  • Experience of 7+ years of working with SQL Server, ADF and T-SQL Development (Must Have)
  • Experience working with building Databases, Data Warehouse and Data Mart and working with delta / incremental and full loads (Must Have)
  • Experience with any ETL tools such as SQL Server, ADF, Cloud tools (Must Have)
  • Experience working with MSSQL Sever on premise and within Azure Environment (Must Have)
  • Experience on Data modeling, and tools – e.g. SAP Power Designer,
  • Experience with snowflake and star schema model. Experience in designing data warehouse solutions using slowly changing dimensions.
  • Experience working with SQL Server SSIS and other ETL tools, solid knowledge and experience with SQL, other RDBMS (SQL Server, SSIS)
  • Understanding data warehouse architecture with a data vault, dimensional data and fact model.
  • Analyze, design, develop, test and document ETL programs from detailed and high-level specifications, and assist in troubleshooting.
  • Utilize SQL to perform tasks other than data transformation (DDL, complex queries)
  • Good knowledge of database performance optimization techniques
  • Ability to assist in the requirements analysis and subsequent developments
  • Ability to conduct unit tests and assist in test preparations to ensure data integrity
  • Work closely with Designers, Business Analysts and other Developers
  • Liaise with Project Managers, Quality Assurance Analysts and Business Intelligence Consultants
  • Design and implement technical enhancements of Data Warehouse as required.

Skills:

  • 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 (nice to have)
  • Databricks
  • Synapse (nice to have)
  • SQL Server
  • Oracle
  • Ability to present technical requirements to the business

Experience and Skill Set Requirements

Evaluation Criteria

Design Documentation and Analysis Skills (45 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.

Development, Database and ETL experience (45 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
  • 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 (an asset but not mandatory)
  • Assist in the development of the pre-defined and adhoc reports and meet the coding and accessibility requirements.
  • 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

Additional Information

All your information will be kept confidential according to EEO guidelines.

  • Senior Consultant, Business Intelligence

    3 weeks ago

    Toronto, ON, C6A, Ontario, Canada Carpedia International Full time

    Senior Consultant, Business IntelligenceCarpedia International is an operations-based management consulting firm where our teams have an opportunity to help client organizations achieve substantial gains in performance and profitability. We implement tangible and sustainable performance, process and people changes to better align our client-organizations. We...

  • Business Intelligence Analyst

    3 weeks ago

    Toronto, ON, C6A, Ontario, Canada Exchange Solutions Full time

    The Senior Business Intelligence Analyst is a role within the Analytics and Optimization team reporting to the Manager, Business Intelligence Analytics.The individual will be responsible for managing and delivering responsibilities related to reporting and analytics needs. The analyst will work closely with other teams and be responsible for analytics and...

  • Senior Technical Producer

    3 weeks ago

    Toronto, ON, C6A, Ontario, Canada People Can Fly Studio Full time

    Our central production team is looking for a Senior Technical Producer, Production Intelligence specializing in project management and data insights. You’ll be traversing multiple teams to create production intelligence systems that help grow our game team’s ability to deliver stunning games to market. This is a broad and horizontal role that will help...

  • Senior Business Analyst

    3 weeks ago

    Toronto, Ontario, Canada Ontario Health Full time

    At Ontario Health, we are committed to developing a strong organizational culture that connects and inspires all team members across the province. Our vision is that together, we will be a leader in health and wellness for all. Our mission is to connect the health system to drive improved and equitable health outcomes, experiences and value.How we work...

  • Senior Underwriting Specialist

    3 weeks ago

    Toronto, ON, C6A, Ontario, Canada The Mirillion Group Full time

    Position Overview:We are actively looking for an accomplished Senior Underwriting Specialist or Senior Underwriter to join this fantastic Insurance Firm with a great reputation in the market. The right candidate will be responsible for underwriting and profitably growing a portfolio of property business including P&C Package within the Ontario and Atlantic...

  • Business Development Specialist

    2 weeks ago

    Toronto, Ontario, Canada Holland Bloorview Kids Rehabilitation Hospital Full time

    Position title: Business Development Specialist - Commercialization and MRI Services Status: Temporary Full-time (1.0 FTE) Start date: July 2, 2024 Lab/Team: Commercialization Supervisor: Sharon Wong (Director, Commercialization) Program: Bloorview Research Institute Join us in building a world of possibility Holland Bloorview Kids Rehabilitation Hospital is...

  • Artificial Intelligence

    2 weeks ago

    Toronto, Ontario, Canada Forhyre Full time

    We are looking for an Artificial Intelligence (AI) Specialist: Forge the Next Chapter in AI AdvancementsKey Qualifications:Original Contributions: Your innovations in AI, especially within the ChatGPT technology sphere, should stand out. We value original research, novel algorithms, or methodologies that have significantly influenced the domain.Published...

  • Senior Sales Innovation Specialist f/m

    1 month ago

    Toronto, Ontario, Canada EightSix Network Inc Full time

    Our client, a leading packaging solutions provider, specializes in manufacturing high-quality shrink sleeve labels, folding cartons, stand-up pouch filling, labels, co-packing, and related services. With a commitment to innovation and quality, we are poised for growth and expansion into new sectors We are seeking a dynamic and results-driven Senior Sales...

  • Senior Social Sector Specialist

    3 weeks ago

    Toronto, ON, C6A, Ontario, Canada HelpSeeker Technologies Full time

    HelpSeeker is a technology company leading the way in developing innovative solutions to tackle social, municipal, and governmental challenges. Our mission is to empower non-profits, charities, and government bodies with cutting-edge technology to drive significant social impact. We are looking for a Senior Social Sector Specialist with a strong background...

  • Specialist Cyber Operations

    4 weeks ago

    Toronto, Ontario, Canada Air Canada Full time

    Job Description Description Being part of Air Canada is to become part of an iconic Canadian symbol, recently ranked the best Airline in North America. Let your career take flight by joining our diverse and vibrant team at the leading edge of passenger aviation.The Cyber Security Operations Centre Specialist will be working in a fast paced and innovative...

  • Senior Security Infrastructure Specialist

    4 weeks ago

    Toronto, Ontario, Canada Ombudsman Ontario Full time

    Effective January 1st, 2024 the salary range for this position is $1,852.71 to $2,314.51 per week in compliance with OPSEU Unified Bargaining Unit collective agreement provisions. The new rates, effective retroactive to January 1, 2024, were recently confirmed and dates for implementation of the new salary rates are still to be determined.The Ministry of...

  • Senior Business Partner

    3 weeks ago

    Toronto, Ontario, Canada Ontario Health Full time

    At Ontario Health, we are committed to developing a strong organizational culture that connects and inspires all team members across the province. Our vision is that together, we will be a leader in health and wellness for all. Our mission is to connect the health system to drive improved and equitable health outcomes, experiences and value.How we work...

  • Senior Business Analyst

    7 days ago

    Toronto, Ontario, Ontario, Canada First Derivative Full time

    We are hiring a Senior Business Analyst to join the team based in Toronto. The Senior Business Analyst will work with our clients in the Capital Markets space.You should be dynamic and nimble, a self-starter with experience working in an agile environment as well as leverage your excellent development, communication, and organizational skills.The role will...

  • Manager - Vulnerability & Threat Intelligence

    2 weeks ago

    Toronto, Ontario, Canada Canadian Tire Corporation Full time

    What you'll doThe Manager Vulnerability & Threat Intelligence within Cyber Threat Management (CTM) is a key member of a fast-paced team responsible for defending Canadian Tire's technology infrastructure and web assets against a complex cyber threat environment. Working independently and as part of a large Cybersecurity team, this position collaborates with...

  • Technical Specialist

    1 month ago

    Toronto, Ontario, Canada Vector Institute Full time

    JOB DESCRIPTIONTechnical Specialist POSITION SUMMARY The Vector Institute is an independent, not-for-profit Canadian corporation dedicated to AI research. We work across sectors to advance AI application, adoption, and commercialization across Canada. We are seeking a Technical Specialist to join our growing Business Computing team in Toronto. The...

  • EA Jobs – Senior Payroll Specialist

    4 weeks ago

    Toronto, Ontario, Canada Electronic Arts Full time

    Job Description:We are looking for a Senior Payroll Specialist to join our Canadian Payroll Team for a 6-month contract. The EA Canada Payroll team processes payroll for approximately 2800+ employees in 5 Provinces across Canada. You will have a flexible outlook and provide general administration coverage and overall support to the team during a planned...

  • Senior Manager, BI Consulting

    3 weeks ago

    Toronto, ON, C6A, Ontario, Canada Tiger Analytics Full time

    Tiger Analytics is an advanced analytics consulting firm. We are the trusted analytics partner for several Fortune 100 companies, enabling them to generate business value from data. Our consultants bring deep expertise in Data Science, Data Analytics, Data Engineering, Business Intelligence, Machine Learning and AI. Our business value and leadership have...

  • Senior Business Analyst

    7 days ago

    Toronto, Ontario, Ontario, Canada Imploy Full time

    Senior Business AnalystAs a Senior Business Analyst, you will play a pivotal role in bridging the gap between IT and the business using data analytics to assess processes, determine requirements, and deliver data-driven recommendations and reports to stakeholders. You will be responsible for analyzing business processes, identifying areas for improvement,...

  • Senior Business Analyst

    3 weeks ago

    Toronto, ON, C6A, Ontario, Canada Swoon Full time

    The Senior Business Analyst will be pivotal in developing a data hub and user-friendly portal for natural climate solutions derived from wetlands . Collaborating with key stakeholders like architects and government bodies, the analyst will define and document business requirements, user stories, and test plans.Must-Have Qualifications:University degree in...

  • Senior Business Financial Analyst

    7 days ago

    Toronto, Ontario, Ontario, Canada Robert Half Full time

    Our client, a very successful law firm, is currently seeking a Senior Financial Business Analyst (FP&A) for their finance team This is a hybrid role in the downtown core (2 days in office).Reporting to the Manager, Financial Analysis , the Senior Financial Business Analyst (FP&A) will provide financial reporting, forecasting, financial modeling, and...