SQL Product Manager

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. To support our growing business, Pinnacle is seeking candidates for the position SQL Lead Developer to join our Technology Team.

Job Description

The SQL Product Manager will be responsible for leading and mentoring a small team of developers, overseeing database design, development, optimization, and maintenance activities. This role involves guiding the team in writing efficient SQL queries and procedures, ensuring data quality and integrity, and driving best practices in database management.

In addition to hands-on technical work, the SQL Product Manager will coordinate workloads, review code, provide technical direction, and foster collaboration across the team. The ideal candidate will have strong leadership skills, a passion for building scalable and automated data solutions, and the ability to balance strategic planning with day-to-day execution.

We are seeking a proactive leader who can inspire and support their team, drive process improvements, and deliver efficient, high-quality results in a fast-paced environment.

Responsibilities

Lead, mentor, and support SQL developers through guidance, reviews, and feedback.

• Oversee design, development, and maintenance of SQL databases and structures.
• Drive creation and optimization of high-performance SQL queries and procedures.
• Establish and enforce best practices for database design and query development.
• Ensure data quality, integrity, and security through testing and governance.
• Direct development of ETL processes to integrate data across systems.
• Monitor and improve SQL database performance and reliability.
• Guide creation and maintenance of SSRS reporting solutions.
• Oversee SQL integration with Python and Power Automate automation.
• Collaborate with teams to gather requirements and deliver scalable solutions.
• Provide technical leadership in troubleshooting complex database issues.
• Maintain clear documentation for databases, queries, and processes.
• Foster a culture of customer service and continuous improvement.
• Stay current with emerging SQL/database trends and technologies.
• Manage external consultants and contract developers.

Desired skills and experience

Technical Skills

• Bachelor's degree in Computer Science, Information Technology, or related field.
• 8+ years experience of SQL, including complex queries, subqueries, and stored procedures.
• 8+ years experience with database design and normalization.
• 8+ years experience with ETL tools, such as SSIS.
• 3+ years experience in finance industry.
• Proficiency with SSRS and RDL report writing.
• Hands-on experience with cloud-based databases, such as Azure.
• Working knowledge of Python and its standard libraries, Power Automate and PowerApps.
• Experience with RESTful API design and development.
• Proficiency with version control systems such as Git.
• Strong knowledge of fund accounting.
• Experience with PFS-Paxus.
• Strong knowledge of system and software quality assurance best practices and methodologies.

Leadership Skills

• Demonstrated ability to gather requirements, analyze needs, and design scalable solutions.
• Strong foundation in solution design principles, modular programming, and automation.
• Proven leadership in mentoring teams, providing guidance, and driving performance.
• Effective decision-making skills with sound professional judgment.
• Excellent analytical, troubleshooting, and problem-solving abilities.
• Strong organizational and multi-tasking skills with attention to quality and deadlines.
• Excellent communication and collaboration skills, both written and verbal.
• Self-motivated with a strong desire to succeed and foster continuous improvement.
• 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.
• Excellent written and verbal communication skills.

Why Pinnacle Fund Services?

At Pinnacle Fund Services, 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
• 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

Thank you for your interest in Pinnacle Fund Services. We look forward to meeting you and learning about your next steps in your career.

We are committed to creating a diverse and inclusive workplace and welcome 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.