Contract Full Time
WHO WE ARE
Founded in 1911, Appleby College’s mission is to educate and enable young men and women to become leaders of character, major contributors to, and valued representatives of their local, national, and international communities.
Appleby inspires its 765 students from grades 7 to 12 to pursue their individual passions through an internationally recognized and innovative academic, athletic, and co-curricular programme that has been founded on the school’s six Pillars of Strength: Academically Vital, Technologically Empowered, Universally Diverse, Community Spirited, Actively Engaged and Globally Responsible.
Appleby’s model of educational excellence enables and encourages its students to learn and discover independently and collaboratively, both inside and outside of the classroom.
Appleby offers the prospect to be part of a high performing team that fosters an inclusive culture with opportunities to collaborate with other inspiring minds. Working at Appleby means that you value diversity, have integrity, and are committed to learning and professional development. We provide an outstanding educational experience to our students by having an exceptional team. Appleby’s foundation for success is attracting and retaining employees who thrive in our dynamic culture that recognizes individual strengths and talents. Breadth, excellence, innovation and caring – this is what defines the essence of the Appleby team.
WHAT WE WANT – THE ROLE
The Data Analyst will work within a service-orientated, technology team to deliver a range of data related services, including data integrity and data quality assurance. The Data Analyst will also retrieve data from multiple sources and process confidential information, create and analyze report and provide end user training for data related applications;
The accountabilities include:
Acts as key resource for data integrity across the School and collaborates with other internal departments to provide training/expertise to ensure a distributed model for data usage.
Imports, cleans, transforms, validates and models data to improve data quality and to ensure the accuracy, currency and integrity of data
Identifies, analyses, and interprets trends or patterns in complex data setting
Understanding and managing data and data integrity; including creation, updates, and deletion.
Provide quality assurance of imported data.
Processing confidential data and information according to guidelines.
Produces ongoing and ad hoc reports and dashboards that identify issues, provide insight into results and outline recommendations for process improvements to resolve operational, business and system issues.
Helping develop reports and analysis.
Effectively retrieve and aggregate data from single or multiple sources
(databases, excel, csv, etc.), compile and interpret data into actionable formats.
Assistance with data exploration and analytics.
Training end users on new reports and dashboards.
WHAT YOU NEED
Post-secondary education in a related discipline, or a combination of education, training and experience deemed equivalent.
Minimum three (3) years’ experience in a Data Analyst or similar role
Excel and Analytical experience (data quality experience also an asset)
Knowledge and/or exposure to SQL and Joins systems
Experience with BI tools, such as Power BI, Tableau
Experience with Blackbaud database systems is an asset.
Creative problem solver and active listener with an ability to work with stakeholders to gather requirements.
Demonstrated experience in working with relational databases: Proficient at writing SQL queries against complex databases for the purpose of data extraction.
Demonstrated advance experience in working with Excel in manipulating data.
Analyzing data and building reports to present results.
Verbal and written communication skills to prepare reports, update and brief management; provide information and explanations of a technical nature to a range of internal stakeholder
Critical-thinking skills to identify trends in data and provide insight into results and outline recommendations.
WHAT WE HAVE
Exciting, challenging and rewarding work opportunities
An atmosphere that promotes and encourages exceptional Professional Development
State-of-the-art facilities that motivate and engages employees
Located on a 60-acre campus on the shores of Lake Ontario
Active engagement in community involvement
Competitive compensation that will commensurate with skill and experience
HOW TO APPLY
If you are interested in joining our team; please connect with us by March 13, 2020
Your application matters to us and we will review it carefully. Only candidates selected for interviews will be contacted.
As a condition of employment, a criminal record check is required.
Appleby College website: www.appleby.on.ca
Appleby is committed to fostering an inclusive, equitable and accessible environment where everyone feels valued, respected and supported. Accommodations are available for applicants with disabilities throughout the recruitment process. While all applicants are thanked for their interest, only those chosen for interviews will be contacted.