Business Intelligence Operations Intelligence Analyst Jobs in Town of Markham, Ontario

Collaborate with stakeholders to understand their data requirements and translate them into effective PowerBI visualizations and reports.

Collaborate with cross-functional teams to gather requirements, design solutions, and implement data-driven strategies.

Proven experience as a Business Analyst or similar role, with a focus on data visualization and automation.

Experience with Power Automate or similar workflow automation tools.

Excellent problem-solving and analytical skills, with the ability to translate complex data into actionable insights.

Strong communication and presentation skills, with the ability to convey technical information to non-technical stakeholders effectively.

Educational equivalent to a Bachelor’s Degree, preferably in Business, Marketing, Mathematics, Statistics, or a like-discipline. Equivalent work experience equally-valued.

4y+ Insurance industry experience (experience in Ontario Auto insurance required)

2y+ in a business/marketing/competitive-intelligence analyst or working Manager role

Experience making data-driven business decisions leading to better business outcomes

Compelling rewards package including base compensation, eligibility for annual bonus, retirement savings, share plan, health benefits, personal wellness, and volunteer opportunities.

We’ll support your professional development education.

Follow established processes/standards, business technology architecture for development, release management and deployment process.

Design and develop ETL processes based on functional and non-functional requirements in python within AWS platform.

Design, develop and implement reporting platforms and complex ETL frameworks that meet business requirements.

Provide data analysis and requirements within the enterprise platform.

Develop, maintain knowledge of data available from upstream sources and data within various platforms.

You are recognized for your 8+ years of experience of IT Data platform implementation in a technical capacity.

Other duties as assigned by Manager

Well-developed analytical skills and attention to detail

Strong computer skills including Excel, Visual Basic, MS SQL, and Power BI

Excellent communication skills written and verbal

Alteryx knowledge is an asset

2+ years experience in a Business Intelligence Analyst / Data Analyst role, including creation and design of reports

Deep understanding of contract key performance indicator and reporting requirements and client expectations.

College diploma with a minimum of 3 years relevant job experience.

Knowledge of trends in technology relating to software applications.

Advanced skills in data base tools, Power BI, Access, MS Excel, MS office tools, Tableau, and others.

Able to manage multiple projects and priorities

Devise and promote creative data visualization to derive actionable intelligence (Tableau, Power BI, etc.)

Strong understanding of business processes (Finance, Customer Relationship Management (CRM), Risk Management, and Corporate Performance Measurement)

Remains vigilant of industry and technological changes to improve knowledge and working skills related to areas of expertise and new technologies

Strong SQL coding skills are essential; Oracle, PL/SQL, and Unix scripting experience are considered an asset

Works with internal clients to understand their reporting requirements and business questions

Collaborates with others in Data and Business Intelligence to ensure clients’ requirements are met through report design

Provides user training on systems and reporting capabilities

Relevant equivalent experience in a Crime Intelligence Analysis role may substitute for stipulated education requirements.

Attend and participate at briefing sessions, management and analyst meetings and seminars as required.

Research new and evolving analytical techniques and software products; provide knowledge updates and technical support to other analysts/software users as required.

Experience working with and analyzing large quantities of structured and unstructured data

Experience with making evidence-based decisions to inform

Experience working with Geographic Information Systems (GIS) software, such as ESRI ArcMap and/or ArcGIS Pro

As such this candidate will be providing reporting and analysis to Quality, Sales and Operations management teams.

Excellent computer skills. SQL knowledge is required. Knowledgeable about or willing to learn, Excel VBA, Google App Script (JavaScript), and/or Oracle

Specific accountabilities for this position will include:

This candidate will report directly to the ECAN Senior Quality Control Manager and will have no direct reports.

Relevant work experience is an asset

Strong problem solving, mathematical and analytical skills

Capture specified document user requirements, gathering report objectives, required data and specifications.

Carry out data validation with the Applications Manager to ensure reports are pulling all correct data accurately and achieving customer needs.

4+ years of relevant experience including experience with data repository design and maintenance and database administration and complex reporting analysis.

Technical and/or business experience with demonstrable professional growth.

Experience with problem and issue resolution preferred.

Minimum of 3 years’ experience of Data Warehouse technology - SSMS, SSIS, SSAS.

5+ years of experience in Business Intelligence, CRM product ownership, reporting, analytics or data management

Expert oral and written communication skills; senior executive to sales manager level

Facilitate alignment and collaboration across sales, pricing, sales enablement, and marketing, to directly affect Staples Professional’s revenue and customer experience.

