Business Intelligence Analyst

BUSINESS INTELLIGENCE ANALYST (Category Management)

Requisition #: R GOAPRDJP

Location: Edmonton, AB (Onsite, 5 days a week)

Engagement Type: Contract

Number of Resources required: 1

Rate (CAD): Up to $95.00 per hour / Commensurate with related experience and market competitiveness

Term: to with 6 month extension available (up to 18-month contract)

Hours per day: 7.25

Security Screening: Standard (Criminal Record Check)

Submission Deadline/Closing Date: December 10, :00 AM Mountain Time)

Tri-global Solutions Group Inc. is seeking one (1) Business Intelligence Analyst (Category Management) to join our talented Service Delivery team at Ministry of Service Alberta and Red Tape Reduction (Government of Alberta).

WORK MODEL: The successful contractor(s) will be working onsite at Oxbridge Place, Street NW, Edmonton, AB. Applicants must be authorized to work in Canada to apply (Canadian Citizen or Permanent Resident). Standard Hours of work are 08:15 - 16:30 with a 1 hour lunch break Alberta time, Monday through Friday excluding holidays.

Please review the project overview and requirements below. If you meet the requirements and are interested in submitting for this role, please reply to this job posting.

If you know other consultants who may be interested in this opportunity kindly share this job posting.

Thank you.

Tri-global Solutions Group Inc.

Website: https://tri-

PROJECT OVERVIEW / DESCRIPTION OF SERVICES

Project Area:

Category Management

Business Intelligence in Category Management supports evidence-based decision-making by transforming procurement and contract data into actionable insights. The role analyzes spend, supplier, and market information to identify enhance performance reporting, ensuring the unit has reliable, timely, and meaningful data intelligence.

Contribute as part of a team, responsible for delivering business intelligence capabilities to support internal and external department stakeholders' information needs.

Duties:

• Deliver work products based on various sets of data including (but not limited to) procurement, contracts, finance and market data.

• Work with a selection of technology products (such as SAP, Power BI, Alteryx) that must address the ever changing

technology and increasing appetite for information from internal and external department stakeholders.

• Must be able to work effectively with a team made up of in-house staff and contract resources.

• Analyze data and prepare information results.

• Gather and document requirements.

• Design and construct information products.

• Capture business and technical metadata for information products.

• Gather requirements for control processes including schedule management, status reporting, issues, risk, and change management at the program level.

• Produce deliverables within specified quality standards and timeline.

• Define and performing quality assurance on business intelligence deliverables.

• Respond to ad-hoc information inquiries.

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

• Escalate issues and risks, as appropriate.

• Work within a multi-vendor/staff environment.

MANDATORY REQUIREMENTS

• Post-Secondary degree, diploma or certificate in Computer Science or related field of study.

• Experience with articulating and translating technical language for non-technical customers both verbally and in writing. (4 years+)

• Experience with data concepts such as: Extract Transform Load (ETL), Operational Data Store (ODS), Online Transaction Processing (OLTP), etc. (4 years+)

• Experience with presenting data in queries, dashboards, and reports in a way that is easy to understand. (4 years+)

• Direct hands-on experience designing, developing, and optimizing advanced Power BI solutions that transform regulated and complex datasets into actionable insights for policy, operations and executive reporting. (4 years+)

• Experience in creating and implementing business intelligence requirements. (4 years+)

• Experience with dimensional modeling techniques. (4 years+)

• Experience working in a data warehouse/business intelligence or relevant data environment in either a development or support role. (4 years+)

DESIRABLE REQUIREMENTS

• Ability to collaborate and work with various stakeholders.

• Ability to interact and communicate professionally with a diverse group.

• Ability to think critically to select the most appropriate input data, modeling method, indicated variables, and techniques.

• Experience using Microsoft SQL. (4 years+)

• Experience with PowerBI, PowerView, Microsoft SQL Reporting, and Analytical Services. (4 years+)

• Experience with relational database modeling techniques. (4 years+)

NOT FOR YOU?

Check out our other opportunities at https://tri- or follow us on LinkedIn. We thank all candidates in advance. Only candidates selected for an interview will be contacted.

WHY WORK WITH TRI-GLOBAL?

• Empower positive change by enabling our clients to revolutionize innovation and technology, elevating them to a higher level of excellence and efficiency.

• Join an exceptional and committed team that redefines the landscape, forging a distinctive path towards success.

• Engage in stimulating and captivating projects that push boundaries and keep you constantly motivated.

Job Type: Full-time

Pay: Up to $95.00 per hour

Education:

• Bachelor's Degree (required)

Experience:

• using Microsoft SQL: 4 years (preferred)
• Applying relational database modeling techniques: 4 years (preferred)
• Using ETL, ODS, and OLTP data concepts: 6 years (required)
• Creating and implementing BI requirements: 6 years (required)
• Working in data warehouse or BI environments: 4 years (required)
• BI / Process Analysis: 6 years (required)
• Translating technical language for non-tech customers: 3 years (required)
• Presenting data in queries, dashboards, and reports: 3 years (required)
• public sector: 1 year (preferred)
• PowerBI, PowerView, MS SQL Reporting, Analytical Services: 4 years (preferred)
• Design and optimize advanced Power BI solutions: 4 years (required)
• Transform complex datasets into actionable insights: 4 years (required)
• collaborating & working with various stakeholders: 5 years (preferred)
• Applying dimensional modeling techniques: 4 years (required)

Work Location: In person