Report Developer - SeniorLancesoft • Toronto, ON, CA

Report Developer - Senior

Lancesoft • Toronto, ON, CA

14 days ago

Job type

Full-time

Quick Apply

Job description

Report Developer - Senior

Duration : 240 Business days

Location : Toronto, ON (Onsite)

Scope

Work with a Project Manager and Business Areas to evaluate requirements, model / process data (I.E., Extract, Transform and Loading (ETL) & data warehousing) and develop reports / dashboards / data visualizations, utilizing Power BI Desktop, Power BI Report Builder (based on best fit to meet requirements).
Work with project team to ensure reports / dashboards / data visualizations are properly reviewed for quality assurance and compliance with the Web Content Accessibility Guidelines 2.1 Level AA.
Work with project team to complete all relevant and required documentation, such as knowledge transfer, and communication, to support the completion of the project

Assignment Deliverables

Participate in requirements gathering sessions to understand the functional and non-functional needs

Perform assessment, and define approach in collaboration with project team and stakeholder to successfully deliver effective BI Solutions

Perform data modelling and develop data processing pipelines to supply data repositories and warehouses using Microsoft Azure Data Factory, Data Bricks and IBM InfoSphere Data Stage.

Perform design and development activities to produce reports / dashboards / data visualizations within Power BI Desktop or Power BI Report Builder.

Perform troubleshooting and apply corrective actions to resolve issues with BI Solutions discovered during pre-release testing

Work with project team to provide relevant and required documentation to support migration activities and knowledge transfer

Participate in knowledge transfer activities

Experience and Skillset Requirements

Mandatory Requirements

Demonstrated working knowledge of Power BI Desktop, and Power BI Paginated Report Builder [At least 2 years of experience]

Demonstrated working knowledge of SQL query languages (T-SQL, PL-SQL) [At least 4 years of experience]

Demonstrated working knowledge of DAX programming [At least 2 years of experience]

Demonstrated work knowledge of ETL tools, such as Microsoft Azure Data Factory, Data Bricks and IBM InfoSphere DataStage, as well as data modelling methodologies. [At least 2 years experience]

Desired Skills and Experience

Experience working in a business intelligence team / environment, developing and delivering business intelligence and / or analytical reports and dashboards

Experience working with Power BI Desktop, and Power BI Report Builder to design and develop reports and dashboards and work with team members to explore options to redesign outdated reports

Experience writing and working with Microsoft Power BI DAX code to implement business logic within Power BI reports

Experience performing troubleshooting of SQL queries, business intelligence and analytical reports, as well as performing data analysis to complete data validation and ensure report accuracy.

Knowledge of Microsoft SQL Server, and Oracle databases

Knowledge of ETL tools, such as Azure Data Factory, Microsoft SSDT, IBM InfoSphere DataStage, etc.

Resumes Evaluation / Criteria :

Criteria 1 : Technical Knowledge - 50 Points

Experience / demonstrated ability writing Transact-SQL (T-SQL) queries (at least 4 years of experience)

Experience / demonstrated ability working with Power BI Desktop, and Power BI Report Builder to design and develop reports and dashboards (at least 2 years of experience)

Experience / demonstrated ability writing DAX code, perform data modelling and implement functionality within Power BI reports and dashboards (at least 2 years of experience)

Experience / demonstrated ability using ETL tools, such as Microsoft Azure Data Factory, Data Bricks and IBM InfoSphere DataStage, as well as data modelling methodologies. [At least 2 years experience]

Criteria 2 : Analytical and Problem-Solving Skills - 30 Points

Experience / demonstrated ability to perform technical troubleshooting, specifically within a business intelligence environment / team or against reports, dashboards, and database queries such as Transact SQL (T-SQL)

Experience / demonstrated ability to analyze data to resolve data quality issues and perform report validation

Demonstrated experience working within a team environment to troubleshoot and resolve technical problems

Criteria 3 : Communication Skills - 20 Points

Oral and written communication skills, Interpersonal and consultative skills, Facilitation skills

Demonstrated experience working in a team environment, contributing to team meetings on work progress, communicating risks and issues, providing results from work assessments, and explaining technical tasks to non-technical team members

Experience preparing documentation

MUST HAVES

Demonstrated working knowledge of Power BI Desktop, and Power BI Paginated Report Builder [At least 2 years of experience]

Demonstrated working knowledge of SQL query languages (T-SQL, PL-SQL) [At least 4 years of experience]

Demonstrated working knowledge of DAX programming [At least 2 years of experience]

Demonstrated work knowledge of ETL tools, such as Microsoft Azure Data Factory, Data Bricks and IBM InfoSphere DataStage, as well as data modelling methodologies. [At least 2 years experience]

Create a job alert for this search

Senior Developer • Toronto, ON, CA

Similar jobs

Workday PATT Architect - Focus on WD

Focus on WD • markham, on, ca

Full-time

PLEASE NOTE YOU MUST HAVE VALID WORKDAY CERTIFICATIONS (IMPLEMENTER) TO APPLY FOR THE ROLE BELOW : .We are hiring a Senior Manager to lead Workday Payroll, Time Tracking and Absence delivery across c...Show more

Last updated: 1 day ago • Promoted

Middleware Specialist - newmarket

Sophus IT Solutions • newmarket, on, ca

Full-time

