Business Intelligence Analyst - Intermediate

Cynet systems Inc; Alberta; On-site; CAD 80,000 - 100,000; Full time

Job summary

A technology solutions company in Alberta seeks a data analyst skilled in Power BI to design and implement business intelligence solutions. Ideal candidates will possess a post-secondary degree in Computer Science and have over four years' experience working with ETL, data presentation, and analytical tools. Responsibilities include data analysis, delivering reports, and collaborating with diverse stakeholders. This role offers great team dynamics in a multi-vendor environment.

Qualifications

• Post-secondary degree, diploma or certificate in Computer Science or related field.
• Experience articulating technical language for non-technical customers (4 years).
• Experience with ETL, ODS, OLTP data concepts (4 years).
• Experience presenting data in queries, dashboards, and reports (4 years).
• Hands-on experience designing advanced Power BI solutions (4 years).
• Creating and implementing business intelligence requirements (4 years).

Responsibilities

• Deliver work products based on various data sets.
• Work with technology products to address stakeholder needs.
• Analyze data and prepare information results.
• Gather and document requirements for control processes.
• Produce deliverables within quality standards and timelines.

Skills

Data analysis

Effective communication

Business intelligence

ETL concepts

Power BI expertise

Education

Post-Secondary degree in Computer Science

Tools

SAP

Power BI

Alteryx

Microsoft SQL

Job description

Job Description

• 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

Must Have

• Post-Secondary degree, diploma or certificate in Computer Science or related field of study. (Yes or No)
• 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)

Nice to Have

• Ability to collaborate and work with various stakeholders. (Yes or No)
• Ability to interact and communicate professionally with a diverse group. (Yes or No)
• Ability to think critically to select the most appropriate input data, modeling method, indicated variables, and techniques. (Yes or No)
• 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)