Senior BI Analyst/Data Analyst
The Senior BI Analyst/Data Analyst will contribute to the design, development and maintenance of strategic, high-profile executive-level dashboards/reports and will play a key role in developing database objects, metrics, dashboards/reports using Microsoft BI technologies (SQL Server 2016 Enterprise, Power BI, SSIS, Excel, etc). They will also assist business in developing business cases and forecasting/planning using data from data warehouses.
• Design, develop and maintain data warehouses to integrate data from the most appropriate data sources to ensure accurate and timely reporting.
• Design, develop and maintain Power BI dashboards/reports.
• Develop data models and schemas to accurately represent structured and unstructured raw data in databases
• Transform raw data into preprocessed data to be used in generating actionable insights
• Proactively seek to understand end-user requirements in order to implement effective data visualizations in dashboards/reports.
• Proactively seek opportunities to automate the most time and resource intensive processes related to data collection validation, transformation, etc. to optimize the production and delivery of dashboards/reports.
• Contribute to the design and implementation of branding (i.e., standardized “look and feel”) for all dashboards/reports.
• Assist in the development of a future state BI architecture and roadmap.
• Help investigate and diagnose issues and ensure problems and defects are resolved in a timely manner.
• Analyze data for trends and building analytical models to determine revenue opportunities, minimize risk and assist business in financial modelling for business cases, compensation plans, sales targets, etc.
• Manage the Planning and forecasting process
• Play lead role in analytics requirements of business.
Qualifications
• 5 years hands-on technical Business Intelligence experience with advanced knowledge in Microsoft BI technologies (SQL Server, Power BI, Power Pivot, Visual Basic).
• Advanced knowledge of Excel and reporting tools, VB, relational database tools such as Access.
• Designing ETL processes, including development of relational data model
• Strong SQL skills, including common table expressions, window functions, joins, complex data types, stored procedures and update scripts
• Experience in building and updating SSIS ETL workflows
• Ability to analyze large data sets
• Developed financial models and analyses relating to Plan and Forecasting, business cases
• Excellent interpersonal, communication and negotiation skills.
• Ability to work effectively in a self-directed manner and also as part of a project team.
• Ability to effectively handle ambiguous, ad hoc tasks and changes in direction and priorities in response to unexpected events and circumstances.
• Experience with other BI tools such as Tableau, MicroStrategy, etc. is an asset
• Experience with Cloud technologies (e.g., Microsoft Azure, AWS) is an asset
This is permanent position located in Toronto. Hybrid position work from home 3-4 days/week.
Senior BI Analyst/Data Analyst • Toronto
About CookUnity Food has lost its soul to modern convenience.And with it, it has lost the power to nourish, inspire, and connect us.So in 2018, CookUnity was founded as the first‑of‑its‑kind platfo... Show more
Senior Data Analyst to identify and unlock business opportunities across Match Group brands.Role involves hands-on analysis, product strategy, experimentation, and defining enterprise business metr... Show more
Seeking a Senior Data Analyst to analyze data, ensure integrity, and deliver insights for strategic business decisions.Requires SQL, Python, and Tableau. Show more
A government agency in Ontario is seeking a Senior Business Analyst to assist with report development for a new data warehouse.The ideal candidate has over 10 years of experience and is skilled in ... Show more
A leading technology firm in Toronto is seeking a Sr.Business Analyst for a hybrid role.The ideal candidate has over 10 years of experience with strong capabilities in requirements gathering, data ... Show more
Seeking a Senior Data Analyst to build scalable data architecture, integrating data from various digital platforms into Power BI dashboards.Responsibilities include data extraction, modeling, advan... Show more
Seeking a Senior Data Analyst to extract and translate insights from member data into accessible presentations for leadership.Responsibilities include data analysis, visualization, and collaboratio... Show more
Lead a BI team for a car-sharing marketplace, focusing on AI-driven dashboards, data visualization using Domo and Tableau, and optimizing data processes.Requires 4+ years of experience and advanced... Show more
Senior Data Analyst to lead BI ecosystem, administer tools like Domo and Tableau, build advanced dashboards, and innovate with AI. Show more
Seeking a Data Analyst in Vancouver to analyze data, develop reports, and support data governance.Requires a quantitative degree and experience with SQL and Power BI. Show more
A financial services company is seeking a highly proficient SAS Analyst in downtown Toronto.The role involves developing complex data analysis, creating Power BI dashboards, and optimizing SQL quer... Show more
A leading consulting firm located in Toronto, Ontario is seeking a Senior Business Data Analyst to bridge business and data teams.The candidate will gather requirements, design data warehouse solut... Show more
Seeking a Senior Data Analyst to lead and maintain complex BI solutions, focusing on report development, data quality, and stakeholder collaboration. Show more
Seeking a Senior Commercial Data Analyst to lead reporting and data management, working with cross-functional teams to develop advanced solutions and ensure data quality.Requires 5+ years of experi... Show more
Seeking a Senior Data Analyst for a financial services company in Canada to lead data automation and modernization.Requires Python, SQL, financial services experience, and 3+ years of analytics exp... Show more
Canada’s fibre, 5G and satellite broadband company for rural living.Xplore is committed to the relentless pursuit of an improved broadband experience for all Canadians.Xplore is building a world‑cl... Show more
Data is central to how we understand customer behavior, measure product success, and build better experiences for our customers.Autodesk is seeking a Senior Data Analyst - Product Analytics to join... Show more
Experienced Data Analyst to lead reporting and analytics for a manufacturing company, specializing in Power BI and SQL, creating dashboards and supporting teams. Show more
Seeking a Senior Data Analyst for a loyalty program to optimize data for millions of members, focusing on insights, reporting, and data quality enhancement.Requires Python, SQL, and data visualizat... Show more
Seeking a Senior Data Analyst to drive data automation and modernization in financial services, requiring Python, SQL, and 3 years of experience. Show more
