Business Intelligence Report Developer
Heart and Stroke Foundation
Ontario, Canada
2d ago

Life. We don’t want you to miss it.™That’s why Heart & Stroke leads the fight against heart disease and stroke. Powered by donors and volunteers, we fund life-

saving research and help Canadians lead healthier lives. Heart & Stroke is a health charity active in communities across the country.

We are sustained by the commitment and generosity of more than 100,000 volunteers and more than 1.4 million donors.

The opportunity

We are looking for a focused, analytical, fast learning, BI Report Developer to join Heart and Stroke’s Information Management team.

The Business Intelligence (BI) Report Developer will be responsible for interpreting business reporting requirements and will focus on designing customer data outputs leveraging Business Intelligence tools and data warehouse solution across a variety of Heart and Stroke data solutions.

The position will develop a range of data outputs from ad-hoc queries, data exports, through to building standard reports which provide flexible program reporting, and campaign analysis to guide insights and decision making.

The BI Report Developer will contribute to the strategic design and implementation of an Enterprise Business Intelligence solution.

The role will maintain and enhance the data warehouse database structures to collect relevant data based on business needs.

The position will normalize and centralize data from multiple sources and leverage the BI environment to streamline the processes for reporting and analysis.

The role will collaborate within a multi-site team setting with a variety of stakeholders, including internal business partners and external vendors and suppliers.

Key responsibilities

Translation and Integration

  • Translate high-level data requirements into solution architecture
  • Gather detailed user data requirements, interpret and translate into technical specification
  • Produce technical and functional documentation for appropriate audience
  • Identify and analyze data sources and prospective data points for solution delivery
  • Develop data services and frameworks to extract, load and transfer data into applications
  • Automate procedures to streamline data integrations across the organization
  • Report Development and Management

  • Design, develop and deploy new custom reports using MS Reporting Services or BI tools
  • Evaluate current reports, modify and consolidate where appropriate
  • Develop suitable outputs and formats such as extractions, reports, graphical, and pivots
  • Perform quality control from unit testing, to end to end and user acceptance
  • Ability to take raw data and provide summary analysis
  • Assists in development of standards to ensure data quality
  • Develop Reports Catalogue with end user perspective
  • Provide accurate estimate delivery time for solution to business partner
  • Data Warehouse Modifications and Maintenance

  • Support modification (cubes, dimensions, query objects) of BI data warehouse with external provider
  • Troubleshoot and support BI data warehouse environment with refresh procedures
  • Troubleshooting and performance optimization with external provider
  • Assess and propose solutions to enhance the architecture of the selected BI solution
  • Other

  • Contribute to definition and implementation of BI strategy and roadmap
  • Prepare and maintain appropriate documentation related to technical versioning and best practices knowledge
  • Deliver solutions according to Systems Development Life Cycle (SDLC)
  • Conduct specific training as needed.
  • Keep well-informed of trends and best practices in the BI industry to strengthen organizational and technical knowledge as it relates to enterprise information
  • Education

  • Bachelor degree or college diploma in computer science, information systems, business administration or related field
  • Work Experience and Skills

  • A minimum of 5+ years of information management experience supporting large database environments from a data analyst and reporting / metrics perspective
  • 3 5 years of MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS)
  • 3 5 years of SQL Server query development and stored procedures
  • 3 5 years of data warehousing and OLAP reporting
  • 3 5 years of gathering and documenting reporting requirements and translating needs into useful specifications, reports and processes
  • Expert knowledge and experience of MS SQL Server Reporting Services (SSRS)
  • Expert knowledge and experience of MS SQL Server Integration Services (SSIS)
  • Strong knowledge and working experience of MS SQL Server Analysis Services (SSAS)
  • Strong Knowledge of SQL Server, query development and stored procedures
  • Knowledge of data warehousing and OLAP reporting
  • Proven ability to identify and document reporting requirements and translate needs into useful reports and processes
  • Demonstrated analytical skills to review, synthesize information and produce analytical reports
  • Knowledge of and experience with Software Development Life Cycle
  • Excellent troubleshooting and problem solving skills
  • Excellent oral and written communications skills in English
  • Working knowledge of French is an asset
  • Project management skills and proven success with cross functional projects
  • Outstanding documentation skills
  • An exceptional customer service attitude
  • Results-driven and metrics focused with a passion for continuous improvement
  • Ability to partner with multi-disciplinary teams and vendors
  • Previous experience with Blackbaud applications (The Raisers Edge, CRM), Salesforce, and / or MS Dynamics Great Plains considered an asset
  • Working Conditions

  • Mainly office based.
  • Evening and weekend work as required
  • Working Conditions

    Add to favourites
    Remove from favourites
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Application form