Business Intelligence Analyst

3 weeks ago


Greater Sudbury, Canada City of Greater Sudbury Full time

**Section**: Performance and Change
**Division**: Data, Analytics, and Change
**Department**: Office of the Chief Administrative Officer
**Initial Reporting Location**: Tom Davies Square

**Job Status**: Permanent Position

**Affiliation**: Inside Unit
**Hours of Work**: 70 hours bi-weekly
**Shift Work Required**: No
**Range of Pay**: IWIT Group 4 - $45.53 to $55.91 per hour (Subject to Review)

**The start date will follow the selection process.**

This position is eligible to work remotely on a full-time basis (Note: Must be able to report to a City of Greater Sudbury work location on short notice).

**Characteristic Duties**: Under the general supervision of the Manager of Performance and Change.

1. Coordinate the development and maintenance of a corporate Business Intelligence (BI) program, related software and related technology including but not limited to Power BI, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS).
2. Conduct the analysis and review of the City’s business systems to produce useful and meaningful reporting models that are based on user requirements and corporate objectives.
3. Lead, coordinate and facilitate multiple Information Technology (IT) and corporate reporting initiatives which will further the visibility and usefulness of City of Greater Sudbury BI portfolio.
4. Lead assigned project management phases of IT projects (e.g., delivery of required products for each project, monitoring time and cost for agreed tolerances, guiding project teams, recommending, and updating project plans with actual forecasts, reporting to respective stakeholders).
5. Define, document, and disseminate the City’s standards for analytics, data collection, presentation, and quality assurance.
6. Design, build and maintain data marts and models and/or cubes using the technologies supported by the city.
7. Maintain awareness of current and emerging modeling and analytics techniques, Extract Load and Transform tools, and BI tools.
8. Coach and support business unit Subject Matter Experts (SME) in the proper business analysis and analytics of their data.
9. Grow a culture of analytic self-service through training, documentation, and workshops.
10. Provide technical guidance to Information Technology staff for related BI technology and processes.
11. Escalate unresolved issues and recommend project budgets and expenditures to the Manager of Performance and Change.
12. Respond to user requests for assistance. Investigate the issues and analyze possible solutions.
13. Assist in all aspects of planning and development with respect to information technology.
14. Develop and maintain a thorough working knowledge of CGS’s Safety Manual and the applicable Provincial Legislation listed therein.
15. Perform other related duties as required.

**Qualifications**:

- University Degree in Computer Science, Data Science, Analytics, or related discipline.
- Additional courses in business intelligence systems, tools, and analytics.
- Over two and one-half (2½) years up to and including five (5) years of diversified experience in a senior system capacity providing analytics solutions.
- Experience planning and developing business intelligence systems, data modelling and master data management.
- Sound knowledge of systems analysis procedures and analytics and understanding of information technology hardware and software capabilities and uses.
- Experience with business intelligence tools and reporting software such as Power BI and SQL Server Reporting Services (SSRS).
- Working knowledge of several computer languages including SQL, Multidimensional Expressions (MDX), and Data Analysis Expressions (DAX).
- Familiar with Extract-Transform-Load (ETL) tools and relational database management systems (RDBMS).
- Satisfactory keyboarding skills.
- Effective communication skills.
- Satisfactory health, attendance, and former employment history.
- Must be physically capable of operating a vehicle safely, possess a valid driver’s licence, have an acceptable driving record, and personal insurance coverage.

**How To Apply**:
We must receive your resume **before 11:59 p.m. on Thursday, May 23, 2024.** For those providing a French language resume, please also include an English version.
- Ensure you attached a cover letter and resume. Acceptable file types are:

.doc
- .docx
- .txt
- .pdf
- .rtf

All applicants are thanked for their interest in this position. Only those selected for an interview will be contacted. If contacted, and you require a disability related accommodation in order to participate in the recruitment process you must advise the Hiring Manager.

**Live outside Canada or new to Canada?**
The City of Greater Sudbury is dedicated to maintaining a fair, inclusive, and equitable work environment and our City welcomes qualified applicants from anywhere. To learn more about working in Canada, visit this webpage: Applicants Living Outside of Canada (greatersudbury.ca)

