Senior SQL & Python Developer

at  Pinnacle Fund Services

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 Senior SQL & Python Developer to join our Technology Team. We are open to a candidate working anywhere in Canada.

At Pinnacle, we’re committed to providing our employees with a comprehensive benefits package that supports their health, well-being, and professional growth. Here are some of the perks and benefits that set us apart:

• Extended Health Benefits
• RRSP Employer Match Program
• Educational Support
• Flexible working arrangements
• Work-Life Balance
• Remote Firm, with some in-office days with purpose (learn, build relationships, collaborate & socialize)
• Exposure to all aspects of the business, working with senior management directly

JOB DESCRIPTION

The Senior SQL & Python 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. You will also be responsible for designing, developing and maintaining robust and scalable applications using Python and overseeing and working with the Junior Developer.

DESIRED SKILLS AND EXPERIENCE

• Bachelor’s degree in Computer Science, Information Technology, or related field
• 5+ years experience of SQL, including complex queries, subqueries, and stored procedures
• 5+ years experience with database design and normalization
• 5+ years experience with ETL tools, such as SSIS
• 3+ years experience of Python and its standard libraries
• Experience with SSRS and RDL report writing
• Experience with cloud-based databases, such as Azure, is a plus
• Experience with RESTful API design and development
• Experience with version control systems such as Git
• Familiarity with Microsoft PowerApps
• Strong knowledge of fund accounting
• Experience with PFS-Paxus
• 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
  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. We believe a diverse workplace is essential for driving innovation and achieving success, and we strive to provide equal opportunities for all employees

• Write optimized SQL queries to retrieve, manipulate and transform data
• Design, develop, and maintain SQL databases and tables
• Design, develop, and maintain Python-based applications, APIs, and services
• Ensure data quality and integrity through testing, validation, and error checking
• Develop and maintain ETL processes to move data between systems
• Monitor SQL Database performance and design maintenance process to ensure reliability
• Write clean, reusable, and efficient code while following best practices for software development
• Create SSRS reports and maintain SSRS reporting tools
• Integrate SQL queries with Python and Power Automate
• Advise Python and SQL best practices
• Oversee Junior Developer
• Provide technical support and troubleshooting for Application and SQL related issues
• Develop and maintain documentation for applications, databases, queries, processes and solutions
• 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