Data Analytics: Database creation and SQL Integration
![Vancouver School of Economics (VSE) Career Centre](https://riipen-platform2-ca-central-1-production.s3.ca-central-1.amazonaws.com/uploads/company/9557/avatar/medium-40135430-0130-493f-a719-21497575f0fe.jpeg)
Project scope
Categories
Project management Information technology DatabasesSkills
critical thinking data maintenance vse (operating system) interpersonal communications python (programming language) java (programming language) detail oriented sql (programming language) microsoft sql servers data analysisIntroduction
The VSE Career Centre is seeking students that are interested in developing and implementing a sustainable database in Microsoft SQL for easy data analysis using Python (or other analytics software). Students will also be responsible for creating thorough documentation on database maintenance and database utilization.
Students would have the opportunity to
· Familiarize themselves with the data analytics industry standard of Microsoft SQL
· Research and propose optimal database maintenance practices, ensuring the sustainability of the database
· Create thorough documentation and train others how to maximize the utility of the SQL database.
· Offer insight into future digital needs of the VSE Career Centre
We’re looking for someone like you if:
· You are passionate about data analysis and furthering your personal knowledge in this area
· You are a critical thinker with an ability to analyze and design sustainable practices
· You are hungry to sharpen your SQL and Excel skills
· Your attention to detail and data management abilities are strong
· You like working in a team environment and are receptive to feedback
· You are patient and adaptable in teaching, able to guide others through more technical processes effectively
Qualifications:
· Excellent writing and communications skills, particularly the ability to write clearly and professionally
· Intermediate knowledge of Excel, SQL, and general database structure preferred
· Intermediate knowledge of at least one programming language (Python, Java, etc.) preferred
· Excellent attention to detail and organizational skills
Excellent ability to simplify abstract concepts and interpersonal skills
- Students will report directly to the VSE Career Centre Director
- Training, guidance, and mentorship will be provided by the Director and the VSE Career Centre Staff
About the company
The VSE Career Centre is a University of British Columbia (UBC) based centre, which takes a holistic approach as a career resource centre to support Bachelor of International Economics (BIE) students to think critically. Students are supported with their professional and personal development from self-discovery stage to by providing career coaching services and resources. Additionally, we work to build long-lasting relationships with employers, businesses and other key stakeholders to help BIE students become the top choice for recruiters in various industries.
Institutions
![Riipen Strategic Projects (1.0)](https://riipen-platform2-ca-central-1-production.s3.ca-central-1.amazonaws.com/uploads/portal/726/avatar/xsmall-07e98049-f92d-46b2-b2ce-8b91ca4196e9.png)
![Riipen Strategic Projects (1.0)](https://riipen-platform2-ca-central-1-production.s3.ca-central-1.amazonaws.com/uploads/portal/726/avatar/xsmall-07e98049-f92d-46b2-b2ce-8b91ca4196e9.png)