**Contact Us**:



  • Greater Sudbury, Canada City of Greater Sudbury Full time

    **Section**: Data and GIS Services **Division**: Information Technology **Department**: Corporate Services **Initial Reporting Location**: Tom Davies Square **Job Status**: Limited Regular Part Time Position **Estimated Probable Duration**: Seven (7) Months **Affiliation**: Inside Unit **Hours of Work**: Up to 48 hours bi-weekly, **Shift Work Required**:...


  • Greater Sudbury, Canada City of Greater Sudbury Full time

    **Section**: Performance and Change **Division**: Data, Analytics, and Change **Department**: Office of the Chief Administrative Officer **Initial Reporting Location**: Tom Davies Square **Job Status**: Limited Position **Estimated Probable Duration**: Up to Seven (7) Months (may be extended) **Affiliation**: Inside Unit **Hours of Work**: 70 hours...


  • Greater Napanee, Canada Lennox and Addington County General Hospital Full time

    **Basic Function and Scope**: The Business Intelligence IT Analyst will be responsible for providing Information and Technological services to healthcare organizations. This will involve conducting a full review of current processes and preparing a needs analysis. This will be a hands on position and will involve the development of integration modules,...


  • Greater Napanee, Canada Lennox and Addington County General Hospital Full time

    **Basic Function and Scope**: The Business Intelligence IT Analyst will be responsible for providing Information and Technological services to healthcare organizations. This will involve conducting a full review of current processes and preparing a needs analysis. This will be a hands on position and will involve the development of integration modules,...


  • Greater Napanee, Canada Lennox and Addington County General Hospital Full time

    **Basic Function and Scope**: The Business Intelligence IT Analyst will be responsible for providing Information and Technological services to healthcare organizations. This will involve conducting a full review of current processes and preparing a needs analysis. This will be a hands on position and will involve the development of integration modules,...


  • Greater Napanee, Canada Lennox and Addington County General Hospital Full time

    **Basic Function and Scope**: The Business Intelligence IT Analyst will be responsible for providing Information and Technological services to healthcare organizations. This will involve conducting a full review of current processes and preparing a needs analysis. This will be a hands on position and will involve the development of integration modules,...


  • Greater Montreal Metropolitan Area, CA Éclairage Axis Full time

    Description générale du rôle:L'analyste en intelligence d'affaires est essentiel pour analyser le paysage opérationnel actuel et comprendre les besoins opérationnels sous la direction du gestionnaire de l'excellence opérationnelle. Dans ce rôle, vous proposerez des idées et résoudrez des problèmes grâce à une analyse rigoureuse des...


  • Greater Montreal Metropolitan Area, Canada Éclairage Axis Full time

    Description générale du rôle: L'analyste en intelligence d'affaires est essentiel pour analyser le paysage opérationnel actuel et comprendre les besoins opérationnels sous la direction du gestionnaire de l'excellence opérationnelle. Dans ce rôle, vous proposerez des idées et résoudrez des problèmes grâce à une analyse rigoureuse des données et...


  • Greater Montreal Metropolitan Area, Canada Éclairage Axis Full time

    Description générale du rôle:L'analyste en intelligence d'affaires est essentiel pour analyser le paysage opérationnel actuel et comprendre les besoins opérationnels sous la direction du gestionnaire de l'excellence opérationnelle. Dans ce rôle, vous proposerez des idées et résoudrez des problèmes grâce à une analyse rigoureuse des données et à...


  • Greater Sudbury, Canada TESC Contracting Full time

    **Summary**: The Business Systems Analyst supports TESC’s new software implementation team. As a part of TESC’s strategic process improvement initiatives, the Company is implementing a new software platform to achieve standardization and coordination between multiple business functions including Estimating, Pre-Construction, Procurement, Project...


  • Greater Sudbury, Canada KGHM Full time

    KGHM Polska Miedź S.A is an international company that employs approximately 34,000 people around the world and has been a major copper and silver producer for more than 60 years. The Company is highly respected for being a reliable employer, that values employees and experts with technical and market experience. Following our best practices; policies of...


  • Greater Toronto Area, Canada Jamieson Wellness Inc. Full time

    Overall ResponsibilitiesThe Business Intelligence Systems Analyst will have a primary focus on overall security, integrity, and stability of Jamieson’s BI Platforms. Aiding in the design and support of new business reporting solutions, and refinement of existing ones, this role will take on business analyst functions as part of their skill set. This role...


  • Greater Toronto Area, Canada Jamieson Wellness Inc. Full time

    Overall ResponsibilitiesThe Business Intelligence Systems Analyst will have a primary focus on overall security, integrity, and stability of Jamieson’s BI Platforms. Aiding in the design and support of new business reporting solutions, and refinement of existing ones, this role will take on business analyst functions as part of their skill set. This role...


  • Greater Toronto Area, Canada Jamieson Wellness Inc. Full time

    Overall Responsibilities The Business Intelligence Systems Analyst will have a primary focus on overall security, integrity, and stability of Jamieson’s BI Platforms. Aiding in the design and support of new business reporting solutions, and refinement of existing ones, this role will take on business analyst functions as part of their skill set. This...


  • Greater Toronto Area, Canada Jamieson Wellness Inc. Full time

    Overall Responsibilities The Business Intelligence Systems Analyst will have a primary focus on overall security, integrity, and stability of Jamieson’s BI Platforms. Aiding in the design and support of new business reporting solutions, and refinement of existing ones, this role will take on business analyst functions as part of their skill set. This...


  • Greater Toronto Area, Canada Jamieson Wellness Inc. Full time

    Overall ResponsibilitiesThe Business Intelligence Systems Analyst will have a primary focus on overall security, integrity, and stability of Jamieson’s BI Platforms. Aiding in the design and support of new business reporting solutions, and refinement of existing ones, this role will take on business analyst functions as part of their skill set. This role...


  • Greater Toronto Area, Canada Jamieson Wellness Inc. Full time

    Overall ResponsibilitiesThe Business Intelligence Systems Analyst will have a primary focus on overall security, integrity, and stability of Jamieson’s BI Platforms. Aiding in the design and support of new business reporting solutions, and refinement of existing ones, this role will take on business analyst functions as part of their skill set. This role...


  • Greater Toronto Area, Canada Jamieson Wellness Inc. Full time

    Overall ResponsibilitiesThe Business Intelligence Systems Analyst will have a primary focus on overall security, integrity, and stability of Jamieson’s BI Platforms. Aiding in the design and support of new business reporting solutions, and refinement of existing ones, this role will take on business analyst functions as part of their skill set. This role...


  • Greater Montreal Metropolitan Area, Canada Fuze HR Solutions Full time

    Product BI Analyst Full time, MontrealHybrid As the Product Analyst, your role involves extracting valuable business insights from data through intricate analysis, exploration, and visual representation. Your responsibility involves thoroughly examining details to comprehend the underlying dynamics of our business. You'll utilize data pertaining to our...


  • Greater Montreal Metropolitan Area, Canada Fuze HR Solutions Full time

    Product BI Analyst Full time, MontrealHybrid As the Product Analyst, your role involves extracting valuable business insights from data through intricate analysis, exploration, and visual representation. Your responsibility involves thoroughly examining details to comprehend the underlying dynamics of our business. You'll utilize data pertaining to our...