BI Engineer

2 months ago

Old Toronto, Canada ProViso Staffing Full time
Story Behind the Need:

The IT Risk Data & Analytics Team plays a critical role in the management of technology-related risks by identifying, collecting, and reporting on IT Governance and Risk related data, utilizing modern analysis techniques and data visualization tools.
Work on changes to Software Currency Dashboard and RCMP tool to support US EOL reporting. A lot of ETL involved, extraction and data load, using SQL Server as the main database, using SSIS, Power BI. 80% of time will be spent on SQL, creating data models, database code, stored procedures, etc., and the other 20% will be front-end development in Power BI; possible to have some Business Analyst work as well in terms of translating requirements if they have that skill.

Candidate Value Proposition:

The successful candidate will have the opportunity to work on a high visibility US EOL reporting project, exposure to software currency concepts which is a highly desired skill set across banking currently, exposure to IT governance and risk, at a top 5 Canadian Bank.

Typical Day in Role:

The BI Engineer is responsible for the full life cycle development, implementation, production support, and performance tuning of the Data Warehouse, Data Marts, and Business Intelligence Reporting environments, and support the integration of those systems with other applications.
They design and implement reporting and analytical solutions, including both the design of table structures and the processes used to populate those structures with data from internal and external sources.
The data they provide helps business teams drive improvement in key business metrics, customer experience, and business results.

Some of the key accountabilities include:
  • Lead small to medium sized BI projects including collecting and documenting user requirements; translating user requirements to visual prototypes, and solution and data architecture documentation; development of data ingestion solution and data visualizations in the form of dashboards, spreadsheet extracts, and reports; planning and execution of unit and user testing, using testing and UAT environments and testing datasets;
  • Build end-to-end BI solutions utilizing a variety of industry tools, author report specifications from documented requirements or through discussion with end users, develop Data ETL (Extract, Transform and Load) scripts as required to acquire or transpose data from other systems or databases into report databases and maintain databases as required to support reporting and reporting environments;
  • Translate raw data into insights by quickly grasping the concepts in a dataset or database; understanding relationships in the data; running complex SQL queries to summarize or transform data; using statistical analysis to find data quality issues;
  • Provide day-to-day support of production BI applications that support IT&S executives on the strategy planning and decision-making process; conduct ETL, SQL and DB performance tuning, troubleshooting, support, and capacity estimation to ensure the highest data quality standards with the business and technical SMEs.
Candidate Requirements/Must Have Skills:
  • 10+ years of experience working on BI projects with the Microsoft BI stack (SQL Server, SSIS, SSAS, SSRS, SSMS)
  • 10+ years’ experience in SQL
  • 10+ years’ experience with database modeling and BI / Data warehousing concepts / OLAP – to demonstrate best approaches to design models
  • 5+ years of experience working with data visualization tools like Power BI (preferred) or Tableau
  • Experience working with Agile methods and tools: Git, Jira, Confluence, etc.
Nice-To-Have Skills:
  • Experience with IT Governance concepts; COBIT or ITIL certification; IT & Cyber Security concepts
  • Experience with data ingestion automation tools and technologies, i.e., automated data ingestion using Python scripts and frameworks or VBA and Excel spreadsheets
  • Experience with open-source data integration platforms like Airflow, NiFi, Prefect
  • Experience storing, manipulating, and integrating NoSQL data to BI reporting
  • Experience from FI/Banking
Soft Skills Required:

Good communications skills.

Education:
  • Bachelors in technical field like computer science (nice to have)
  • COBIT or ITIL certifications (nice to have)
  • Microsoft SQL certification (nice to have)
Best VS. Average Candidate:

Strong in database modelling, SQL, and Power BI; Ideal is strong with all the must-haves and the first nice-to-have of IT governance (IT management, ITSM experience, IT governance to be able to communicate between stakeholders more easily). Can initiate work, is more proactive.

Candidate Review & Selection:

2 rounds – MS Teams Video Interviews – expected to be able to share screen:
1st with HM – 30 minutes – standard behavioral going through experience
2nd with HM and potentially 1 more from team – 1 hour – technical interview – HM will share a case live in interview and expected to solution live by sharing screen.

Job Details

Job ID: 12513

