酒店预订数据分析报告（Pivot Table 实战案例）
2025年9月10日
2025-09-30 Data analyst JD
2025-09-30 Data analyst JD
ANALYST, EDUCATION DATA AND RESEARCH
CMEC Council Of Ministers of Education, Canada —Remote
Support expert-level sessions and work (e.g., item development, provincial and territorial reviews) and develop corresponding materials or outputs (such as…
$64,513–$90,181 a year
Key responsibilities
Support the development, implementation, and interpretation of education data indicators
Coordinate and conduct data collections for national and international surveys
Work with partner agencies, such as Statistics Canada, to support and advance current joint projects, such as the Pan-Canadian Education Indicators Program (PCEIP)
Conduct data analysis and reporting on education trends across Canada (these can involve large-scale data sets and the production of notes for education decision-makers and other interested parties)
Required:
Bachelor’s degree in a field emphasizing both qualitative and quantitative analysis,
Proficiency in Excel and statistical software (e.g., SAS, SPSS), with experience analyzing large data sets
Familiarity with Canada’s education systems and intergovernmental processes
Experience with survey development or large-scale assessments
At least two years of experience with data projects, including analysis and report writing preferablly within the education sector or goverment instutions
Skills in coding (e.g., Python, R) and data visualization (e.g., Power BI, Canva)
Bilingualism in English and French, both written and spoken (candidates may be asked to provide writing samples). The successful candidate may be asked to enrol in a language program, if applicable
Marketing Database Analyst
CAA Club Group —Thornhill, ON3.2
Continuous learning through our robust corporate curriculum and education reimbursement program,. Bachelor’s degree in Mathematics, Statistics, Analytics,…
We regret that those without hands-on SAS or SQL experience will not be considered for the role.
What you will do-
Provide practical assistance in analytical data investigation, validation and implementation.
Support the Supervisor of Marketing Analytics & Insights in quarterly request intake and project conversion process by clarifying and aligning on campaign objective and targeting criteria.
Pull campaign lists by using SAS/SQL scripts and ensure waterfalls are signed off, lists are error-free and delivered on time.
Develop robust and user-friendly Power BI reports and dashboards for campaign performance measurement.
Monitor and analyze campaign variances and performance trends
Conduct post-campaign analysis to evaluate the effectiveness of marketing programs
Who You Are
Bachelor’s degree in Mathematics, Statistics, Analytics, Engineering or Commerce.
3+ years of analytics experience in database marketing, marketing analytics, campaign management, hypothesis testing and experimental design.
3+ years of SAS or SQL programming with enterprise-level database.
3+ years of BI reporting and visualization tools such as Microsoft Power BI or Tableau.
SAS Certified Advanced Programmer (SAS 9) is an asset.
Hands-on experience of SSMS (SQL Server Management Studio) and T-SQL is an asset.
Hands-on experience of Environics Prizm and Envision is an asset.
(3)https://www.workopolis.com/search?q=sas&l=canada&s=d&job=QYBxptBuxM9XPYmkW19EvTopxLFvPdij9IEjricjJCOXYSbXygvF6xy5adltGzA2
Senior Treasury Analyst – Internal Controls
TD Bank —Toronto, ON3.7
Total Rewards at TD includes a base salary, variable compensation, and several other key plans such as health and well-being benefits, savings and retirement…
$76,800–$115,200 a year
Job Description:
This Senior Treasury Analyst provides planning, forecasting, reporting and financial analysis support for assigned line(s) of business and/or at the total segment level under the guidance of financial management. In addition, The Financial Analyst III provides highly specialized financial consulting and analytical support at the assigned line(s) of business or total segment level identifying key emerging financial trends, measurement of key performance metrics and success factors, line of business and total segment financial target setting and measurement, capital budget and key initiative evaluation and planning, cost and product profitability analyses, specialized reporting and support for special projects.
Preferred Qualifications
Strength in supporting governance and control activities in Treasury, Change Management, Risk Management, and Internal Control testing
Previous experience in public accounting, particularly in a BIG 4 firm, is a definite plus
Hands-on experience in substantive testing, advanced Excel proficiency, and coding skills in VBA, R, Python, SQL, and SAS
SAS Coding preferred
Regulatory and liquidity reporting experience
Familiarity with Atlassian Suite Administration tools like Confluence, JIRA, and Bitbucket,
Experience BI Tools such as Tableau, Alteryx, Power BI, and SAS VA is beneficial
Experience in process automation/optimization, the ability to simplify and streamline processes, and expertise in data visualization
Bachelors degree or progressive work experience in addition to experience below
5-7 years related experience required
In-depth knowledge of financial analysis, financial model-building and interpretive statistics
Homelessness Reduction Innovation – Evaluation Specialist – Contract Full-time
Homeward Trust Edmonton —Edmonton, AB2.9
Degree from a recognized post-secondary institution with a focus on social sciences, humanities, urban planning, community development or related disciplines…
Duties and Responsibilities
In collaboration with the data and program teams, develop and implement an evaluation plan that aligns with HRIF expectations and Homeward Trust’s strategic goals.
Design logic models, indicators, and data collection methods to measure the impact of both pilot components (Landlord Engagement Accelerator and Rapid Housing Reserve Fund)
Support the collection and analysis of quantitative data, including program and finance data.
Collaborate with the Landlord Relations and the Data & Analytics teams to regularly review collected data, ensuring quality, completeness, and accuracy.
Prepare and submit quarterly narrative and financial reports in collaboration with the Project Administrator and other Homeward Trust internal teams.
Education and Qualifications
Degree from a recognized post-secondary institution. A Master’s level degree is preferred.
Minimum 3 years experience as a policy analyst, evaluation specialist, information analyst, or research analyst in the public or non-profit sector.
Prior work with evaluation frameworks, logic models, outcomes measurement, and basic statistical analytic methods is required.
Sound working knowledge of basic qualitative and quantitative statistical methods is required.
Excellent proficiency with Excel software, including ability to conduct basic quantitative data analysis, use of statistical functions, and advanced charting/presentation abilities (pivot tables, vlook up etc.)
Proficiency in SQL, Tableau, and experience with programming languages (ex: Java/python, SAS) an asset.
Data internship, Winter 2026
Desjardins —Montréal, QC3.8
Your educational institution must credit or certify your internship toward a bachelor’s degree or a master’s degree in an appropriate discipline.
Responsibilities
Help deepen our understanding of members and clients via data analysis and valorization
Develop reports (visualizations) and make recommendations to meet the needs of internal partners
Take part in exploring, evaluating and developing innovative AI methodologies and products to support data valorization
Help innovate and explore in one of our areas of expertise, like structured and unstructured synthetic data, generative and multimodal language models, etc.
Work alongside data scientists and IT experts on a multidisciplinary squad to design, develop, deploy and monitor machine learning and AI systems
Document metadata in the information governance catalogue
Design, develop, automate and support complex applications to extract, transform and load data
What you bring to the table
Your educational institution must credit or certify your internship toward a bachelor’s degree or a master’s degree in an appropriate discipline.
Knowledge of French is required
Proficiency in software development, including object-oriented programming for machine learning engineering (MLOPS)
Knowledge of tools such as Tableau and Power BI for information analytics
Knowledge of SAS and SQL for information analytics
Knowledge of machine learning algorithms, deep learning and development frameworks (keras, tensorflow, pytorch, etc.) for advanced analytics
Knowledge of generative AI models and solutions (synthetic data, LLMs, prompt engineering, etc.) for advanced analytics
Knowledge of the office suite (in particular Excel) for data governance
Sr. Analyst, Business Intelligence- Financial Crimes
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.
$86,000–$160,000 a year
Skills:
7+ years of experience within Data Analysis and Business Intelligence
Strong experience in partnering with business stakeholders to understand the problem and identify enhancement opportunities using data.
5+ years of experience with SQL and/or SAS programming to extract, transform, and clean large data sets.
Knowledge in Data Science languages like Python, Random Forest is a plus
Strong understanding technical design– able to dive into the business process to understand the current vs. future state
5+ years of expertise in Data Management – data extraction, cleaning, and transformation
5+ years of expertise data analytics techniques
5+ years of expertise data flows, systems.
5+ years of expertise data designs
TOP/MAIN Responsibilities:
Designs dashboards and analyses to be performed, and appropriate visualization and analytics tools to use. Identifies trends and patterns to address identified business questions and provide insights through reporting and data visualization techniques.
Builds various reporting dashboards using the most appropriate data extraction, data cleaning and data visualisation techniques.
Researches and applies continuous improvement in data visualization by identifying trends and patterns to transform raw data into actionable business insights.
Translates business needs to technical specifications and evaluates existing data visualization systems in order to improve them.
Documents data flow, systems and processes to improve the design, implementation and management of business/group processes.
Develops tools and delivers training programs for use of reporting tools and self-serve analytics by non-analytical end users; may include delivery of training to audiences.
Research Methods Specialist – Institute for Mental Health Policy Research
Centre for Addiction and Mental Health —Toronto, ON3.9
Experience conducting online and remote recruitment and intervention-delivery involving hard-to-access populations is required, as is demonstrated knowledge of…
$42.67–$57.55 an hour
To view our Land Acknowledgment, please click here.
IMHPR is currently seeking a Research Methods Specialist, directly reporting to a Senior Scientist, will primarily be responsible for a range of research-related duties that will support the development, implementation, and evaluation of research investigations. The Research Methods Specialist will make direct contributions to the methodological design of studies, take part in statistical and methodological aspects of running of research investigations, manage large databases, and conduct high-level statistical analyses using statistical software packages that include SPSS, SAS, R, and MPlus. This position will also entail making significant contributions involving methodological and statistical aspects to the preparation of ethics review board protocols, grant proposals, manuscripts, and reports to funding agencies and government entities.
Job Requirements
The successful candidate will have at minimum an Honours Bachelor’s Degree in Statistics, Psychology, or a related field, and a minimum of 5 years of related experience with research, preferably in a university department or academic hospital setting. Previous experience conducting research in the field of mental health and addictions is preferred, and experience conducting research with HIV-positive populations and with sexual minority men is required. Experience conducting online and remote recruitment and intervention-delivery involving hard-to-access populations is required, as is demonstrated knowledge of qualitative and quantitative research methodological approaches (e.g., randomized controlled trials; online surveys and interventions; community-based research; chart extraction, focus groups and interviews) and advanced statistical analytic skills, including mixed effects modelling, structural equation modelling, survival analysis, and multivariate analysis of variance. You will have been trained in research methods and statistical analysis, and possess demonstrated knowledge and proficiency in Microsoft Office (including Word, Excel, and PowerPoint); software packages and computer programming languages used for the development and administration of surveys and psychological experiments (e.g., Qualtrics, Redcap etc.); and statistical packages including SPSS, SAS, R, and MPlus. Candidates will have demonstrated ability to manage and analyze large databases. Previous experience in the grant application process regarding methodological and statistical aspects will be considered an asset. Leadership and team collaboration skills are essential as well as a proactive attitude and a willingness to be committed to and strive for continuous improvement. Bilingualism (French/English) and/or proficiency in a second language is an asset.
Consultant, Advisors & Consulting Services, Performance Analytics
Mastercard —Vancouver, BC4
Our Performance Analytics consultants translate data into insights by leveraging Mastercard and customer data to design, implement, and scale analytical…
$86,000–$129,000 a year
Title and Summary
Services within Mastercard is responsible for acquiring, engaging, and retaining customers by managing fraud and risk, enhancing cybersecurity, and improving the digital payments experience.
The Advisors & Consulting Services group has five specializations: Strategy & Transformation, Performance Analytics, Business Experimentation, Marketing, and Program Management. Our Performance Analytics consultants translate data into insights by leveraging Mastercard and customer data to design, implement, and scale analytical solutions for customers. They use qualitative and quantitative analytical techniques and enterprise applications to synthesize analyses into clear recommendations and impactful narratives.
Qualifications
Undergraduate degree with data and analytics experience in business intelligence and/or descriptive, predictive, or prescriptive analytics
Ability to analyze large datasets and synthesize key findings
Proficiency using data analytics software (e.g., Python, R, SQL, SAS)
Advanced Word, Excel, and PowerPoint skills
Ability to perform multiple tasks with multiple clients in a fast-paced, deadline-driven environment
Additional data and analytics experience in building, managing, and maintaining database structures, working with data visualization tools (e.g., Tableau, Power BI), or working with Hadoop framework and coding using Impala, Hive, or PySpark
Ability to analyze large datasets and synthesize key findings to provide recommendations via descriptive analytics and business intelligence
Health Analyst
Public Health Ontario —Toronto, ON3.7
Knowledge of stakeholder groups, building public health, research, academic, institutional, and professional networks, and working at local, provincial/…
$67,932–$95,107 a year
key Responsibilities-
Analyzes, interprets and develops reports of health data using appropriate methods in response to inquiries from Digital and Data Portfolio colleagues and PHO staff.
Conducts the routine analysis of large data sets for the interpretation and production of basic population health assessment and surveillance reports.
Prepares and disseminates health status and surveillance information in various formats including reports, charts, graphs, maps and community health profiles.
Writes and executes computer programs for data extraction, data set creation and analysis using spreadsheets and statistical software packages (e.g., Excel, SAS, R, Python).
Maintains electronic access to data holdings, information systems and appropriate interfaces to ensure
Knowledge and Skills-
Familiarity with public health information systems such as the Integrated Public Health Information System (iPHIS) and ability to work with large data sets and utilize a range of information systems.
Skilled in the use of data sets, spreadsheets, databases, statistical packages and BI tools such as Cognos, SAS, R, and Python.
Knowledge of population health indicators, epidemiological concepts, public health research, statistical analysis, health analytic methods, and techniques to analyze data, (including trend analysis using any statistical software).
Knowledge of recognized health data and information standards and coding (e.g., SNOMED, ICD)
Knowledge of current public health issues related to communicable diseases and emergency preparedness.
Bachelor’s degree in health sciences, biostatistics
Minimum of two (2) years of experience in the collection, collation, analysis and interpretation of health data.
Associate, Risk Modelling
Hyundai Capital Canada —Toronto, ON
Position Details: *This role supports the development, maintenance, validation, and governance of all Risk models at HCCA including, but not limited to,…
Duties and Responsibilities:
Develop, enhance, and replace risk models using analytics, ML, and AI.
Deploy models in areas such as credit risk forecasting, residual value, pricing, and ROA assumptions.
Prepare documentation, secure governance approval, and share best practices with HCA.
Analyze monthly movements and forecast outputs; review PD, LGD, Prepayment, and ECL models quarterly.
Monitor lease and loan scorecards, set thresholds, and validate performance quarterly.
Provide ad hoc risk analysis and cross-functional project support.
Stay current with accounting standards, industry practices, and macroeconomic trends impacting models.
Work Experience:
2+ years of predictive modelling experience in the financial services industry.
Risk management experience highly preferred.
Bachelor’s degree in Statistics, Mathematics, Business Administration, Economics, Operations Research,
Strong understanding of statistical modelling techniques (e.g., generalized linear models, logistic regression).
Proficiency in Python, SAS, SQL, Excel, Word, PowerPoint, and relational databases.
Experience with machine learning models preferred.
Knowledge of IFRS 9, credit loss methodologies, and scorecard techniques preferred.
数据分析专题文章
用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日
