Report Developer
Spectraforce
Toronto, Ontario
a month ago
Job Description
Job Title: Report Developer
Duration: 8 Months
Location: Toronto, ON (Hybrid)
Must haves:
Demonstrated working knowledge of Power BI Desktop [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)
Responsibilities:
Provide planning, assessment, and development effort to complete the conversion of 100+ operational reports and dashboards from JasperReports to PowerBI
Work with Project manager and Business Areas to evaluate and modernize reports, where applicable
Migrate report functionality to Power BI Desktop or Power BI Report Builder based on Project Team assessment
Work with Project Team to complete all relevant and required documentation, such as knowledge transfer, and communication to support the completion of the project
Participate in reporting needs assessment to understand the functionality and design of the current operational reports in use
Perform assessment, and define approach in collaboration with project team and stakeholder to migrate operational reports to appropriate CDT solution standard reporting features or to a Power BI tool (i.e., Desktop or Report Builder)
Perform design and development activities to migrate operational reports to Power BI in alignment with OPS Standards and Guidelines (i.e., AODA, WCAG 2.0 Level AA)
Perform troubleshooting and apply corrective actions to resolve issues with migrated reports and dashboards discovered during pre-release testing
Skillset:
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.
Ability to provide analysis, developing and implementing approved new / re-engineered business process standards.
KT Transfer of Codes, Scripts, PowerBI Reports & Dashboards (PBIX Files) to Project Managers/Team Members.
Desired Skills:
Technical skills and expertise to design and develop in Jasper Report Tool.
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.
Knowledge of ETL tools, such as Azure Data Factory, Microsoft SSDT.
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $70.00/hr.
Duration: 8 Months
Location: Toronto, ON (Hybrid)
Must haves:
Demonstrated working knowledge of Power BI Desktop [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)
Responsibilities:
Provide planning, assessment, and development effort to complete the conversion of 100+ operational reports and dashboards from JasperReports to PowerBI
Work with Project manager and Business Areas to evaluate and modernize reports, where applicable
Migrate report functionality to Power BI Desktop or Power BI Report Builder based on Project Team assessment
Work with Project Team to complete all relevant and required documentation, such as knowledge transfer, and communication to support the completion of the project
Participate in reporting needs assessment to understand the functionality and design of the current operational reports in use
Perform assessment, and define approach in collaboration with project team and stakeholder to migrate operational reports to appropriate CDT solution standard reporting features or to a Power BI tool (i.e., Desktop or Report Builder)
Perform design and development activities to migrate operational reports to Power BI in alignment with OPS Standards and Guidelines (i.e., AODA, WCAG 2.0 Level AA)
Perform troubleshooting and apply corrective actions to resolve issues with migrated reports and dashboards discovered during pre-release testing
Skillset:
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.
Ability to provide analysis, developing and implementing approved new / re-engineered business process standards.
KT Transfer of Codes, Scripts, PowerBI Reports & Dashboards (PBIX Files) to Project Managers/Team Members.
Desired Skills:
Technical skills and expertise to design and develop in Jasper Report Tool.
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.
Knowledge of ETL tools, such as Azure Data Factory, Microsoft SSDT.
Applicant Notices & Disclaimers
- For information on benefits, equal opportunity employment, and location-specific applicant notices, click here
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $70.00/hr.