Business Intelligence Analyst - Intermediate

Description : Project Name :

Data Strategy & Various Data Projects

Scope :

The Data and Content Management Division uses a one-government approach to information and privacy governance, decision-making, and service delivery across the Government of Alberta (GoA) balanced with individual client needs. This facilitates enhanced data access, collaboration, reduction in data duplication, and innovation to ensure effective and efficient services across the government to provide better services to Albertans.

The Data Centre of Excellence requires a resource to support the design and development of analytical data products & services to enable the GoA to better leverage its data assets support implementation of the GoA Data Strategy. Working within a team, this position plays a fundamental role in ensuring high-quality data analysis, data modeling, development of data visualizations and development of evidence for use across departments and with external stakeholders. This role will enact the pillars of the Data Strategy by using data to benefit Albertans.

The successful candidate will be a Business Intelligence Analyst with a diverse range of analytical skills and experience in working in multi-faceted roles. The role may have aspects of any or all the following : data analysis, data modelling, statistical analysis, data governance, data science, data quality, advising, business analysis, data product design and delivery.

Duties :

Provides hands-on business intelligence support on the strategic data initiatives that are being undertaken as part of the Data Strategy. A critical responsibility is to translate data into actionable business insights that support strategic decisions by creating dashboards, reports and business KPIs. Services and project deliverables should evolve as the work progresses, in response to emerging user and business needs, as well as design and technical opportunities. Works with Manager Analytics Capability Centre to :

Deliver business intelligence capabilities to support internal and external client needs

Develop data products based on various data sets

Analyze data and prepare results

Gather and document client requirements

Design and develop data products

Capture business and technical metadata for data products

Perform data analysis, data quality audits / reviews, statistical analysis and data mining

Develop and share data models and products

Develop baseline and ongoing outcomes, key results, metrics, and other indicators.

Apply skills to provide insights, support decision-making and facilitate strategic business planning

Integrate both quantitative and qualitative data to create business insights

Design and create dashboards and custom reporting with various data sources and inputs

Escalate issues and risks, as appropriate

Work within a multi-vendor / staff environment

Equipment Requirements :

Resource will require own equipment

Resource must provide their own computer and related equipment. The computer's operating system must be a modern version of Windows or MacOS that is compatible with Azure Virtual Desktop (AVD) and related software for remote access. Windows is preferred due to better compatibility. AVD / remote-related software will be installed on the resource's computer.

In the event that the Contractor s resources are directed to work remotely, the Contractor shall be responsible for providing all of its equipment, including computers, software, printers, supplies, desks and chairs. However, the Province shall ensure that the Contractor s resources have the necessary access and credentials to the Government of Alberta s system.

The fixed rate quoted must be inclusive of all overhead, office space and equipment, including supplies, administrative burden, mark-up and all other costs to perform the Services for the duration of the Contract.

Working Hours :

Standard Hours of work are 08 : 15 16 : 30 Alberta time, Monday through Friday excluding holidays observed by the Province

Work must be done from within Canada, due to network and data security issues.

It is anticipated the role will be 100% remote, however in the event of an onsite meeting, the GoA does not pay for travel to attend on-site meetings, nor any expenses related to relocation, commuting, housing / accommodation, food / drink.

Notes on Location :

This resource will work remotely.

Incumbency :

This is a net new role.

Background Check Required :

Standard Background Check :

The Supplier shall, prior to commencement of the Services, provide the Province, on its request and at no cost to the Province, with criminal record checks.

Mandatory Training Courses :

Once hired the resource will be required to complete all mandatory training which includes but not limited to Freedom of Information and Protection of Privacy Act and Security awareness training. There may also be some optional courses as well.

Anticipated Interviews Dates

will be held between October 23 to Oct 27.

Refer to the Job Posting attachments for the proposed form of contract applicable to this Contingent Resource Request

Scoring Methodology :

Financial / Pricing : 20%

Resource Qualifications : 20%

Interview Process : 60%

SUBMISSION MUST INCLUDE :

RESUME

ALL REQUIRED EXPERIENCE MUST BE DESCRIBED IN RESUME UNDER THE JOB / PROJECT WHERE EXPERIENCE WAS ATTAINED.

EACH JOB / PROJECT MUST CONTAIN THE TERM OF THE JOB / PROJECT IN THE FORMAT MMM / YYYY to MMM / YYYY.

RESOURCE REFERENCES

o Three references, for whom similar work has been performed, must be provided. The most recent reference should be listed first. Reference checks may or may not be completed to assist with scoring of the proposed resource.

Enable Skills-Based Hiring

No

• $(function(){ $(".qualPlaceHolder").each(function(){ if($(this).parents('#jsLegend').length != 1 || $(this).find('ul').length == 0) { var requested = $(this).attr("requested"); var presented = $(this).attr("presented"); var dynamicId = $(this).attr("id"); var text = $(this).attr("text"); var readOnly = ($(this).attr("edit") === 'true'); var flexibleScaleLevels = $(this).attr("flexibleScaleLevels"); var flexibleScaleLevelNames = $(this).attr("flexibleScaleLevelNames"); new FG.Qual({ element : $(this), readOnly : readOnly, requested : requested, presented : presented, dynamicId : dynamicId, text : text, flexibleScaleLevels : flexibleScaleLevels, flexibleScaleLevelNames : flexibleScaleLevelNames, }).initialize(); } }) });

Qualification

Additional Details

Qualification

Assessment

Must Have

Education

Yes / No - Bachelor degree in Computer Science or related field of study equivalencies will be...

Yes

Work Experience

Duration - Ability to translate business requirements into analytical solutions

5 years

Duration - Direct hands-on Experience in designing, developing, and optimizing advanced Power BI...

5 years

Duration - Direct hands-on experience with a comprehensive set of visualization techniques...

5 years

Duration - Experience developing complex measures, calculated columns

5 years

Duration - Experience in analyzing large complex datasets...

5 years

Duration - Experience in presenting and storytelling...

5 years

Duration - Experience understanding and developing requirements for analytical projects.

5 years

Nice to Have

Work Experience

Duration - Experience building data products in GOA Cloud Environment

2 years

Duration - Experience combining raw data from a variety of data sources within and across domains.

5 years

Duration - Experience dealing with clients and explaining complex data principles in a thoughtful...

5 years

Duration - Experience in SQL for data transformations querying...

3 years

Duration - Experience preparing visualizations, dashboards, and analytical models.

5 years

Duration- Experience working with large government datasets.

3 years