Role : Middleware Integration Specialist.Location-Montreal, CA (look for local profiles only).The ideal candidate must be an expert in Python, deeply comfortable in Linux environments, and proficien...Show more

Last updated: 9 hours ago • Promoted • New!

Report Developer 10189-1311

Foilcon • Toronto, Ontario, Canada

Full-time

Quick Apply

HM Note : This onsite contract role is in office every day at the manager's discretion.Candidate resumes must include first and last name, email and telephone contact information.Candidate can work ...Show more

Last updated: 13 days ago

Senior Data Analyst, Client Reporting

Dialogue • Toronto, Ontario, Canada, M5H 2G4

Full-time

Dialogue is the #1 virtual care provider in Canada.Integrated Health Platform🅫, we provide exceptional online health and wellness programs (primary care, mental health, iCBT, EAP, and wellness) to...Show more

Last updated: 19 hours ago • New!

Senior Process Analyst - Artech L.L.C.

Artech L.L.C. • richmond hill, on, ca

Full-time

Title : Process Management Specialist / Process Engineer.Location : Toronto, ON (Hybrid role).Support Process Engineering workstreams for both projects. This is NOT a Business Analyst role.Process docu...Show more

Last updated: 10 hours ago • Promoted • New!

Senior Developer (Java, GenAI) - Iris Software Inc.

Iris Software Inc. • richmond hill, on, ca

Full-time

Iris Software is looking to hire a Sr.Developer (Java, GenAI) for one of our direct banking clients in downtown Toronto.Kindly let me know if you are interested and send me your resume.Location : To...Show more

Last updated: 5 hours ago • Promoted • New!

Senior Developer - Remote

GTreasury • Toronto, Canada

Remote

Full-time

Employer Industry : Treasury and Risk Management Solutions.Why Consider this Job Opportunity : .Competitive pay up to $X an hour - Opportunity for career advancement and growth within the organization...Show more

Last updated: 1 day ago • Promoted

Senior Project Manager - WongDoody

WongDoody • newmarket, on, ca

Full-time +1

Project Manager as part of our growing Project Management team.The immediate expectation is to lead a high-profile project for an automotive OEM primary dot com website. This is an end-to-end initia...Show more

Last updated: 10 hours ago • Promoted • New!

Project Manager - 2 Roles

Collabera • richmond hill, on, ca

Full-time

Need profiles with prior banking clients experience.Interactive Services portfolio.Project Manager contract positions.These roles are perfect for proactive professionals who thrive on tracking prog...Show more

Last updated: 5 hours ago • Promoted • New!

Remote Sap Datasphere & Reporting Developer (Canada) - C$120,000 - C$160,000 A Year - Remote

Technitask • Toronto, Canada, CA

Remote

Full-time

Develop data models and ETL tools in SAP Datasphere, collaborating with clients.Show more

Last updated: 30+ days ago • Promoted

Senior Liquidity Risk & Reporting Analyst

Virtusa • Toronto, Canada

Full-time

A leading technology services company is seeking a Liquidity BSA in Toronto, Ontario.This role involves analyzing liquidity management needs, documenting system specifications, and collaborating wi...Show more

Last updated: 1 day ago • Promoted

Risk Data Management Analyst

Infotree Global Solutions • newmarket, on, ca

Full-time

Job Title : Model Governance Specialist.RISK Independent Review & Control (RISK IRC) is a special unit within the RISK organization and reports directly to the Group Chief Risk Officer.The independe...Show more

Last updated: 10 hours ago • Promoted • New!

Senior Estimator ICI - newmarket

Hays • newmarket, on, ca

Full-time +1

Senior Estimator – ICI Construction.We are supporting a well‑respected ICI contractor in Brampton that is seeking a Senior Estimator to join its team due to both a recent vacancy and continued grow...Show more

Last updated: 9 hours ago • Promoted • New!

Indirect Tax Manager / Senior Manager

Services Conseils Jafferson inc. • markham, on, ca

Full-time

This position is based in Montreal with one of our clients, a recognised leader in accounting and consulting services in Canada. They have also been recognised as one of Montreal's Top Employers for...Show more

Last updated: 10 hours ago • Promoted • New!

RQ08581 - Report Developer - Senior

Rubicon Path • Toronto, Canada

Full-time

About the job RQ08581 - Report Developer - Senior Responsibilities Provide specialized skills for developing data access queries and analyses. Works in conjunction with data analysts for developing ...Show more

Last updated: 1 day ago • Promoted

HRIS Reporting & Analytics Lead

Compass Group • toronto, on, ca

Full-time

In accordance with provincial legislation and our commitment to transparent hiring practices, the compensation range for this position is provided. Final compensation will be determined based on qua...Show more

Last updated: 1 day ago • Promoted

Senior Digital Analytics Analyst - newmarket

Maverick InnoGarage • newmarket, on, ca

Full-time

AdTech or MarTech environments.Strong experience with Adobe Analytics, including implementation, configuration, and reporting. Proficiency in Adobe Experience Platform (AEP) and AEP Launch (Tags) fo...Show more

Last updated: 10 hours ago • Promoted • New!

Freelance Reviewer - TransPerfect

TransPerfect • richmond hill, on, ca

Full-time

TransPerfect is currently looking for qualified freelance linguists (reviewers) with Technical, Construction, Engineering, Manufacturing expertise interested in long-term collaboration and willing ...Show more

Last updated: 10 days ago • Promoted