Business Intelligence Marketing Analyst Jobs in City of London, Ontario

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 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

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

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.

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.

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;

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.)

Review requirements and technical design documents with developers to confirm expected functionality and business needs.

Determine test environment and test data requirements.

Enthusiastically collaborates with business partners to ensure data and reporting requirements are fulfilled.

Participate in discovery meetings, provide estimates, analyze and validate project requirements and technical specifications, perform impact analysis and document key issues.

5-7 years of experience working with SQL (writing complex queries).

5-7 years of hands-on QA work experience as part of BI team

Must have experience using SAP Business Objects, specifically with at least 2 of the following products: IDT, WebI, or Translation Manager.

Must have a minimum of three 3 years in the last five 5 years of MS Power BI development experience.

Must have experience analyzing, developing, and implementing multiple Business Intelligence BI projects.

Must have experience developing visual reports, dashboards and BPI scorecards using Power BI.

Must have experience connecting to a variety of data sources and implementing various security options within Power BI

Must have experience administering Power BI, setting functionality, workspaces, security, and monitoring controls.

Experience in category management and proficiency using various POS, data tools to interpret large quantities of data for insights

Post-secondary education or work experience equivalent – Business Diploma or Degree preferred and proven CPG related experience

Develop and maintain effective working relationships with team members, internal partners, customers and others through the use of strong interpersonal skills.

Experience at working independently and in a team environment.

Strong verbal & written communication skills.

Solid knowledge of current Internet, Intranet, Extranet, and client server architectures, including Share Point.

Strong time management skills to meet deadlines & handle changing priorities

Participate in data management and governance reviews, data maturity assessments

Synthesize strategic insights and effectively communicate findings to senior management;

University Bachelor’s degree in Business, Real Estate, Applied mathematics / Statistics, equivalent work experience;

Advanced communication and negotiation skills; must be able to articulate recommendations and results

Experience with data visualization software such as Power BI, Tableau

Create presentations on a weekly basis for mid to senior-level management

Highly organized, proven ability to manage multiple tasks simultaneously, to gather/organize data and turn results into insights

Experience using SQL or a strong desire to learn, SQL is critical for this role

Excellent communication skills, both written and verbal, and strong interpersonal skills

Telecom experience would be an asset

Report on national churn results, with an understanding of competitive pricing and other macro factors to provide insightful commentary & recommendations

Experience with IT project management would be an asset;

MINIMUM SKILLS, KNOWLEDGE AND ABILITY REQUIREMENTS:

Provide project management for BI solutions for new customer implementations

Work with external and internal customers to gather comprehensive requirements and document them formally

Good understanding and working experience of transactional and dimensional data models

Bachelor degree or above qualification preferably in Information Systems, Computer Science or equivalent

Experience in budget management and forecasting is preferred.

Supports process and technology auditing and technology management Marketing Process

Supports process optimization and change management Project Management

Knowledge of and ability to help create funnel metrics and other models used to support demand generation planning and execution.

Proven hands-on experience building out measurement frameworks combining descriptive analytics, modeled insights, and causal inference to make tactical recommendations.

Strong analytical skills with the ability to translate complex data into actionable insights.

Strong organizational and time-management skills with the ability to prioritize a varied workload

Create and manage statistical models that forecast performance, rates and trends, and share results with channel/product/campaign owners and Senior Management

Translates functional requirements into technical specifications needed to implement and deliver required reports and outputs

Experience understanding and working with complex SQL queries developed by others

Business Intelligence (BI)/Data Analyst– Mandatory Skills

Business Intelligence (BI)/Data Analyst- Preferred Skills

Post-secondary education in computer science or related discipline from an accredited institution

3+ years' experience in a Business Intelligence development role

2+ years' experience in a team leadership role

2+ years' experience with Power BI

Demonstrated experience using creative techniques in data visualization and storytelling

Hands-on design and development experience using SQL, SQL Server, SSAS, SSRS, SSIS, Power BI, and ETL

Become a masterful insights storyteller who can create content for audiences with varying levels of marketing experience

2-3 years of experience within digital marketing

Experience in paid media or lifecycle marketing analytics

Experience in creating PowerPoint presentations

Knowledge of both performance and brand marketing goals and key performance indicators

Experience with measurement goals across upper, mid, and lower funnel marketing campaigns

Analyzing complex statistical reports and/or financial information for management decision-making (using SAS, R, SPSS)

Conducting detailed data analysis to inform management decision-making using Business Intelligence/Analytics Tools such as Power BI and Tableau

Bachelor's Degree with a background in statistics, mathematics, computer science or an acceptable equivalent combination of education and experience.

Advanced knowledge and experience using SQL.

Experience working with student data in higher education environment.

Experience developing data visualizations using Tableau dashboards for higher education.

Experience engaging diverse stakeholders, including technical and non-technical teams (Product, Marketing, Finance, IT, and Operations).

Fully paid benefits by the employer!

Offer analytical insights to support cross-functional teams and collaborative problem-solving.

Contributing to precise business requirements as a Business Analyst.

3+ years of progressive Data Analysis experience.

Effective communication skills for conveying insights.

