Business Intelligence and Analytics Specialist Jobs

Experience and Skill Set Requirements

Business Intelligence Specialist – Intermediate

Business Intelligence Specialist - Intermediate

Location: 222 Jarvis St., Toronto, Ontario (Hybrid)

Thank you for considering Arthur Grand Technologies. We look forward to hearing from you soon.

Arthur Grand Technologies is an Equal Opportunity Employer (including disability/vets)

Strong organizational and project management skills.

Highly recommended: Google Tag Manager/Adobe Launch certification.

Experience in website tagging using Google Tag Manager and/or Adobe Launch.

Prior experience with the Google Marketing Platform, including Campaign Manager, Google Ads, and DV 360, highly regarded.

Implement and validate marketing tags across multiple websites and apps using Adobe Launch and Google Tag Manager.

Utilize Adobe Launch and Google Tag Manager to establish detailed event tracking in both Google Analytics and Adobe Analytics.

Strong project management with SAP BI systems implementation knowledge & skills

Confer with end-users, clients, or senior management to define business requirements for complex systems and infrastructure development.

Works with Service Provider to ensure appropriate ticket management

Perform all performance reviews, development plans, coaching, mentoring, time recording approval, and overall management of any assigned staff and consultants

Intermediate to advanced level knowledge and hands on experience with SAP analytics reporting and Dashboarding/Visualization such as SAC and BW/4HANA

Defines reporting business requirements and process design

Exceptional project management and leadership skills, with experience supporting paid media and SEM initiatives.

Expertise in GA4 optimization and Google Tag Management (GTM)

Experience and knowledge of coding (HTML, CSS, Javascript).

Expertise en optimisation GA4 et Google Tag Management (GTM).

Collaborating with our in-house content writers and product marketing managers to optimize landing pages, blogs, and key product pages.

Knowledge of various SEO disciplines and ranking factors.

Gather business requirements and manage project tasks and timelines

Familiarity and experience with SQL (Oracle) is required; R/Python knowledge is an asset.

Perform ad-hoc analysis in response to specific business questions or requirements.

Knowledge of Agile methodology is an asset.

Engage with stakeholders to discover, analyze, and evaluate business intelligence needs to design appropriate solutions

Design and develop compelling data visualizations that effectively answer business questions

Leadership and management skills to manage a high performing team.

Managerial or leadership experience with a demonstrated ability to plan, set priorities, schedule and lead, coach, motivate and manage staff

Certifications or Designations – Certificate in Data Analytics an asset.

Solid understanding of CPG business and operating environment is highly desirable. Experience in the construction industry

Analytical and problem-solving skills to evaluate information, identify and analyze issues, and develop recommendations

Experience with Azure data platform including Data Factory, Data Lake and Databricks

University degree in Business/Economics or related fields with 1+ years of experience; or IT Certification/Diploma/Degree with 3+ years of relevant experience

Effective and collaborative interpersonal skills (written and verbal)

Comfortable working in a fast-paced, complex and dynamic environment with significant change, ambiguity and adapting to evolving organizational requirements

Experience in travel, hospitability, technology industries a plus

Microsoft Dynamics CRM experience is a plus

Responsible for delivering corporate reporting and Power BI projects

Ability to work well under pressure, with strong organizational skills that enable the management of multiple and competing priorities.

Product strategy: develop and management of self-service dashboard and reporting solution

Up to 10 years of experience in the space of analytics, data science and business intelligence.

Proven experience moving an organization along the analytics maturity curve from basic reporting to advanced analytics (from experimentation to mass production)

Experience implementing/working through an analytics community of practice (meet-ups, sharing, coding reviews, joint hiring practices, version control, etc.)

Experience engaging customers/stakeholders, assessing needs, developing and executing a product strategy roadmap

Excellent communication, time management and organizational skills

Work with executives and support all administration activities pertaining to contract management

Assists in providing statistical data on airport and vendor performance management

Manage bidding process, including bid period

Conduct a pre-qualification process of prospective bidders. Prepare and obtain approval of bidder lists

Control and manage the Ground Ops (BI) Dashboard, ensuring accuracy of data

Improve management of existing data, data analysis and visualizations

Nice to have skills and experiences:

Build data visualization products using PowerBI, and share PowerBI knowledge with colleagues

Sound knowledge of financial acumen

Demonstrated skill in data architecture, data modelling, and data analysis and visualization

Functional experience in SharePoint, SQL and query logic, and cloud infrastructure

Gather and analyze business requirements from stakeholders and translate them into technical specifications for data models, reports, and dashboards

5+ years of experience developing Power BI reports, dashboards, and analytics solutions

Strong experience with Alteryx and Azure Synapse to perform data transformation, data integration, and data preparation

Experience with DAX and M formula languages in Power BI to create complex calculations and data models

Experience with Power Query to connect to various data sources, transform data, and load data into Power BI

Strong SQL skills to write complex queries, optimize data retrieval, and troubleshoot data issues

Good knowledge of Asset Management and understanding of current market trends. Experience in Mutual Funds, ETF and Institutional distribution process

Produce dashboards, reports, analysis, insights that drive decisions and help us build better products and experiences

Manage, prioritize, and respond to ad-hoc requests

5-7 years of work experience in Business, Financial industry

3+ Proven experience working with SQL language and large datasets

Good verbal and written communication skills; able to effectively present analytics data to business users

Support internal teams on PowerBI and workspace management.

Learn new tools that will elevate our BI offering and bring more value to our end users.

Experience organizing or expanding a Community of practice/Center of excellence for analytics.

Collaborate with the BI Team to establish standards and operating procedures for business intelligence infrastructure.

Research, implement and maintain business intelligence best practices across the organization.

Cultivate a data driven culture as a leader in the Business intelligence & analytics Community of Practice.

Familiar with data warehouse design, database management and distributed systems

Manage the team workflow and ad hoc data requests with a view of streamlining the process and managing stakeholder expectations

At least 3 years of supervisory experience, mentoring and developing teams' careers

Proven experience managing multiple projects and meeting deadlines

You excel at working with non-technical stakeholders to help translate, manage and drive business needs into actionable insights

Extensive experience with BI Tools (Tableau, Power BI, Mixpanel, Excel, Google Sheets)