Junior Developer
IT & Innovation
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. We are seeking strong team players, outgoing individuals, who possess a strong work ethic and can take initiative in a growing entrepreneurial company. A commitment to continuous learning and development is a strong part of our culture.
To support our growing business, Pinnacle is seeking candidates for a Junior Developer to join our Technology Team. We are open to a candidate working anywhere in Canada.
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
Reporting to the Assistant Vice President - Technology, key responsibilities will include, but are not limited to:
- Design, develop, and maintain SQL databases and tables
- Write optimized SQL queries to retrieve, manipulate and transform data
- Create and modify database structures to support business requirements
- Ensure data quality and integrity through testing, validation, and error checking
- Develop and maintain ETL (Extract, Transform, Load) processes to move data between systems
- Develop, test, and maintain Python applications and APIs
- Write efficient, scalable, and reusable Python code
- Optimize Python code for performance
- Debug issues and troubleshoot errors in Python code
- Provide technical support and troubleshooting for SQL and Python related issues
- Develop and maintain documentation for databases, queries, processes and solutions
- Stay up-to-date with emerging trends and technologies related to SQL development
- Collaborate with cross-functional teams to gather requirements and develop solutions
- Foster a culture of customer service and continuous improvement among the IT Solutions team to enable effective support of business operations.
- Work with external consultants and developers on contract.
Desired skills and experience
- Bachelor's degree in Computer Science, Information Technology, or related field
- Strong knowledge of SQL, including complex queries, subqueries, and stored procedures
- Experience with database design and normalization
- Experience with ETL tools, such as SSIS
- Experience with cloud-based databases, such as Azure, is a plus
- Strong knowledge of Python and its standard libraries
- Experience with RESTful API design and development
- Experience with version control systems such as Git
- Familiarity with Microsoft PowerApps
- Demonstrated experience in requirements gathering and analysis.
- Strong knowledge in solution design principles and modular programming techniques.
- Strong analytical and problem-solving skills
- Excellent communication and collaboration skills
- Experience implementing automation solutions independently.
- Ability to work independently through complex issues and apply professional judgement.
- Ability to meet deadlines and prioritize a demanding workload.
- Effective decision maker.
- Ability to understand the business process and create process flow diagrams.
- Excellent organizational and multi-tasking skills, attention to quality, self-motivation and a strong desire to succeed.
- Strong knowledge of system and software quality assurance best practices and methodologies.
- Excellent written and verbal communication skills.
What we look for:
We are interested in strong team players who support their colleagues in reaching their goals while also considering their own workload and development. We’re looking for people with a genuine passion for IT and process automation development. If you have the confidence to speak up, automate solutions and contribute efficient solutions to a fast-paced business, this role is for you.
Position type: Permanent full-time
Location: Canada
Salary: Competitive compensation & benefits, including performance bonus & payment professional dues.
