.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 offers employees a dynamic workplace with 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, 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 BenefitsRRSP Employer Match ProgramEducational SupportFlexible working arrangementsWork-Life BalanceRemote Firm, with some in-office days with purpose (learn, build relationships, collaborate & socialize)Exposure to all aspects of the business, working with senior management directlyJob DescriptionThe 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 ResponsibilitiesReporting 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 processes 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 on 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