Business Intelligence Analyst / Developer

analystWe are looking for a BI Analyst with intermediate to advanced experience and skills across the BI spectrum to join our team to support and deliver various analytical dashboards/reports.

Responsibilities

• Gather and document requirements, problems, and opportunities for key reporting needs.
• Troubleshoot dashboard/report issues in a timely fashion and ensure high report/dashboard uptime.
• Assist BI Lead with development of reporting solutions within Power BI, and aid business teams in refining requirements.
• Perform QA and coordinate solution UAT with stakeholders.
• Collaborate with the IT Infrastructure, Software Development, and other cross functional teams to accurately capture related datasets for reporting.
• Write SQL queries and formulate DAX calculations to facilitate data analysis, data sourcing and report development.
• Adopt an Agile approach when executing projects from inception to completion
• Adhere to IT project management standards and procedures, tracking and documenting the various tasks accordingly.
• Accommodate evolving requirements, risks and issues while meeting targets within reasonable timelines.
• Partner with IT and business teams to execute data quality and cleansing exercises.
• Learn the functionality, operation and business process of internal software applications as it pertains to reporting objectives.
• Structure data models, visualize information, and publish analytical dashboards/reports.
• Design, develop and deploy ETL solutions to capture data for report/dashboard ingestion.
• Prepare and release report documentation to guide users through report/dashboard definitions and navigation.

Experience And Educational Requirements

• Understanding of cloud-based platforms (Azure, Snowflake, others) would be an asset
• Candidates for this role must have SQL querying, data analysis and Power BI report development experience.
• Post-secondary diploma or degree in Computer Science, Management Information Systems or a related field is preferred, however, a combination of professional certifications, recognized training and/or experience will be considered.
• Demonstrated experience with data science, statistical analysis or data mining and programming languages such as R, Python, MDX would be an asset.
• Minimum 5 years of experience as a Business Intelligence Analyst/Developer, Data Analyst or report developer.

Technical Requirements

• Minimum 5 years of experience working with the Microsoft BI stack, particularly SQL Server Integration Services (SSIS)
• Familiarity with project documentation and tracking. Exposure to tools such as Team Foundation Server, DevOps and SharePoint.
• 5+ years proven experience or recognized training in Power BI/ SSRS report development including data modelling. Experience in other industry standard tools will also be considered.
• Minimum 5 years in SQL querying and development spanning stored procedures, functions, views, temporary tables, cursors, linked servers, SQL server agent jobs.
• Proficiency formulating Data Analysis Expression (DAX) calculations.
• ETL experience covering package development, data lineage and auditing, loop containers, dynamic SQL, parameter/variable transmission, integration services catalog. Script tasks and extraction of data using APIs would be advantageous.
• SQL Server Analysis Services (SSAS) would be advantageous.
• 2+ years experience in Agile methodologies and experience in project-oriented working environments.

Non-Technical Requirements

• Experience working in a team-oriented, collaborative environment, as well as ability to work independently
• Strong analytical, problem-solving skills and attention to detail
• High performing and motivated individual who wants to make a difference
• Aptitude for delivering report/dashboard training to small groups
• Keen to grow one’s understanding of the various functions/operations of the business
• Business/service oriented, with the ability to create and maintain productive relationships.
• Effective organizational, time management and planning skills
• Strong communication skills
• Influence and engage all levels of stakeholders and support change

What We Offer

• A competitive salary that’s benchmarked to industry salary data
• Hybrid working arrangement
• Group RRSP with generous employer matching
• Fitness & Wellness Reimbursement
• Paid vacation time plus 6 personal days
• Health & Dental, Critical Illness, & Life Insurance Benefits
• Paid Training & Development opportunities