Business Intelligence Analyst

2 months 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 have the ability to 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 and the day-to-day direction of the Senior Business Analyst.

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 Tuesday, November 12, 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



  • 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 Toronto Area, Canada Dimensional Strategies Inc. Full time

    Estimated Salary: $120,000 - $180,000 per yearAbout Dimensional Strategies Inc.We are a leading consulting firm that specializes in data analytics and business intelligence. Our team of experts helps clients optimize their data-driven decision-making processes using the latest tools and technologies.Job Description:We are seeking an experienced Senior...


  • Greater Toronto Area, Canada Kruger inc. Full time

    About Kruger Inc.We are a leading company in the industry, seeking an experienced SAP BW Analyst to join our team. The ideal candidate will have a strong background in SAP data warehousing, data modeling, and business intelligence reporting.ResponsibilitiesSAP BW Development:Design, develop and maintain SAP BW data models and data flows.Integrate SAP BW with...


  • Greater Toronto Area, Canada Microsoft Full time

    Microsoft is on a mission to empower every person and every organization on the planet to achieve more. Our culture is centered on embracing a growth mindset, a theme of inspiring excellence, and encouraging teams and leaders to bring their best each day. In doing so, we create life-changing innovations that impact billions of lives around the world. You can...


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

    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, database reporting (including...

  • Business Analyst

    7 months ago


    Greater Sudbury, Canada Northern Ontario School of Medicine Full time

    Reporting directly to the Manager, Community Relations Unit, the Business Analyst is responsible for design, development, analysis, and maintenance of the Unit’s operational and business objectives (i.e., scheduling, electives, and housing) while providing strategic recommendations based on data. The Business Analyst’s role at NOSM University involves...


  • Greater Sudbury, Canada TESC Contracting Company Ltd Full time

    **Summary**: The Business Systems Analyst & Support Specialist collaborates with TESC’s new software implementation and maintenance team. As a part of TESC’s strategic process improvement initiatives, the Company is researching a new software platform to achieve standardization and coordination between multiple business functions including Estimating,...

  • Business Analyst

    7 months ago


    Greater Toronto Area, Canada S2H Business Information Systems Full time

    **We and our customers are successful because**: - D2R-Collect are **Focused** on collecting - With higher success rates and fewer calls - D2R-Collect are easy to implement - A SaaS Application with no requirement for hardware or software installation - Simple to understand and use - Adaptable to our customers - and their clients' business practices -...

  • Business Analyst

    2 months ago


    Greater Sudbury, Canada Vale Full time

    **Ready to build a rewarding career in an industry that is growing?** **Who We Are** We are a global mining company dedicated to safely delivering nickel, copper, cobalt, and platinum group metals essential for the world’s energy transition. Our mission is to improve lives and shape a better future together. From utensils to cellphones to satellites,...

  • Business Analyst

    6 months ago


    Greater Sudbury, Canada Vale Full time

    **Who We Are**: Welcome to Vale in Canada. As a leader in the mining industry, our responsibility is to positively impact our people, communities and the environment. We value our workforce and offer continuous training and career development opportunities for our people. With our global headquarters in Rio de Janeiro, Brazil, and approximately 125,000...

  • Business Analyst

    6 months ago


    Greater Sudbury, Canada Vale Canada Full time

    **Who We Are**: Welcome to Vale in Canada. As a leader in the mining industry, our responsibility is to positively impact our people, communities and the environment. We value our workforce and offer continuous training and career development opportunities for our people. With our global headquarters in Rio de Janeiro, Brazil, and approximately 125,000...

  • Reline Merchandiser

    5 days ago


    Greater Sudbury, Canada Counter Intelligence Merchandising Inc. Full time

    **Counter Intelligence Merchandising Inc. **is always seeking to contract with talented, energetic people who are able to provide services to our expanding client base_**. **_We service all retailers across the country including Shoppers Drug Mart, Walmart, Rexall and many more! **Come join our team of merchandisers TODAY!** **Looking to hire immediately...

  • Reline Merchandiser

    3 months ago


    Greater Sudbury, Canada Counter Intelligence Merchandising Inc. Full time

    **Counter Intelligence Merchandising Inc. **is always seeking to contract with talented, energetic people who are able to provide services to our expanding client base_**. **_We service all retailers across the country including Shoppers Drug Mart, Walmart, Rexall and many more! **Come join our team of merchandisers TODAY and participate in our upcoming...


  • Greater Sudbury, Canada Spectrum Telecom Group Ltd. Full time

    Junior Business Analyst Today, wireless connectivity is one of the fastest-growing industries. At Spectrum Group, we offer wireless solutions for companies to connect and communicate. From designing two-way radio systems to broadband wireless networks, affordable radio rentals, Internet, and our new wide-area Push to Talk Network (TalkPlus), we provide...


  • Greater Toronto Area, Canada Professional Staffing Full time

    My Client is seeking and Business Process Analyst : As a Business Process Analyst, you will be responsible for analyzing, designing, and improving business processes within our organization. You will work closely with stakeholders from various departments to understand their needs, identify inefficiencies, and propose solutions to streamline operations and...


  • Greater Sudbury, Canada Spectrum Telecom Group Ltd. Full time

    Junior Business Analyst Today, wireless connectivity is one of the fastest-growing industries. At Spectrum Group, we offer wireless solutions for companies to connect and communicate. From designing two-way radio systems to broadband wireless networks, affordable radio rentals, Internet, and our new wide-area Push to Talk Network (TalkPlus), we provide...

  • RELINE Merchandiser

    4 weeks ago


    Greater Sudbury, Canada Counter Intelligence Merchandising Inc. Full time

    *Counter Intelligence Merchandising Inc. *is always seeking to contract with talented, energetic people who are able to provide services to our expanding client base_*. *_We service all retailers across the country including Shoppers Drug Mart, Walmart, Rexall and many more!*Come join our team of merchandisers TODAY and participate in our upcoming COSMETIC...

  • RELINE Merchandiser

    2 months ago


    Greater Sudbury, Canada Counter Intelligence Merchandising Inc. Full time

    *Counter Intelligence Merchandising Inc. *is always seeking to contract with talented, energetic people who are able to provide services to our expanding client base_*. *_We service all retailers across the country including Shoppers Drug Mart, Walmart, Rexall and many more!*Come join our team of merchandisers TODAY and participate in our upcoming COSMETIC...

  • RELINE Merchandiser

    3 months ago


    Greater Sudbury, Canada Counter Intelligence Merchandising Inc. Full time

    *Counter Intelligence Merchandising Inc. *is always seeking to contract with talented, energetic people who are able to provide services to our expanding client base_*. *_We service all retailers across the country including Shoppers Drug Mart, Walmart, Rexall and many more!*Come join our team of merchandisers TODAY and participate in our upcoming COSMETIC...


  • Greater Montreal Area, Canada Noverka Conseil Full time

    **Vue d'ensemble**: Chez Noverka, nos valeurs illustrent qui nous sommes et définissent nos convictions : Humain, Transparent, Passionné. Nous sommes menés par l’innovation et le succès, tant au niveau relationnel qu’au niveau de nos pratiques. Trouver le bon emploi pour la bonne personne, c’est ce que nous faisons de mieux! Notre client, une...