Post-secondary degree/diploma or the equivalent relevant working experience

Knowledge of data visualization tools and techniques (Tableau, PowerBI, Looker, etc.).

Proficient in SQL and experience with big data sets in a cloud environment

• 8-10 years of experience with gathering requirements as a Business Analyst.

• Advanced data analysis and SQL skills

• Financial Product knowledge, Front Office technology and Risk and Regulatory reporting is a distinct advantage.

• Python knowledge, Tableau knowledge is an advantage.

• Provide expertise to create project charter, scope, and requirements, initiate, plan, execute.

Hope you are doing well,

Must be able to make presentations coupled with excellent written and verbal communication skills.

As directed, create analysis presentations to support CSBI projects.

Provide data and analysis in support of Acosta CSBI initiatives and projects.

Communicate with Acosta CSBI project directors and Acosta sales associates on status of projects.

Participate and support the development of new Acosta CSBI tools and systems.

Must be able to effectively communicate with others. Must be able to operate a calculator, computer, printer, telephone and copy machine.

Work cross-functionally with Data Management, DBAs, onshore and offshore developers to deliver impactful BI applications

Understand, discuss, and design Data Applications in close collaboration with business users to produce requirements documentation

Good interpersonal relationship, communication, and verbal skills

Data Modeling applied experience with SQL and NoSQL databases (Teradata and Google Big Query preferred)

Hands on experience in MicroStrategy Development (required) and Looker (nice to have)

Experience in Agile, Scrum, and Agile tools (Confluence and Jira preferred)

Strong analytical skills with deductive reasoning capabilities

Accountable to implement solutions to improve the customer experience

Work with internal teams, partners and suppliers to establish communication, manage expectations and make sure Problem/Incident activities are completed

3+ years of experience with an undergraduate degree in business/commerce, engineering, mathematics or other relevant fields is preferred.

Technical know-how: advanced knowledge of Bell Business Market products and services

Interest in acquiring technical and business knowledge relating to one or many customers

Gather business requirements and manage project tasks and timelines

Perform ad-hoc analysis as needed for certain business requirements

Bachelor’s degree or equivalent in quantitative discipline (i.e., Computer Science, Finance, Statistics, Engineering) or related field

3+ years of professional experience in analytics environment with proven value creation outcomes

Excellent verbal and written communication skills and proficiency in translating complex analysis into easily consumed insights through documentation and presentation

Knowledge of standard statistical concepts such as regression, correlation, etc.

Deliver analytic training to diverse stakeholders by identifying new training requirements, improving existing course content, and implementing approved innovations and initiatives.

Undergraduate degree and three (3) years of relevant experience*; or

College diploma and five (5) years of relevant experience*

Relevant experience is defined as:

Experience preparing and delivering presentations and verbal briefings to senior decision-makers.

Experience authoring complex* analytical documents such as intelligence assessments, briefing notes, reports, discussion papers, or research papers

Achieve certification in vendor’s application as required

Microsoft BI certification is considered an asset

3 plus years’ experience in SQL Server 2019

Ability to lead and/or participate in requirement gathering sessions, document user requirements and translate them into useful solutions;

Experience developing indicators and associated documentation;

Experience in maintaining proper data governance best practices

Produce analytical intelligence products on current and emerging issues, with a nexus to Canada, in response to requirements established by management.

Provide analysis to support the achievement of defined analytical requirements.

Undergraduate degree and two (2) years of experience*

College diploma and four (4) years of relevant experience*

Relevant experience is defined as:

Experience performing research and analysis and/or drafting written documents on one of the following: defence, intelligence, global affairs, policing.

Demonstrated experience analyzing business issues and providing recommendations to management;

-Create, disseminate and present operational performance reports and statistical analysis to Senior Management and other stakeholders;

Manage contracts related to the provision of flight schedules, historical air traffic and air traffic forecast data and information.

Experience researching varied and complex issues from a wide array of inputs and sources and recommending solutions;

Experience with Access, Visio as well as Cognos suite of BI applications (or other business intelligence tools);

Experience using mathematical/statistical models and software such as SAS or SPSS;

5+ years of experience in the data management discipline covering the data development, reporting, and analytics space.

Project management orientation to lead short and long-term BI projects into fruition.

Effective communicator with facilitation and conflict resolution skills and an ability to lead a group of diverse stakeholders through decision-making processes.

In-depth knowledge of data marts and data design/architecture concepts.

Experience in technology companies and/or telecom networks is a strong asset

Bilingualism is an asset (English and French); adequate knowledge of French is required for positions in Quebec.