Business Intelligence Analyst / Developer - Jobs in Calgary

Job Description

Business Intelligence Analyst / Developer Boardwalk provides Canadians with a quality, comfortable, home living experience. We offer rental apartments and townhouses that come in a wide breadth of shapes, sizes and sets of amenities. We operate 33,000 units across Alberta, British Columbia, Ontario, Saskatchewan, and Quebec. We 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.
• Assist BI Lead with development of reporting solutions within Power BI, and aid business teams in refining requirements.
• 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.
• Collaborate with the IT Infrastructure, Software Development, and other cross functional teams to accurately capture related datasets for reporting.
• Learn the functionality, operation and business process of internal software applications as it pertains to reporting objectives.
• Adopt an Agile approach when executing projects from inception to completion
• Prepare and release report documentation to guide users through report/dashboard definitions and navigation.
• Design, develop and deploy ETL solutions to capture data for report/dashboard ingestion.
• Structure data models, visualize information, and publish analytical dashboards/reports.
• Write SQL queries and formulate DAX calculations to facilitate data analysis, data sourcing and report development.
• Perform QA and coordinate solution UAT with stakeholders.
• Troubleshoot dashboard/report issues in a timely fashion and ensure high report/dashboard uptime.
• Partner with IT and business teams to execute data quality and cleansing exercises.

Experience and Educational Requirements

• Minimum 5 years of experience as a Business Intelligence Analyst/Developer, Data Analyst or report developer.
• 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.
• Candidates for this role must have SQL querying, data analysis and Power BI report development experience.
• Understanding of cloud-based platforms (Azure, Snowflake, others) would be an asset

Technical Requirements

• Minimum 5 years in SQL querying and development spanning stored procedures, functions, views, temporary tables, cursors, linked servers, SQL server agent jobs.
• 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.
• Proficiency formulating Data Analysis Expression (DAX) calculations.
• 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.
• Familiarity with project documentation and tracking. Exposure to tools such as Team Foundation Server, DevOps and SharePoint.
• 2+ years experience in Agile methodologies and experience in project-oriented working environments.
• Minimum 5 years of experience working with the Microsoft BI stack, particularly SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS) would be advantageous.

Non-Technical Requirements

• High performing and motivated individual who wants to make a difference
• 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.
• Influence and engage all levels of stakeholders and support change
• Strong analytical, problem-solving skills and attention to detail
• Effective organizational, time management and planning skills
• Experience working in a team-oriented, collaborative environment, as well as ability to work independently
• Aptitude for delivering report/dashboard training to small groups

WHAT WE OFFER

• A competitive salary that’s benchmarked to industry salary data
• Hybrid working arrangement
• Healthamp; Dental, Critical Illness,amp; Life Insurance Benefits
• Group RRSP with generous employer matching
• Fitnessamp; Wellness Reimbursement

Boardwalk recognizes our Associates as our most valuable asset. We are proud to offer: •A safe and respectful work culture that attracts, supports, develops, and recognizes high-performing and innovative team members •A competitive salary that’s benchmarked to industry salary data •Hybrid working arrangement •Healthamp; Dental, Critical Illness,amp; Life Insurance Benefits •Group RRSP with generous employer matching •Fitnessamp; Wellness Reimbursement Interested applicants are invited to submit a cover letter and resume. We would like to thank you in advance for your application, however, only those candidates who are being considered will be contacted. Offers of employment will be contingent on satisfactory Security Background Checks, Reference Checks, and Post-offer/Pre-employment Physical Testing where applicable. ___________________________________________________________ Ready to shape the future of our communities Come work with us and learn where doing what you love means never working a day in your life! Deeply rooted in family spirit and humility, Boardwalk’s five core values of integrity, associates, teamwork, customer service and social responsibility are more than just words - they are a way of life. Coupled with our Golden Foundation of ‘treat others as you would like to be treated,’ ‘be good,’ ‘love community’ and ‘have fun,’ we believe in happiness and creating the most memorable experiences for both our Associates and Resident Members, continually looking for new and innovative ways to enhance and strengthen all our Boardwalk communities. We hope these values speak to you as they speak so meaningfully to us!