Intermediate Data Analyst with financial modeling experience to support data integrity pipeline and create visualizations using SQL queries & Power Bi (Ons

Our downtown Calgary client is looking for an Intermediate Data Analyst with financial modeling experience to support data integrity pipeline and create visualizations using SQL queries & Power Bi (Onsite; Calgary)

This role requires you to be onsite in office 4 days/week

Must Haves:

• 5+ years' experience as a Data Analyst
• Understanding of data analytics, ensuring data integrity and creating visualizations using queries and databases
• Experience with advanced excel usage (data modeling, Power Query development, complex financial models)
• Experience creating dashboards with Power Bi
• You will develop processes and visualizations to manage and validate data, ad hoc and/or complex reports and dashboards
• Experience with financial modeling and digital reporting tools (Excel, ERP systems, etc.).
• Experience with SQL queries

Responsibilities:

• Work with Finance to support the set up and closure of approved capital projects, facilitate accrual processing, conduct accuracy reviews against data sources and ensure monthly reporting at Portfolio and Finance determined levels, maintain and improve project tracking worksheets
• Work with the Portfolio Delivery Managers to provide needed project and portfolio financial reviews

Location:

4 days/week onsite in Downtown Calgary; 1 day WFH