Job Description

We have a new job opportunity and I think you may find it interesting.

If you are interested kindly send the following documents to by Wednesday, April 12 at 09:30 AM EST if that interests you and matches your profile.

Without mandatory documents, we cannot submit a candidate. * Updated Resume in word format (Mandatory)

• Skills Matrix and References (Mandatory)
• Expected hourly rate (Mandatory)

Job Title: RQ05393 - Business Intelligence Specialist - Senior

Client: Ministry of Solicitor General

Work Location: 21 College suite 300, Toronto, Ontario, Onsite

Estimated Start Date: 2023-05-29

Estimated End Date: 2023-11-24

#Business Days: 125.00

Extension: 125.00

Hours per day or Week: 7.25 hours per day

Security Level: CRJMC

Description:

Responsibilities:

• Supports Client\xe2\x80\x99s wide-ranging business information requirements, implementing and supporting business intelligence software solutions
• Develops and supports customized query applications which analyze key business data
• Develops and supports guided analysis and drill-down functionality, routine scheduling and notification of report generation, and effective implementation of \xe2\x80\x9copportunity\xe2\x80\x9d and \xe2\x80\x9ckey-trend\xe2\x80\x9d alerts.
• Provides Clients with approach options and tools for managing business-related data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives.

General Skills:

• Experience with analyzing data in source systems to identify data cleanliness issues (e.g. missing values, duplicate meanings, and invalid data)
• Experience with developing feedback processes to fix corrupt data in the source systems
• Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide-range of data repositories (relational and multi- dimensional data stores)
• Experience with developing, implementing and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts
• Experience with developing monitoring and error notification processes to ensure data is updated as designed
• Experience with developing automation extraction, cleansing and load scripts
• Experience generating research models and reports (scheduled and ad-hoc)
• Proven troubleshooting and analytical experience
• Experience in process decomposition/mapping and business process re-engineering and complex data models using UML.
• Experience in the use of development tools and business re-engineering software
• Experience in developing enterprise architecture deliverables (e.g. business, logical, and physical models) based on Enterprise Application Processes and Modeling methodology and guidelines

Desirable Skills:

• Knowledge and experience in developing data analysis applications
• Knowledge and understanding of Information Management principles, concepts, policies and practices
• Ability to provide expert advice in developing and integrating process and information models to enable identifying and eliminating redundant business processes
• Experience with developing monitoring and error notification processes to ensure data is updated as designed
• Hands on experience working with stakeholders to develop and document interface specifications design between Business Intelligence solutions and external applications
• Extensive experience with conceptual, logical and physical data modelling tools like Power Designer, and Visio.
• Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
• Supports Client\xe2\x80\x99s wide-ranging business information requirements, implementing and supporting business intelligence software solutions. Develops and supports customized query applications which analyze key business data. Also develops and supports guided analysis and drill-down functionality, routine scheduling and notification of report generation, and effective implementation of \xe2\x80\x9copportunity\xe2\x80\x9d and \xe2\x80\x9ckey-trend\xe2\x80\x9d alerts.
• Provides Clients with approach options and tools for managing business-related data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives.
• Experience with analyzing data in source systems to identify data cleanliness issues (e.g. missing values, duplicate meanings, and invalid data)
• Experience with developing feedback processes to fix corrupt data in the source systems
• Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide-range of data repositories (relational and multidimensional data stores)
• Experience with developing, implementing and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts
• Experience with developing monitoring and error notification processes to ensure data is updated as designed
• Experience with developing automation extraction, cleansing and load scripts
• Experience generating research models and reports (scheduled and ad-hoc)
• Proven troubleshooting and analytical experience
• Experience in process decomposition/mapping and business process re-engineering and complex data models using UML.
• Experience in the use of development tools and business re-engineering software
• Experience in developing enterprise architecture deliverables (e.g. business, logical, and physical models) based on Enterprise Application Processes and Modeling methodology and guidelines

Mandatory Requirements

• Create visually appealing and impactful Power BI report designs with report formatting, including report navigation
• Use Power Query to extract data from different data sources and choose a storage mode and connectivity type.
• Profile, clean, and load data into Power BI
• Design data models that are intuitive, high-performing, and simple to maintain
• Examine, sort and present data using Power BI in a cohesive manner
• Connect Premium Capacity Power BI reports to cloud & on-premise data sources

Deliverables:

• Create Power BI report(s), data models
• Undertake special assignments/sub-projects as assigned
• Conduct, assess, evaluate and document stakeholder interests and business needs
• Ensure alignment and adherence to IT processes and standards
• Support the testing team during system and UAT testing
• Participate in Knowledge transfer
• Skills and Knowledge: Proven experience as a Microsoft Power BI developer, building Business Intelligence reports and dashboards
• Demonstrated experience with M, DAX and Power Query
• Knowledge of Microsoft Azure ecosystem
• Proven experience with SQL Server and other database technologies
• Proven, demonstratable experience in data modeling and data visualization; working with different data schemas and BI implementation methodologies
• Knowledge of data analysis, data management
• Proven ability to partner with internal/external stakeholders and liaise with technical experts and non-technical colleagues
• Experience in understanding, capturing, and analyzing complex and sometimes competing business requirements to develop Power BI and Business Intelligence products
• Excellent verbal and written communication skills, interpersonal and facilitation skills
• Strong written, presentation and interpersonal communication skills with special attention to correct use of tense, grammar/spelling and terminology
• Demonstrated effective time management and organizational skills, including the ability to plan and prioritize workload, ensuring timelines are met and respond to demands of a dynamic environment

Experience and Skill Set Requirements

Criteria 1 \xe2\x80\x93 Technical Skills (70 Points)

• Proven work experience as a Power BI Report designer & developer with a focus on front-end design
• Proven, demonstratable experience in data modeling and data visualizations for Power BI; working with different data schemas and BI implementation methodologies
• Demonstrated experience with M, DAX and Power Query
• Knowledge of Microsoft Azure ecosystem and the Power Platform and Power BI Premium Capacity
• Proven experience with SQL Server and Power BI Datasets
• Knowledge of data analysis, data management
• Experience in understanding, capturing, and analyzing complex and sometimes competing business requirements to develop Power BI and Business Intelligence products
• Demonstrated experience with performance tuning in Power BI including measures, relationships and visuals
• Demonstrated experience with data sources for Power BI including DirectQuery, Import and appropriate considerations and limitations for their use
• Demonstrated experience with Power BI datasets
• Demonstrated experience with Power BI refresh

Criteria 2 \xe2\x80\x93 Documentation, Collaboration & Communication Skills (30 Points)

• Documentation, Collaboration & Communication Skills
• Ability to partner with internal/external stakeholders and liaise with technical experts and non-technical colleagues, regarding project deliverables
• Proven experience in developing documentation
• Demonstrated experience collaborating with Developers, Testers and Program Managers
• Proven experience in producing diagrams, videos, and other visual content
• Experience analyzing customer feedback and responding to it to improve the customer experience
• Experience in bringing clarity to complex business challenges and conflicting articulation of business issues through techniques that result in common understanding of the issues, as well as agreement on business process requirements vs technology requirements to solve the issues.
• Experience in understanding, capturing, and analyzing complex and sometimes competing business requirements to develop Business Intelligence products
• Excellent verbal and written communication skills, interpersonal and negotiation skills
• Facilitation skills, Interpersonal and consultative skills
• Stakeholder management skills. Demonstrated strong problem-solving and organizational skills
• A team player with a track record for meeting deadlines.
• Working knowledge and experience developing reports for use by a wide spectrum of stakeholders
• Strong written, presentation and interpersonal communication skills with special attention to correct use of tense, grammar/spelling and terminology.
• Demonstrated effective time management and organizational skills, including the ability to plan and prioritize workload, ensuring timelines are met and respond to demands of a dynamic environment

If you are interested to learn more about this opportunity or if not, please feel free to send over any names or forward this email to anyone who may be interested. Please check it out on our career site.

(Click above for Skill matrix and for more details)

Note:

This position is currently listed as "Onsite"; however, the Assignment under this request will provisionally be \xe2\x80\x9cHybrid\xe2\x80\x9d, 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\xe2\x80\x99s requirements for the Project you are assigned to.

The VOR Master Service Agreement which expires on April 5, 2024, leaves some Contracts with funding unassigned for fiscal 2024-25. If the current statement of work expires on March 31, 2024, the remaining funds can be used to exercise an option to extend the SOW be-yond March 31, 2024, based on business case approvals. Such extensions will be allowable, on-ly if the Master Service Agreement is extended beyond April 5, 2024, and be upon the same terms, conditions, and covenants contained in the SOW.

Powered by JazzHR

S M Software Solutions Inc