Developer, Graduate

2 weeks ago

Old Toronto, Canada Pinnacle Fund Services Full time
p>Company description

Pinnacle Fund Services (“Pinnacle”) is a privately-owned company headquartered in Vancouver that provides high-quality accounting and administrative services to hedge funds, private equity funds, and other investment vehicles in Canada, the United States and internationally. Pinnacle provides clients with responsive service and provides employees with a dynamic workplace and career growth potential. p>

To support our growing business, Pinnacle is seeking candidates for a Junior Developer to join our Technology Team. p>

Job Description

The Junior Developer will be responsible for performing day to day querying and analysis using SQL queries and procedures, designing, developing and maintaining SQL databases, writing optimized SQL queries, and ensuring data quality and integrity.

The Junior Developer will also be responsible for developing and maintaining high-quality, scalable Python applications and APIs that will enable us to use cutting-edge solutions in delivering services to our clients.

Primary Responsibilities

  1. Design, develop, and maintain SQL databases and tables
  2. Write optimized SQL queries to retrieve, manipulate and transform data
  3. Create and modify database structures to support business requirements
  4. Ensure data quality and integrity through testing, validation, and error checking
  5. Develop and maintain ETL (Extract, Transform, Load) processes to move data between systems
  6. Develop, test, and maintain Python applications and APIs
  7. Write efficient, scalable, and reusable Python code
  8. Optimize Python code for performance
  9. Debug issues and troubleshoot errors in Python code
  10. Provide technical support and troubleshooting for SQL and Python related issues
  11. Develop and maintain documentation for databases, queries, processes and solutions
  12. Stay up-to-date with emerging trends and technologies related to SQL development
  13. Collaborate with cross-functional teams to gather requirements and develop solutions
  14. Foster a culture of customer service and continuous improvement among the IT Solutions team to enable effective support of business operations.
  15. Work with external consultants and developers on contract.

