NOTE: This position is currently listed as “Onsite”; however, the Assignment under this request will provisionally be “Hybrid”, working 7.25 hours per calendar day, sometime between 8:00-5:00 PM (excluding lunch breaks) Monday to Friday inclusive, unless otherwise identified. These conditions are subject to change as the OPS reflects on its current situation. During the duration of the assignment you will be under the discretion of the Hiring Manager’s requirements for the Project you are assigned to.
The VOR Master Service Agreement which expires on April 5, 2026, leaves some Contracts with funding unassigned for fiscal 2025-26. If the current statement of work expires March 31, 2026, the remaining funds can be used to exercise an option to extend the SOW beyond March 31, 2026 based on business case approvals. Such extensions will be allowable, only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions, covenants contained in the SOW.
- Provide planning, assessment, and development effort to meet workload demand of the BI reporting enablement activity, which support program areas within the Ministry of Attorney General.
- 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
Experience and Skill Set Requirements
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
Skills and Knowledge:
- 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.
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]
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]
Criteria Ratings
Criteria 1 Details:
- 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 Details:
- 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
Dynamic Work Place
Never a boring day
Go Crear!
Venus B
Senior Wordpress DeveloperLove it.
Quality is important, I've learnt to be a fast thinker.
Awesome People
Harry K
Junior Content StrategistFast paced
A constructively challenging environment. As General Manager, lots of exiting new experiences
Unique exposure
Kapil K
Business DevelopmentGreat Time
Very accommodating, relaxed but firm workplace
Love the learning experience
Jerry E
Project ManagerFlexibility
Ability to work at my pace but toward a deadline is a huge plus.
Working at crear is a lovely experience.
Atique M
Executive AssitantOrganic Growth
I have steadily grown at Crear.
Gaining knowledge on a daily basis
