Intern - Data Analytics

At Halton Region, we treat everyone with respect, honesty, fairness and trust. As an equal opportunity employer, we are committed to establishing a qualified workforce that is reflective of the diverse population we serve. Halton Region is committed to providing accommodation to individuals with disabilities throughout the recruitment process.

Looking for an exciting job opportunity that will launch your career? Halton Region’s internship program provides a paid one-year professional opportunity that allows you to gain valuable experience and build the skill set you need to build a successful career. As an intern at Halton, you will gain professional growth and development working alongside your mentors. You will be part of a progressive, service-focused and award winning employer.

As an employer of choice, Halton Region recognizes the many benefits of hybrid work arrangements including flexibility and better work-life balance for our employees. Where the work permits, employees will have the choice to work where they can have the greatest impact on achieving our goals. Please note, this position is eligible for our Hybrid Work Program/Work from Home Arrangement.

Posting ID: 1596
Department: Digital & Information Services
Division: Digital Services & Data Management
Compensation: $47,392 + 3 weeks paid vacation

Job Type: Intern
Contract Duration: June 5, 2023 - May 31, 2024
Hours of Work: 35 hours per week
Work Location: Halton Regional Centre - 1151 Bronte Road, Oakville
Employee Group: OCT
Posting Date: February 1st, 2023
Application Deadline: February 21, 2023

Job Summary

The Data Analytics Intern will provide organizational data services to support the delivery of strategic priorities. The successful candidate will assist in developing and supporting emerging data opportunities and have the opportunity to work with experts in the field, and contribute to a positive workplace culture.

Duties & Responsibilities

Provide organizational data services by collecting, managing, integrating, sharing, and reusing high-quality data to inform strategic decisions and support the delivery of Halton's strategic priorities
Assist in developing and supporting emerging opportunities in big data, database administration and data visualization
Work with Application Development team as needed to set up development databases and for Production migrations
Document database workflows, processes and procedures
Track and resolve database related incidents, alerts and requests
Work with internal clients to understand, developtechnical solutions to business problems
Work with the Database Administrator to manage and maintain Halton's corporate relational database management systems (RDBMS)
Perform other duties as assigned

Skills & Qualifications

Essential

Post-secondary university/college program in Engineering, Computer Science, and Math, Database Administration or related field
Experience with Python
Building analytical dashboards using PowerBI
Understand the general machine learning process from data engineering, feature creation, basic modeling, validating
Experience in SQL/SQL Server (TSQL/PLSQL) scripting skills, building joins, views, transformations
Strong communication skills and an ability to communicate complex data to non-technical audiences
Strong data visualization skills using a variety of tools, including Microsoft Word, Excel, Python, PowerBI
Ability to work effectively, both independent and within a team environment

Preferred

Experience using Apache Spark
Knowledge of Databricks & Delta Lake
Experience with cloud computing solutions such as Azure or AWS
Experience with source control management tools such as Github/Azure DevOps
Understanding of how to work with diverse groups of clients to develop reporting and analytics KPIs
Experience working in a database administration, database architecture, or database developer capacity
Awareness of PII protection and security
Coursework or certification in Big Data Analytics, Database Administration or Data Science

Working/ Employment Conditions

Employment Conditions

Current (obtained within the past six (6) months), original and acceptable Criminal Records Check, by the first day of employment.
In support of the Region’s commitment to a healthy and safe workplace and community, the Region has a vaccination requirement for all employees. The successful candidate will be made an offer of employment on the condition of being fully vaccinated against COVID-19 and able to provide proof of vaccination. The candidate will be asked to provide the Region with proof of full vaccination, prior to their employment start date. The requirement to be fully vaccinated is subject to the Ontario Human Rights Code. If the candidate is unable to vaccinate for a reason protected by the Code, a request for accommodation can be requested and written proof satisfactory to the Region will be required.

Important information about your application:

In accordance with requirements in Ontario Regulation 191/11 – Integrated Accessibility Standards and the Ontario Human Rights Code, Halton Region will accommodate the needs of individuals with disabilities throughout the recruitment process. If you require accommodation at any stage of the recruitment process, please inform the Talent Acquisition representative of the nature of the accommodation(s) you require.
Please submit your application online. We will accommodate individual needs for applicants with disabilities and others who are not able to apply online. If you experience any issues with submitting your application, please contact HR Access at 905-825-6000 extension 7700.
Applications will be accepted until 11:59 p.m. on the deadline date specified on the posting.
We encourage applications from all qualified individuals; however, only those under consideration will be contacted.
Personal information collected through the job application process will only be used for the purpose of determining qualifications for employment.
If selected for an interview, you will be contacted by email and/or phone. Please ensure the contact information provided on your resume is up to date and that you check your email and voicemail regularly.

Halton Region serves more than 595,000 residents throughout Burlington, Halton Hills, Milton and Oakville. We are committed to the delivery of high quality programs and services that make Halton a great place to live and work. We engage great people who contribute to meaningful work that makes a positive difference in our community.

Opportunities from Halton Region

New Opportunities

Intern - Data Analytics