Senior SQL Developer

Job Responsibility:

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

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
• 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

The Senior SQL 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 Senior SQL Developer will also be responsible for overseeing and working with the Junior Developer.

Primary Responsibilities

Reporting to the Assistant Vice President - Technology, key responsibilities will include, but are not limited to:

• Write optimized SQL queries to retrieve, manipulate and transform data
• Design, develop, and maintain SQL databases and tables
• 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
• Monitor SQL Database performance and design maintenance process to ensure reliability
• Document SQL and Database setup and procedures
• Oversee Junior Developer
• Create and maintain SSRS reporting tools
• Integrate SQL queries with Python and Power Automate
• Advise SQL best practices
• Provide technical support and troubleshooting for SQL 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
• 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
• Experience with SSRS and RDL report writing
• Experience with cloud-based databases, such as Azure, is a plus
• 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
• 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.

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 technology solution 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.

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.