酒店预订数据分析报告（Pivot Table 实战案例）
2025年9月10日
2025-09-08 The Latest Job Description
2025-09-08 The Latest Job Description
Research Data Analyst MAP Drug Checking Services
Unity Health Toronto —Toronto, ON4
Provide technical expertise and lead the development of data visualizations on the composition of the unregulated drug supply for both internal purposes and…
$41.94–$52.43 an hour
Responsibilities and activities
Extract, clean, manipulate, organize, and analyze program data using data analysis software applications, such as Excel, R, and other programs as needed
Identify and keep the program’s central team apprised of issues and errors related to data collection, management, and analysis
Develop processes to aggregate data collected and generated from a variety of drug checking programs that use a variety of distinct drug checking technologies
Provide technical expertise and lead the development of data visualizations on the composition of the unregulated drug supply for both internal purposes and public dissemination (primarily by way of the program’s website) using Excel, Tableau, and other programs as needed
Develop reports for regulators (i.e., Health Canada’s Office of Controlled Substances) related to program activities
Qualifications, knowledge, and skills
Bachelor’s degree
Proficiency with statistical analysis in an applied setting using R, SAS, or a similar application required
SQL experience required
2 – 4 years of experience as a data analyst, including hands-on work with data cleaning, statistical
Proficient with MS Office (Word, Excel, PowerPoint, Outlook, etc.) required
Consultant, Fraud Analytics
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
Analytics – Conduct advanced analysis to support Quality Assurance group and Fraud investigation group with analytics and reporting for their 2nd Line of Defense processes for all retail lending products. Develop risk indicators and identify populations for further review. Ensure the accuracy and integrity of data and analytic results
Data Management –Design solutions to support the automation of processes and reporting. Manage large data sets and maintain databases such as Access, SAS, SQL.
Reporting – Perform data aggregation and develop and deliver dynamic and visually appealing reports and dashboards to outline issues and influence decisions.
Who you are
You demonstrate experience. 2+ years’ experience in data analytics roles in the banking industry. Proficiency with analytics and reporting tools such as SAS and SQL. It’s an asset if you have knowledge of retail lending data, systems, processes and procedures. Proficiency with Python, Tableau, Access Database a strong asset.
You have a degree. In Finance, Mathematics, Statistics, and/or related field.
Consultant, Automation & Analytics
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: Understand the business requirements and translate them into system and application design that is aligned with our technology roadmap. Design and document the technical functionality, infrastructure, interfaces and integrations..
Strategy and Roadmap: Contribute to technology roadmaps that are aligned with the bank’s vision, strategy, and business objectives.
Who You Are
You can demonstrate 3-5+ years 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, Oracle, SQL Server), Cloud (Azure, AWS), ETL (Informatica, SSIS
You embrace and champion change. You are passionate about being on top of technology trends. You’ll continuously evolve your thinking and the way you work in order to deliver your best.
You’re digitally savvy. You seek out innovative solutions and embrace evolving technologies. You can easily adapt to new tools and trends.
You have a degree/diploma: Bachelor’s degree , MBA or Master degree with specialization on Advanced Analytics, ML or AI is considered a plus.
Bilingual Senior Specialist, Lending portfolio monitoring
CMHC —Ottawa, ON3.8
Familiar with credit risk or enterprise-wide risk initiatives, and advanced analytics techniques such as supervised learning, NLP, time series analysis, and A/B…
$101,639.30–$127,049.13 a year
What you’ll do:
Monitor and assess credit risk and performance on the lending portfolio, ensuring alignment with risk appetite and regulatory standards, while evaluating effects on portfolio quality, loss provisioning,
Champion stress testing and scenario analysis, including impacts on expected and unexpected losses.
Transform raw credit and financial data into actionable insights that support strategic decision-making and risk mitigation.
Develop compelling data narratives and visualizations to communicate financial risk trends (notably credit risk), emerging exposures, and business impact.
What you should have:
A bachelor’s or master’s degree in Economics, Finance, Statistics, or a related quantitative discipline.
A minimum of 7 years of experience in credit risk management, financial analysis, and portfolio monitoring.
A strong understanding of financial risk (credit, market, liquidity, and capital), including the distinction between expected and unexpected loss, and the ability to translate data into strategic insights.
A deep understanding of mortgage-secured lending, the Canadian construction market, housing economics, and macro indicators, with the ability to relate these to portfolio-level lending risk.
Experience in monitoring loan performance, assessing loan loss provision (capital) sufficiency, and supporting risk-based decision-making.
Hold a recognized professional designation such as CFA or FRM.
Demonstrated experience with data visualization tools (e.g., Power BI, Tableau) and proficiency in Microsoft Azure environments like Databricks.
Skilled in a broad range of analytics tools and languages, including SAS, Python, R, Hive, Alteryx, and SQL.
Modelling / Forecasting Senior Analyst 3841
TD Bank —Toronto, ON3.7
In this position, the individual will be responsible for the development, initial validation, documentation, and support in all stages of audit, implementation…
The individual will use leading-edge technologies in the following areas:
Data mining by making sense of large databases of historical data related to credit risk
Predictive credit risk modelling based on rigorous statistical analyses of historical data, regression techniques, and econometric analyses
The predictive models leverage both traditional statistical techniques as well as the new AI and machine-learning methodologies
Job Requirements :
A university degree
Hands-on experience using programming languages such as SAS, SQL, Python, R, MATLAB in the context of data manipulation, data mining, statistical analysis, and predictive modelling
Strong knowledge of modern statistical model development and validation concepts and techniques (particularly linear and logistic regression)
3+ years of work experience in the retail banking industry,
A solid knowledge of concepts and methodologies used in Expected and Unexpected Loss, Allowance, Economic Capital, and regulatory stress testing for retail credit exposures
3+ years of experience with retail credit risk data, analytics, and risk modelling
A solid knowledge of Basel III requirements, including hands-on experience in developing and implementing Basel II Retail AIRB models
Data Analyst – Digital Reporting
Intact —Toronto, ON3.6
Work in collaboration with project team members, leading the development of new reports using Power BI. The ideal candidate is eager to grow alongside us and…
What you’ll do here:
Create and publish reports.
Monitor, identify, and analyze trends, explaining outliers and providing influential feedback
Consolidate data from various sources, ensuring data is clean.
Build and maintain an inventory of data and support the monitoring of KPIs.
Proactively identify new data elements that may provide further insight into performance or business
Create and maintain effective documentation to assist in training
Work with project team members, leading the development of new reports using Power BI.
What you bring to the table:
Post Secondary education – is required
Minimum 2-years experience in data analyst or reporting frameworks – is required
Knowledge of SQL, Snowflake, SAS, Databricks and Python – is required
For candidates located in Quebec, bilingualism is required
Senior SAS Data Engineering Developer
National Bank of Canada —Montréal, QC3.9
Opportunities to get involved in community initiatives. We work closely with our partners, which will help you develop your business knowledge of managing…
Your job
Participate in the development of structured and unstructured business data acquisition solutions
Support the implementation of data environments that allow analysis for business intelligence, advanced analytics and artificial intelligence purposes
Develop and test data ingestion processes
Produce reconcile and control data and their quality indicators
Collaborate with stakeholders and the Credit and Climate risk Analytics, Disclosure and Data quality and Governance teams
Communicate and explain complex technical concepts to users of analytical platforms.
Prerequisites
3 to 5 years of experience in data engineering
Experience in data manipulation, analysis and prototyping
Experience in risk management (credit, market, operational, etc.), an asset
Expertise in several data manipulation languages: SAS, SQL, and/or Python.
Data Analyst (Programming Team)
NMG Consulting —Toronto, ON
Interact proactively and positively with programme managers and colleagues from other areas of NMG to gain better understanding of the various programmes and…
Key Responsibilities
Analyse survey data using descriptive and inferential statistics (SAS);
Summarise analyses shown in static reports and interactive dashboards (PowerBI);
Manage survey data from different sources – face-to-face interviews, online and phone studies. This includes data import, storage, review and cleansing
Competencies, Qualifications & Experience
Hands-on experience in using MS Power BI, and related MS technologies and have at least 1 year of practical knowledge of SAS (Base or EG) and in using SQL and macros. Practical experience in SAS is a MUST
Experience in the gathering and documenting of business logics/methodologies, analysing and reporting survey data
Strong visualisation skills (dashboard and/or graph designing) and academic performance
Knowledge in other programming languages like Python and R with UI/UX experience
HEALTH INFORMATION ANALYST
City of Toronto —Toronto, ON4.1
Orients staff to available databases and the use of population health information in program development, monitoring and evaluation.
$40.69–$44.57 an hour
Posting Period: 04-Sep-2025 to 18-Sep-2025
Major Responsibilities:
Designs and maintains new health information systems and databases and extracts data from existing databases to create relevant datasets for subsequent analyses
Develops documentation and procedures for health information systems
Coordinates existing health information including updating datasets and deriving new variables,
Adheres to Divisional and other statistical standards for data analysis, mapping and reporting, and complies with the conditions set out in all data licences
Writes and executes computer programs for data extraction, data set creation and analysis using spreadsheets and statistical software packages (e.g., Excel, Access, SAS, STATA, R)
Prepares and disseminates health status information in various forms including reports, charts, graphs, maps and community health profiles based on analysis of existing or generated data
Designs data collection and survey instruments including coding formats, questionnaire design and data entry and storage
Key Qualifications:
University degree in Health Sciences, Biostatistics,
Considerable experience using statistical software to conduct analyses of large health data sets, including SAS, STATA, R or equivalent.
Considerable experience applying population health statistical methods and in the collection, analysis, communication, and interpretation of disease data
Experience using ArcGIS and data visualization tools e.g. Tableau
Strong customer service, communication, and consulting skills
Familiarity with current public health issues, epidemiological concepts, trend analysis and forecasting techniques
Analyst, Health System Funding
Ontario Health —Toronto, ON3.3
3 years of experience in health services research, health system performance, community care, or population health, OR. A premium defined benefit pension plan.
External Application Deadline Date: September 18, 2025
Here is what you will be doing:
Contribute to analytics and reporting across the Health System Performance and Support portfolio.
Support system and sector reports, patient experience measurement, and performance methodologies.
Conduct quantitative analyses of clinical, administrative, or survey data.
Complete ad hoc analysis requests and explore data for indicator development.
Ensure accuracy and completeness of reported data, figures, and tables.
Maintain documentation for quality indicators.
Identify data elements, datasets, and visualization approaches to support decision-making.
Here is what you will need to be successful:
University degree.
Minimum 1 year of experience using SAS (or similar statistical software) for analysis, database development, or reporting.
Strong knowledge of MS Excel.
3 years of experience in health services research, health system performance, community care, or population health, OR
2 years of experience working with administrative and/or clinical data in the Ontario context.
数据分析专题文章
用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日
