Business Intelligence (Bi)/Data Analyst

On behalf of our client in the Consulting Sector, PROCOM is looking for a Business Intelligence (BI)/Data Analyst.

Business Intelligence (BI)/Data Analyst–

• Reporting to the Senior Manager, Insights & Analytics, this role is a key contributor to our organizational efforts to enabling a robust view of our constituents, partners, programs, and internal performance by fostering a data-driven culture through providing the right insights, to the right people, at the right time
• Create and maintain models that predict changes in the donor base and input into strategies for campaign segmentation, research, and data cleanliness
• Coordinates with other team members to deliver cross functional solutions and data integrations
• Develops strong relationships with internal stakeholders through clear understanding of evolving business needs
• The primary enterprise application is currently Salesforce CRM and Marketing Cloud, various internal data integrations, and our cloud data platform, Snowflake
• And data analytics
• Keeps abreast of product functionality and relevant industry trends in marketing and philanthropy, including data segmentation, acquisitions strategies, donor stewardship
• Translate briefs from the Marketing, Philanthropy and Communications teams into quantitative questions that can be answered with our available data using sound methodologies
• Create and manage statistical models that forecast performance, rates and trends, and share results with channel/product/campaign owners and Senior Management
• Responsible for analyzing campaign and channel performance, as well as identifying trends within the donor base
• Translates functional requirements into technical specifications needed to implement and deliver required reports and outputs
• Working with large data sets, you will extract, prepare and analyze data, and report back on key insights to improve performance and effectiveness
• Pro-actively provide actionable fundraising data analysis, reporting and insights to answer key business needs within Marketing, Philanthropy and Communications
• Visualize data and conduct written and verbal presentation to share insights and recommendations to audiences of varying levels of technical sophistication

Business Intelligence (BI)/Data Analyst– Mandatory Skills

• Exceptional stakeholder service approach; results-driven, and metrics-focused with a passion for continuous improvement
• A solution-oriented approach, experience telling stories that connect the dots between the business and its data, working with a wide range of stakeholders, and communicating the value of data and challenges to using it well
• Strong organizational and time-management skills with the ability to prioritize a varied workload
• Experience understanding and working with complex SQL queries developed by others
• Strong grasp of advanced predictive modelling techniques using Python or R to ensure effective solutions to marketing issues
• An intellectual curiosity related to using data to solve business problems.

Business Intelligence (BI)/Data Analyst- Preferred Skills

• Previous experience with Salesforce applications, Google Analytics and Snowflake and exposure to applications such as Power BI, Tableau, or other BI solutions a significant asset
• Certificates in Data Analysis, Data Visualization and Business Intelligence an asset
• Experience supporting Marketing, Philanthropy and Fundraising departments in the not- not-for-profit sector, including experience supporting complex marketing campaigns (AB testing and segmentation) is preferred

Business Intelligence (BI)/Data Analyst- Assignment Start Date

ASAP – 4 months to start

Business Intelligence (BI)/Data Analyst- Assignment Location

Toronto, ON – Work Hybrid