酒店预订数据分析报告（Pivot Table 实战案例）
2025年9月10日
2025-08-16 Job description for Data analysis
2025-08-16 Job description for Data analysis
Senior Business Data Analyst
Loblaw Companies Limited —Brampton, ON3.4
University degree or post-secondary education in Finance, Business, Math/Statistics, Analytics or other relevant field.
Responsibilities:
Engage with key stakeholders/teams in Finance to ensure their reporting needs are fulfilled.
Evaluate new data sources and help define more effective ways to communicate data
Summarize vast amounts of data to develop reports and models that solve business problems.
Build powerful business intelligence visualizations/insights using a variety of tools such as MicroStrategy, Power Platform, Excel, and others.
Create/maintain comprehensive and accurate documentation to ensure retention of institutional memory.
Role Requirements:
Minimum 2 years related work experience in similar role.
University degree or post-secondary education in Finance, Business, Math/Statistics, Analytics
Proficient in SQL for query optimization and syntax knowledge
Experience with Python and data science tools preferred
Proficient in Microsoft Office applications (Power Query, VBA etc).
Working knowledge of BI Tools such as MicroStrategy, Power BI, Tableau, etc.
Working knowledge of database applications such as Teradata, GCP and MS SQL Server
Previous experience with SAP system preferred.
Experience with and/or exposure to Application Tools such as SAS, R, VBA etc. would be an asset.
Senior Consultant, Forensics
KPMG —Calgary, AB
Excellent research and analytical skills, with the ability to identify and define problems in a clear and articulate manner and develop creative solutions to…
What you will do:
Lead or assist in forensic accounting mandates such as financial fraud investigations, fraud prevention, forensic examinations, calculating and analysing claims for financial losses, providing advisory services, preparing financial data, and tracking funds and accounts.
Analyse financial data, examine documents, carry out in-depth research and conduct forensic accounting engagements concerning,
Document review.
Assist with interviewing.
Review or produce financial reports as an independent expert.
Ensure the quality of reports and deliverables and see that the firm’s quality standards are applied.
What you bring to this role:
Bachelor of Business Administration or similar.
Specialisation in Forensic Accounting, with an additional professional designation,
2-3 years of professional experience in an accounting and/or auditing role preferred.
Experience in some of the following software would be considered an asset: MS Access, Alteryx, SQL, ACL / Galvanize / IDEA, Tableau / Power BI, Python, R, and SAS.
Manager, Advanced Analytics (Quants)
TD Bank —Toronto, ON3.7
Strong statistical background and excellent analytical and problem solving skills with a graduate degree in one or more of the following areas: statistics,…
$91,200–$136,800 a year
The position reports to Senior Manager, Retail Credit Risk, Model Validation
Perform validation of all models deemed in-scope by the bank-wide Model Risk Policy. These models are used in the Bank for projecting Pre-Provision Net Revenue (PPNR) estimates for stress testing (DFAST, EWST) purposes, adjudication/management/collection for various retail products, marketing and analytics, etc.
Develop independent benchmarks for use in the validation of the above listed models. These benchmark models could be supervised learning, unsupervised learning and deep learning algorithms.
Prepare detailed reports describing the mathematical analytics of the model, validation techniques employed, test results obtained, and any model limitations noted.
Establish and maintain productive working relations with internal model development groups such as US and CAD Retail Model Development, Financial Stress Testing (FST), etc., as well as external vendors who have developed customized models for TD.
Requirements and/or qualifications :
Strong statistical background and excellent analytical and problem solving skills with a graduate degree
At least 5 years of experience with model development/validation, including machine learning models, dealing with PPNR stress testing, scorecard and/or capital models
Hands-on experience with relevant programming languages, such as Python, SAS, R is a must
Knowledge in retail banking products, customer behaviours, and macroeconomic impacts is a definite asset
Research Coordinator, Paediatrics
The University of Calgary —Calgary, AB4.1
Minimum of 3 to 5 years related experience of active involvement in research in an academic or clinical research setting, research institute or in an…
Summary of Key Responsibilities (job functions include but are not limited to):
Developing data collection tools and research questionnaires, conducting data collection
Screening and recruitment of study participants
Sending out questionnaires and following up on the completion of questionnaires
Assisting with data cleaning and data analysis
Writing annual reports
Processing payment of invoices
Completing assigned and scheduled tasks under own initiative with limited direct supervision. Managing own time effectively and ensuring the PI is kept informed of activities and progress of work
Qualifications / Requirements:
Bachelor Degree required, MSc preferred in Health Sciences,
Minimum of 3 to 5 years related experience of active involvement in research in an academic or clinical research setting, research institute or in an organization under the direction of a research scientist
Experience with quantitative data collection and analysis required
Familiarity with AHS systems (such as Connect Care) preferred
Intermediate to advanced skills in Microsoft Office Suite (Access, Word, Outlook, Excel, Powerpoint)
Experience with statistical software (e.g. R, SPSS, Stata, SAS) and online questionnaire software (e.g. Qualtrics, RedCap) is a strong asset
Tri Council Policy Statement (TCPS 2) and Good Clinical Practice (GCP) training is an asset
Consultant, Strategic Initiatives
CIBC —Toronto, ON3.7
We work to recognize you in meaningful, personalized ways including a competitive salary, incentive pay, banking benefits, a benefits program*, defined benefit…
How You’ll Succeed
Strategic Development & Execution: Lead and coordinate complex solution design activities aligned with our transformation roadmap by translating business requirements into system
Analytical Thinking: Interpret complex information, identify patterns and trends in strategic areas, and develop actionable recommendations
Automation Development: Develop self-serve automation capabilities using tools such as MS Power Apps, MS Power Automate, Alteryx, and Azure DevOps.
Reporting and Business Intelligence: Create and maintain reports, data cubes, and performance dashboards to provide senior management with high-level visibility into business performance, utilizing BI tools such as Power BI and Tableau.
Project Delivery:
Lead critical projects to enhance or upgrade products, processes, programs, or services by researching relevant data and delivering effective solutions.
Who You Are
You can demonstrate experience in designing, developing, implementing and supporting applications with expertise in most of the following: No/Low Code Tools (VBA, Alteryx, Power Automate, Power App), Analytics Software (Tableau, Power BI), Databases (SAS, SQL Server), and other tools such as Azure DevOps and Selenium.
You have a degree/diploma in a technical discipline. Experience with machine learning or AI is an asset. PMP and Lean Six Sigma certifications are considered an advantage.
You put our clients first. You engage with purpose to find the right solutions. You go the extra mile, because it’s the right thing to do. You’re passionate about people. You find meaning in relationships, and surround yourself with a diverse network of partners. You build trust through respect and authenticity.
AML Analytics Consultant
CIBC —Toronto, ON3.7
We work to recognize you in meaningful, personalized ways including a competitive salary, incentive pay, banking benefits, a benefits program*, defined benefit…
Your responsibilities will include:
Conduct in-depth analysis of new and emerging AML risks, including trends in financial crime, regulatory changes, and technological advancements.
Leverage advanced analytics tools and methodologies to detect patterns, anomalies, and potential risks in transactional and customer data.
Develop, validate, and optimize AML detection models to ensure they address emerging risks effectively.
Prepare detailed reports and dashboards to communicate findings, trends
Who You Are
You have a proven track record in analytics, financial crime risk management, or a related field, with at least 3 – 5 years of relevant experience.
You are proficient in data analytics tools such as SQL, Python, R, or SAS, and have experience working with large datasets.
You have a strong understanding of AML regulations, including FATF guidelines, FINTRAC requirements, and global compliance frameworks.
You excel at identifying patterns, assessing risks, and making data-driven decisions.
Decision Support Analyst, Decision Support
Pembroke Regional Hospital —Pembroke, ON3.4
The Decision Support Analyst works within a team model, whose function is to provide clinical utilization, financial analysis and strategic problem solving to…
$39.48–$44.24 an hour
Closing Date: August 31, 2025
REQUIREMENTS:
Minimum of a four (4) year university degree in healthcare or business administration,
Minimum of two (2) years relevant experience in the hospital / health care environment
Possesses working knowledge of Ontario Ministry of Health and Long-Term Care (MOHLTC) Reporting and Hospital business processes.
Experience with health records data (CIHI), case costing and MIS/OHRS is an asset.
Advanced proficiency in Microsoft applications including Excel, Access DB and PowerPoint, Report Generator and Crystal Report writer would be an asset.
Experience with other analytical/statistical tools (SPSS or SAS) would be an asset.
Experience working with healthcare-related databases, specifically manipulating data and performing statistical data analysis.
Bilingualism preferred (French/English)
RESPONSIBILITIES:
Providing statistical and quantitative methods support for Directors/Managers and Committees
Analysis of productivity reports, activity budgets, cost trends, and case cost.
Preparation of Ministry of Health and Ontario Health reporting with respect to statistical and clinical information.
Integration of utilization data into business plans, proposals and reports.
Monitoring and interpretation of financial and statistical data and trends, including interpreting financial performance measures, analyzing monthly budget variances and resolving discrepancies in reports.
Assisting in developing master programs, business cases and functional plans for redevelopment through collection and analysis of data.
Communicating and working collaboratively with Health Records, Finance department, nursing units
Manager, Customer Insights & Reporting
BMO Financial Group —Toronto, ON3.7
A recruiting agency must first have a valid, written and fully executed agency agreement contract for service to submit resumes.
$69,000–$129,000 a year
Full job description
Builds various reporting dashboards using the most appropriate data extraction, data cleaning and data visualisation techniques.
Provides value through insights, reporting and data visualization techniques
Translates business needs to technical specifications and evaluates existing data visualization systems in order to improve them.
Develops data visualizations of “large” amounts of data that facilitate the intuitive presentation of data to decision makers.
Documents data flow, systems and processes to improve the design, implementation and management of business/group processes.
Qualifications:
Data visualization.
Data storytelling.
Data mining.
Insights design.
Insights development and reporting.
Typically between 5 – 7 years of relevant experience and post-secondary degree in related field of study or an equivalent combination of education and experience.
Deep knowledge and technical proficiency gained through extensive education and business experience.
Proficient user SAS, SQL, and or Python, R.
Senior Consultant – Risk BA
Infosys —Mississauga, ON3.8
Actively aid the consulting team in different phases of the project including problem definition, effort estimation, diagnosis, solution generation, design and…
$89,004–$103,042 a year
Full job description
Infosys is seeking a Senior BA Risk Analyst. This position will interface with key stakeholders and apply technical proficiency across different stages of the Software Development Life Cycle including Requirements Elicitation, Application Architecture definition and Design; play an important role in creating the high level design artifacts; deliver high quality code deliverables for a module, lead validation for all types of testing and support activities related to implementation, transition and warranty. This is an opportunity to be part of a learning culture, where teamwork and collaboration are encouraged, excellence is rewarded, and diversity is respected and valued.
Required Qualifications :
Bachelor’s degree or foreign equivalent required from an accredited institution.
At least 4 years of Information Technology experience.
Knowledge of PL/SQL for data analysis, knowledge of data warehouse technologies to store risk data
Comprehensive knowledge of liquidity risk models, including stress testing, scenario analysis, and funding gap analysis.
Strong understanding of regulatory requirements related to liquidity risk management (e.g., Basel III, Dodd-Frank Act, LCR, NSFR).
Familiarity with regulatory requirements such as Basel III (LCR, NSFR) and U.S. Federal Reserve liquidity guidelines.
Experience with data mapping and integration processes to ensure accurate representation of liquidity positions.
Ability to analyze and report credit exposure across diverse portfolios and sectors.
Proven expertise in implementing operational risk frameworks, including RCSA (Risk Control Self-Assessment), scenario analysis, and key risk indicator (KRI) monitoring.
Understanding of market risk concepts such as Value-at-Risk (VaR), stress testing, and sensitivity analysis.
Familiarity with market risk tools like Bloomberg Terminal, Reuters, or similar platforms.
Proficiency in SQL, PL/SQL, and data warehousing tools for managing and analyzing large financial datasets.
Knowledge of enterprise risk management systems and tools (e.g., SAS, Moody’s Analytics, or similar).
Senior Data Steward
National Bank of Canada —Montréal, QC3.9
Opportunities to get involved in community initiatives. Join a multidisciplinary team whose mandate is to ensure the delivery of value as part of the…
Your job:
Work closely with data owners from multiple domains – Funding, Cards, Contact Center, Performance Management and more – and apply best practices in data governance and management
Participate in the governance of strategic initiatives in the Credit Risk domain (ACDC, PRR, Evo-Eco, Automated Contacts, etc.) and collaborate with stakeholders by analyzing impacts on data requirements
Provide leadership in data quality improvement and management throughout the data lifecycle (e.g. setting targets and thresholds, dashboard, etc.)
Identify the needs of data consumers and make recommendations with the data owner
Prerequisite:
2 to 3 years of experience in risk modeling, data architecture, or any other field related to data management.
Mastery of data in the Credit Risk domain (Credit Decision, Credit Bureaus, Collection and Collection, etc.)
Ability to adapt and evolve in a dynamic environment of transformation
Experience with a data visualization tool such as Excel/Power BI
Knowledge or experience in SQL/SAS programming.
数据分析专题文章
用Excel深度剖析零售数据，解锁业绩增长密码
2025年8月12日
AI时代的数据分析师：从工具到思维，如何用技术重塑你的工作方式？
2025年7月24日
数据可视化革命：Tableau一键引爆？
2025年7月1日
Python for Office Automation
2025年6月17日
Excel data analysis: Risk management
2025年6月3日
Frustrated ! Self study data analysis
2025年5月22日
How to find Job in Big 5 Canadian Banks
2025年5月22日
你也可以成为AI提问师
2024年10月31日
Data Analysis-Comparison analysis
2024年10月31日
