Report Developer - SeniorLanceSoft Inc • Toronto, ON, CA

Report Developer - Senior

LanceSoft Inc • Toronto, ON, CA

10 days ago

Job type

Full-time

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

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]

#J-18808-Ljbffr

Create a job alert for this search

Report Developer Senior • Toronto, ON, CA

Similar jobs

AR Specialist

Vaco by Highspring • Aurora, ON, CA

Full-time

Invoicing : Mostly automatic invoicing some manual invoicing.For manual, Go into portal create invoice in excel, convert into pdf, ensure it aligns, account for any shortages or overages, then send ...Show more

Last updated: 2 days ago • Promoted

Director, Digital Reporting & Compliance (Remote)

Clearsulting • Toronto C6A, ON, Canada

Remote

Full-time

A global consulting firm is looking for a Director in Toronto to lead teams in digital reporting and compliance.The ideal candidate will possess deep technical knowledge of Workiva and demonstrate ...Show more

Last updated: 23 hours ago • Promoted

Senior Actuarial Associate - IFRS17 Valuation and Reporting

Manulife Financial • Toronto C6A, ON, Canada

Remote

Full-time

A leading financial services provider is seeking a Senior Actuarial Associate based in Toronto to support financial reporting under IFRS17 and develop core actuarial valuation skills.This role invo...Show more

Last updated: 15 days ago • Promoted

Senior Financial Analyst - External Reporting

Xplore Inc. • Markham, ON, Canada

Full-time

Canada’s fibre, 5G and satellite broadband company for rural living.Xplore is committed to the relentless pursuit of an improved broadband experience for all Canadians. Xplore is building a world-cl...Show more

Last updated: 1 day ago • Promoted

Senior IFRS Valuation & Reporting Actuary (US IFRS17)

Manulife • Toronto C6A, ON, Canada

Remote

Full-time

A leading financial services company is seeking a Senior Actuarial Associate for the US IFRS Valuation Reporting team in Toronto. This role involves calculating reserves, analyzing capital drivers, ...Show more

Last updated: 15 days ago • Promoted

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: 2 days ago

Senior Solutions Consultant

Achievers Corp. • Toronto C6A, ON, Canada

Remote

Full-time

Achievers offers more than just a thank you program.Our employee recognition and rewards software inspires employees to recognize everyone, every day, everywhere. Join our team of A-players who brin...Show more

Last updated: 30+ days ago • Promoted

Associate, Client Reporting

CI Financial Corp. • Toronto, ON, Canada

Full-time

At CI, we see a great place to work as one that is a safe place for everyone to have a voice, where people are empowered to take ownership over meaningful work, where there is an opportunity to gro...Show more

Last updated: 30+ days ago • Promoted

Report Developer Senior

Cleo Consulting • Toronto, ON, Canada

Full-time

Quick Apply

Assignment : RQ10375 - Report Developer - Senior Job Title : Report Developer Senior Requisition (SS) : RQ10375< / ...Show more

Last updated: 23 hours ago

Report Developer - Senior

Connvertex Technologies Inc. • Toronto, ON, Canada

Full-time

Quick Apply

Experience and Skill Set Requirements Create Power BI report(s), data models Undertake special assignments / sub-projects as assigned ...Show more

Last updated: 15 days ago

Senior Portfolio Management Solutions Lead

Canadian Imperial Bank of Commerce • Toronto C6A, ON, Canada

Remote

Full-time

A leading financial institution in Toronto is seeking a Senior Consultant in Wealth Management Technology to lead functional design and development of application systems.This role requires at leas...Show more

Last updated: 13 days ago • Promoted

Senior Finance & Special Projects - Analytics & Reporting

Accelerate Her Future® • Toronto C6A, ON, Canada

Full-time +1

A prominent financial institution is looking for a Senior Manager, Finance & Special Projects for a 12-month contract in Toronto, Ontario. The role involves financial reporting, planning, and analys...Show more

Last updated: 8 days ago • Promoted

Senior Credit Risk Analytics & Reporting Manager

BMO Financial Group • Toronto C6A, ON, Canada

Full-time

Un groupe financier international basé à Toronto recherche un expert en gestion du risque pour soutenir l'exécution de solutions de production de rapports efficaces. Le candidat idéal aura entre cin...Show more

Last updated: 23 days ago • Promoted

Enterprise Portfolio Architect

Enbridge • Toronto C6A, ON, Canada

Remote

Full-time

Own the future of our technology portfolio.As our Portfolio Architect, you will align solution designs and technology roadmaps with what the business cares about most. Partnering with Business and T...Show more

Last updated: 23 hours ago • Promoted

Senior Siebel CRM Developer & Reporting Specialist

emergiTEL Inc. • Toronto C6A, ON, Canada

Full-time

A leading IT solutions provider in Toronto is seeking a Software Developer to focus on Oracle Siebel CRM development and testing. The role involves translating specifications into tested application...Show more

Last updated: 23 hours ago • Promoted

Senior Payroll Product Lead — Remote, High-Impact Growth

Wave HQ • Toronto C6A, ON, Canada

Remote

Full-time

A financial services innovator is seeking a Senior Product Manager for its Payroll business in Toronto.The role requires owning the product vision and strategy, leading cross-functional teams, and ...Show more

Last updated: 6 days ago • Promoted

Senior Solutions Consultant

Achievers • Toronto C6A, ON, Canada

Full-time +1

Achievers offers more than just a thank you program.Our employee recognition and rewards software inspires employees to recognize everyone, every day, everywhere. With nearly 4 million global users,...Show more

Last updated: 12 days ago • Promoted

RQ10375 - Report Developer - Senior

Maarut Inc • East York, ON, Canada

Full-time

The Common Cluster Solutions Branch focuses on services that support both ministries and all branches within the cluster. CCS also provides business intelligence, data analysis and other KPI reporti...Show more

Last updated: 2 hours ago • Promoted • New!