Contract Duration: 6 months

Location: Toronto

#J-18808-Ljbffr

  • BI Engineer

    2 months ago

    Old Toronto, Canada Live Assets Full time

    IT Jobs in Canada Job Description Live Assets | IT Staffing Solutions is hiring a BI Engineer to join our client, a leading Veterinary Provider. Key Responsibilities Develop, implement, and manage ETL processes to integrate data from multiple internal and external sources into efficiently modeled datasets. Build and maintain data pipelines, leveraging the...

  • BI Engineer >

    3 months ago

    Old Toronto, Canada Badal Full time

    About Badal.io/Badal by TELUS Badal by TELUS Business is a rapidly growing GCP (Google Cloud Platform) consulting company based out of Toronto, acquired earlier this year by TELUS Communications. We work with GCP’s top customers (banking, telco, energy, retail, etc.) to help them with Cloud Transformation, Security, Analytics, ML, and Data Governance....

  • Senior BI Server Engineer

    1 week ago

    Toronto, Ontario, Canada Astra North Infoteck Inc. Full time

    About Astra North Infoteck Inc.Astra North Infoteck Inc. is a leading provider of innovative solutions in the field of Business Intelligence (BI). We are seeking a highly skilled Senior BI Server Engineer to join our team and contribute to the development and implementation of cutting-edge BI solutions.

  • Senior Power BI Engineer

    4 weeks ago

    Toronto, Ontario, Canada Lyons Consulting Group Full time

    Job Title: Senior Power BI EngineerJob Summary:Capgemini Canada is seeking an experienced Senior Power BI Engineer to join our team. As a Senior Power BI Engineer, you will be responsible for designing and implementing complex data models, performing tuning and optimization of Power BI reports and SQL queries, and working directly with business teams to...

  • Senior Power BI Developer

    2 weeks ago

    Old Toronto, Canada Cognizant Full time

    Job Description:This role is responsible for administering, supporting, monitoring, and tuning the Power BI reporting environment. Key responsibilities include designing, extending, and enhancing Power BI data models, developing new cubes, and optimizing cube performance by fine-tuning measures, aggregations, partitions, and processing strategies....

  • BI Engineer

    1 month ago

    Old Toronto, Ontario, Canada Badal Full time

    About Badal by TELUSBadal by TELUS Business is a rapidly growing GCP consulting company based in Toronto, acquired by TELUS Communications earlier this year. We work with top GCP customers to help them with Cloud Transformation, Security, Analytics, Machine Learning, and Data Governance.Why Choose Badal by TELUS?You get the best of both worlds: the agility...

  • Senior Power BI Engineer

    2 months ago

    Toronto, Canada Capgemini Full time

    Senior Power BI Engineer-076498 Description Job Location: Toronto Job Description:  Capgemini is looking to hire a Power BI Engineer to join our team.  Key Responsibilities: Build multi-dimensional data models Perform tuning and optimization of Power BI reports and SQL queries Work directly with business teams, designing Cloud...

  • Data Analyst and Data Scientist

    1 week ago

    Old Toronto, Canada Live Assets Full time

    Bi-Engineer Position in Veterinary HealthcareCompany Overview:Live Assets | IT Staffing Solutions collaborates with a leading Veterinary Provider to deliver innovative healthcare solutions. We seek a skilled Bi-Engineer to join our client's team.Estimated Salary Range: $90,000 - $120,000 per annumLocated in Canada, this role offers an exceptional opportunity...

  • Senior Power BI Engineer

    2 months ago

    Toronto, Canada Lyons Consulting Group Full time

    Job Description Senior Power BI Engineer- Description JOB DESCRIPTION: Capgemini Canada is hiring an Azure Data Engineer KEY RESPONSIBILITIES: Build multi-dimensional data models Perform tuning and optimization of Power BI reports and SQL queries Work directly with business teams, designing Cloud solutions. Transform business...

  • Azure BI Data Engineer

    4 weeks ago

    Old Toronto, Canada Mastech Inc. Full time

    Mastech Digital is an IT Staffing and Digital Transformation Services company providing digital and mainstream technology staff as well as Digital Transformation Services for all American Corporations. We are currently seeking an Azure Synapse Data Engineer for our client in the Consulting domain. This is a Contract position, and the client is looking for...

  • Senior Power BI Developer

    1 month ago

    Old Toronto, Canada Cognizant Full time

    Senior Power BI Developer At Cognizant, our global community sets us apart—an energetic, collaborative and inclusive workplace where everyone can thrive. And with projects at the forefront of innovation, you can build a varied, rewarding career and draw inspiration from dedicated colleagues and leaders. Cognizant is right where you belong. What you will do...

  • Power BI Developer

    1 week ago

    Toronto, Ontario, Canada Lyons Consulting Group Full time

    Job DescriptionSenior Power BI EngineerAbout the RoleWe are seeking an experienced Senior Power BI Engineer to join our team at Lyons Consulting Group. As a key member of our data engineering team, you will be responsible for designing and implementing complex data models, optimizing Power BI reports and SQL queries, and working closely with business...

  • BI Developer

    4 weeks ago

    Old Toronto, Canada ProViso Staffing Full time

    Responsibilities : • Design, engineer, deploy, and support actionable PowerBI dashboards/apps that are part of the Workforce Identity and Access Management organization. Design must be visually friendly, easy to navigate and inspire action by the user(s).• Design multi-dimension data models leveraging data in many formats (sql, xml, xlsx, csv, sharepoint...

  • Power Bi

    5 months ago

    Toronto, Canada Virtusa Full time

    About Virtusa: Virtusa Corporation is a global provider of Digital Business Transformation, Digital Engineering, and Information Technology (IT) outsourcing services that accelerate our clients’ journey to their Digital Future. Virtusa serves Global 2000 companies in Banking, Financial Services, Insurance, Healthcare, Telecommunications, Media,...

  • Power BI Senior Consultant

    4 weeks ago

    Old Toronto, Canada Capgemini Full time

    Job Description - Power BI Senior Consultant (077251)Power BI Senior Consultant - 077251BI Senior Consultant/Data Analyst - External Hire - Helton CostaJD: Understand clients’ business needs and goals. Design, develop, and maintain Power BI dashboards and reports. Extract, transform, and load data from various sources into Power BI. Strong understanding...

  • Power BI Senior Consultant

    4 weeks ago

    Old Toronto, Canada Capgemini Full time

    Job Description - Power BI Senior Consultant (077251) Power BI Senior Consultant - 077251 BI Senior Consultant/Data Analyst - External Hire - Helton Costa JD: Understand clients’ business needs and goals. Design, develop, and maintain Power BI dashboards and reports. Extract, transform, and load data from various sources into Power BI. Strong...

  • Business Intelligence

    6 months ago

    Toronto, Canada CareRx Corporation Full time

    **About CareRx** CareRx is Canada’s leading provider of specialty pharmacy services to seniors. We serve more than 92,000 residents in over 1,500 seniors and other communities (long-term care homes, retirement homes, assisted living facilities, and group homes). We are a national organization with a large network of pharmacy fulfillment centres that...

  • Senior Power BI Developer

    1 month ago

    Toronto, Ontario, Canada Capgemini Full time

    Job Title: Senior Power BI EngineerJob Description:Capgemini is seeking a highly skilled Power BI Engineer to design and implement cloud-based solutions for our clients.Key Responsibilities:Design and develop complex data models using Power BIOptimize Power BI reports and SQL queries for improved performanceCollaborate with business teams to develop...

  • BI Developer

    6 months ago

    Toronto, Canada Guidepoint Full time

    : Guidepoint's Engineering team thrives on problem-solving and creating happier users. As Guidepoint works to achieve its mission of making individuals, businesses, and the world smarter through personalized knowledge-sharing solutions, the engineering team is taking on challenges to improve our internal CRM system and create new products to optimize the...

  • Sr. Software Engineer in Test

    3 weeks ago

    Old Toronto, Canada AutoTrader.ca Full time

    TRADER Corporation is a trusted Canadian leader in online media, dealer and lender services. The company is comprised of AutoTrader.ca, AutoSync and Dealertrack Canada. AutoTrader.ca (AutoHebdo.net in Quebec) offers the largest inventory of new cars and used cars in Canada, receiving over 25 million monthly visits to its marketplace. With over 3,500...