Offer an advisory role to internal customers by analyzing, understanding and organizing their needs;

Develop an in-depth knowledge of Videotron's residential and commercial customers and the markets in which the company operates.

Have 5 to 7 years of relevant experience;

Strong programming skills in SQL, R, Python;

Experience with Spark, Pandas, Numpy and Scikit-learn (asset);

Fully support data analysis projects within the Data Science team;

Offer an advisory role to internal customers by analyzing, understanding and organizing their needs;

Develop an in-depth knowledge of Videotron's residential and commercial customers and the markets in which the company operates.

Have 5 to 7 years of relevant experience;

Strong programming skills in SQL, R, Python;

Experience with Spark, Pandas, Numpy and Scikit-learn (asset);

Fully support data analysis projects within the Data Science team;

Work with the Data Engineering team to provide high-quality data requirements.

Has strong data ETL pipeline development and data visualization experience.

Has 8+ years of work experience as a Business Intelligence Engineer, Data Analyst, Product Analyst, or a similar role.

Has strong analytical and critical thinking skills, high attention to detail, and a strong bias toward actionable insights.

Excellent health care (including a wide range of medical, dental, vision, mental health, and fertility benefits)

Grammarly is excited to offer a

Experience with relational databases and/or writing SQL queries

Experience designing, building and managing relational database within environments such as Snowflake

Knowledge of additional programming languages such as Python or R is desirable.

Proficiency in SQL for data retrieval and manipulation, and experience working with databases such as Snowflake, PostgreSQL, or similar.

Proven experience as a Business Intelligence Analyst or similar role, with a strong understanding of data analysis techniques, methodologies, and tools.

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

Define and deliver business requirements by leading working sessions.

Manage multiple concurrent projects and priorities.

Solid experience with Teradata, Oracle and SAS; tools and products;

Strong communication skills and ability to work with people with various skills (technical and non technical)

Ability to work closely with business stakeholders to understand requirements and deliver expected solution;

Excellent analytical and organizational skills.

Knowledge or experience of machine learning and data science is a plus

Breadth of technical experience and knowledge in the MSFT data and analytics ecosystem, with Subject Matter Expertise in Power BI

Experience and proficiency in SQL scripting and Azure is a must

Experience and proficiency with an additional programming language such as Python is an asset

People management: Managing and mentoring our marketing analyst, providing guidance, feedback, and support in their professional development

Strong understanding of marketing principles and strategies, including digital and offline marketing channels, and customer lifecycle management

Work from home Monday, Thursday, & Friday

Meet the Marketing & Finance/Data Teams Viv, Nick & Mihir

Meet the Hiring Manager Candy

Background Check + Offer Stage

Using your problem-solving skills to help decrease our bounce rate, increase our conversion rate, and enhance customer engagement

Creating actionable reports – we’re a data-driven organization, so we’ll appreciate you being a stickler for accuracy.

Working with data visualization tools like Google Data Studio, Tableau, and Spreadsheets.

AlgaeCal Healthcare Plan (Premiums Covered 100%!), which you're eligible to sign up for after three months of employment.

Flexible Stat Holidays with the option to bank days for later use.

This Job Will Give You ALL The Feels

Knowledge and experience of digital marketing analytics functions such as campaign attribution/effectiveness, web tracking and customer lifecycle marketing

5+ years of experience in reporting and analytics

Experience with at least one analytics and visualization tool such as Tableau, Looker, etc

Refine and optimize the end-to-end campaign strategy and tactics for acquisition, conversion and retention

Partner with internal digital marketing team members to implement advanced attribution measurement methodologies (MMM and MTA)

Conduct in-depth analysis to understand the effectiveness and long-term impact of our awareness-marketing spend on the business

Detail-oriented with strong organizational and project management skills

Ability to effectively prioritize and manage multiple projects simultaneously while meeting deadlines, strong time management skills

Project management experience is helpful

Post-secondary education in Economics, Analytics, Business, Math, or Computer Science Minimum 3 years of data science, marketing, or analytics experience

Also, work closely with the Data & Technology team to brief and implement analytics dashboard requirements (i.e., Tableau dashboards).

Support the measurement strategy & planning process by identifying objectives & key success metrics and defining measurement approach & requirements

Collaborate with stakeholders and cross-functional teams to gain an understanding of their needs and requirements.

You are comfortable stepping out of the responsibilities in this job description!

You have strong written communication skills (this is key to succeeding in an asynchronous workplace like ours).

Experience with Data visualization tools (Domo, Tableau, PowerBI, IBM Cognos Analytics, etc.).

Previous experience working for a B2B SaaS company.

Basic Knowledge of dbt and Stitch.

Project Management: Experience in managing projects, including planning, coordination, and resource management.

Client Relations and Account Management: Manage client accounts and ensure satisfaction, including successful implementation of software solutions.

Requirements Gathering: Work closely with stakeholders to gather and document business requirements for marketing systems, translating them into clear specifications.

Solution Development: Support the development and implementation of marketing system solutions, ensuring they meet business requirements.

While this is a remote position, you must be located in the Metro Vancouver area.

Education: Bachelor's degree in a relevant field such as Computer Science, Information Technology, or Marketing.