Desired skills and experience

  1. Bachelor's degree in Computer Science, Information Technology, or related field
  2. 2+ years’ experience of SQL, including complex queries, subqueries, and stored procedures
  3. 2+ years’ experience with database design and normalization
  4. 2+ years’ experience with ETL tools, such as SSIS
  5. Experience with cloud-based databases, such as Azure, is a plus
  6. 2+ years’ experience of Python and its standard libraries
  7. Experience with RESTful API design and development
  8. Experience with version control systems such as Git
  9. Familiarity with Microsoft PowerApps
  10. Demonstrated experience in requirements gathering and analysis.
  11. Strong knowledge in solution design principles and modular programming techniques.
  12. Strong analytical and problem-solving skills
  13. Excellent communication and collaboration skills
  14. Experience implementing automation solutions independently.
  15. Excellent organizational and multi-tasking skills, attention to quality, self-motivation and a strong desire to succeed.
  16. Strong knowledge of system and software quality assurance best practices and methodologies.
    • Extended Health Benefits
    • RRSP Employer Match Program
    • Competitive Compensation
    • Annual discretionary bonus
    • Educational Support
    • Work-Life Balance
    • Remote Firm, with some in-office days with purpose (learn, build relationships, collaborate & socialize)
    • Exposure to all aspects of the business

    Pinnacle is committed to creating a diverse and inclusive workplace and welcomes applications from all qualified individuals, regardless of race, ethnicity, gender, sexual orientation, age, disability, religion, or any other protected status.

  • Graduate Development Program Engineer

    1 month ago

    Old Toronto, Canada ASR Group Full time

    Redpath Sugar is located on Toronto’s historic downtown waterfront and has been a part of Canada’s heritage for more than 160 years. Our brand is the oldest food-related trademark in Canada and is recognized across the country. Redpath Sugar is part of ASR Group, the largest cane sugar refiner in the world.POSITION SCOPEThe Graduate Development Program...

  • Graduate Development Program Engineer

    1 month ago

    Old Toronto, Canada ASR Group Full time

    Redpath Sugar is located on Toronto’s historic downtown waterfront and has been a part of Canada’s heritage for more than 160 years. Our brand is the oldest food-related trademark in Canada and is recognized across the country. Redpath Sugar is part of ASR Group, the largest cane sugar refiner in the world.POSITION SCOPEThe Graduate Development Program...

  • Graduate Development Program Engineer

    4 days ago

    Old Toronto, Ontario, Canada ASR Group Full time

    About ASR GroupASR Group is a leading manufacturer of sugar products, with a rich history spanning over 160 years. Our brand is a well-known trademark in Canada, recognized for its quality and excellence.Graduate Development ProgramThe Graduate Development Program (GDP) is a two-year structured learning and development program designed for new graduates who...

  • Graduate Development Program Engineer

    4 days ago

    Old Toronto, Ontario, Canada ASR Group Full time

    About ASR GroupASR Group is a leading manufacturer of sugar products, with a rich history spanning over 160 years. Our brand is a well-known trademark in Canada, recognized for its quality and excellence.Graduate Development ProgramThe Graduate Development Program (GDP) is a two-year structured learning and development program designed for new graduates who...

  • Graduate Development Program Engineer

    1 month ago

    Old Toronto, Ontario, CA ASR Group Full time

    Redpath Sugar is located on Toronto’s historic downtown waterfront and has been a part of Canada’s heritage for more than 160 years. Our brand is the oldest food-related trademark in Canada and is recognized across the country. Redpath Sugar is part of ASR Group, the largest cane sugar refiner in the world.POSITION SCOPEThe Graduate Development Program...

  • Graduate Assistant

    2 weeks ago

    Toronto, Ontario, Canada Toronto Metropolitan University Full time

    Job SummaryToronto Metropolitan University is seeking a highly motivated and detail-oriented Graduate Assistant to support the academic and research endeavors of our institution. As a Graduate Assistant, you will play a vital role in assisting faculty members with various tasks, including teaching, research, and administrative duties.ResponsibilitiesAs a...

  • Graduate Sales Development Representative

    3 months ago

    Toronto, Canada SciLeads Ltd Full time

    Are you a recent graduate looking to start your career in sales? SciLeads is a fast-growing company focused on providing sales intelligence to the life science and pharmaceutical industry. We are looking for a highly motivated and driven Graduate Sales Development Representative to join our team. As a Graduate Sales Development Representative, you will be...

  • Graduate Sales Development Representative

    3 months ago

    Toronto, Canada SciLeads Ltd Full time

    Are you a recent graduate looking to start your career in sales? SciLeads is a fast-growing company focused on providing sales intelligence to the life science and pharmaceutical industry. We are looking for a highly motivated and driven Graduate Sales Development Representative to join our team. As a Graduate Sales Development Representative, you will be...

  • Graduate Sales Development Representative

    3 months ago

    Toronto, Canada SciLeads Ltd Full time

    Are you a recent graduate looking to start your career in sales? SciLeads is a fast-growing company focused on providing sales intelligence to the life science and pharmaceutical industry. We are looking for a highly motivated and driven Graduate Sales Development Representative to join our team. At SciLeads, we're committed to creating an inclusive and...

  • Graduate Sales Development Representative

    3 months ago

    Toronto, Canada SciLeads Ltd Full time

    Are you a recent graduate looking to start your career in sales? SciLeads is a fast-growing company focused on providing sales intelligence to the life science and pharmaceutical industry. We are looking for a highly motivated and driven Graduate Sales Development Representative to join our team. At SciLeads, we're committed to creating an inclusive and...

  • New Graduate Development Initiative

    3 weeks ago

    Toronto, Ontario, Canada Aliaxis Full time

    Aliaxis is a prominent provider of innovative plastic piping solutions across North America. Our commitment is to create a sustainable future by ensuring efficient access to water and energy.This is an exceptional opportunity to launch your professional journey with an organization that offers the chance to acquire top-tier industry experience, engage in...

  • Graduate Programs

    2 months ago

    Old Toronto, Canada Canada Pension Plan Investment Board Full time

    Broaden your opportunities as part of an investment thought leader with a global presence. Make your next professional move a big one.At CPP Investments you can kick-start your career with a global investment leader. If you’re a student in your final year of study looking for a full-time position with challenging and interesting work in a supportive...

  • Graduate Programs

    2 months ago

    Old Toronto, Canada Canada Pension Plan Investment Board Full time

    Broaden your opportunities as part of an investment thought leader with a global presence. Make your next professional move a big one.At CPP Investments you can kick-start your career with a global investment leader. If you’re a student in your final year of study looking for a full-time position with challenging and interesting work in a supportive...

  • Graduate Sales Development Representative

    3 months ago

    Toronto, Canada SciLeads Ltd Full time

    Are you a recent graduate looking to start your career in sales? SciLeads is a fast-growing company focused on providing sales intelligence to the life science and pharmaceutical industry. We are looking for a highly motivated and driven Graduate Sales Development Representative to join our team.At SciLeads, we're committed to creating an inclusive and...

  • Graduate Development Program at Aliaxis

    3 weeks ago

    Toronto, Ontario, Canada Aliaxis Full time

    Aliaxis is a prominent provider of innovative plastic piping solutions across North America. Our vision is to contribute to a sustainable future by connecting communities with essential resources such as water and energy.This is an excellent opportunity to launch your professional journey with an organization that offers unparalleled industry exposure,...

  • Graduate Development Program Engineer

    1 month ago

    Toronto, Canada Florida Crystals ASR Group Full time

    Redpath Sugar is located on Toronto’s historic downtown waterfront and has been a part of Canada’s heritage for more than 160 years. Our brand is the oldest food-related trademark in Canada and is recognized across the country. Redpath Sugar is part of ASR Group, the largest cane sugar refiner in the world. POSITION SCOPE The Graduate Development...

  • Graduate Consultant

    1 month ago

    Old Toronto, Canada Ricardo plc Full time

    Role: Graduate ConsultantLocation: Toronto, Canada - Hybrid/Remote workingRole ID: 2024-2448Our vision is to create a safe and sustainable world.Ricardo plc is a global strategic, environmental, and engineering consulting company. With over 100 years of engineering excellence and employing close to 3,000 employees in more than 20 countries, we provide...

  • Graduate Consultant

    1 month ago

    Old Toronto, Canada Ricardo plc Full time

    Role: Graduate ConsultantLocation: Toronto, Canada - Hybrid/Remote workingRole ID: 2024-2448Our vision is to create a safe and sustainable world.Ricardo plc is a global strategic, environmental, and engineering consulting company. With over 100 years of engineering excellence and employing close to 3,000 employees in more than 20 countries, we provide...

  • Graduate Program Coordinator

    3 weeks ago

    Old Toronto, Ontario, Canada University Of Toronto Full time

    Position Overview:The Graduate Program Administrator plays a vital role in supporting the Department of Physiology within the Temerty Faculty of Medicine at the University of Toronto. This position is integral to ensuring that students receive comprehensive guidance on academic and financial matters, as well as facilitating a smooth admissions process.About...

  • Graduate Program Coordinator

    3 weeks ago

    Old Toronto, Ontario, Canada University Of Toronto Full time

    Position Overview:As a key member of the Department of Physiology, the Graduate Program Administrator plays a vital role in supporting our graduate students through their academic journey. This position involves providing essential guidance on both academic and financial matters, ensuring that students are well-informed about program requirements,...