Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Senior SQL Developer

Full-time

Pinnacle Fund Services

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.

Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the Senior SQL Developer in Remote vacancy
  • $115.32k - $125.05k per year

     ...Job Responsibility: Hi , Dear Candidate, Greeting of the day...!! Job Title: Senior Ruby Developer Role: Full Time Location: Remote, Canada : Experience - 10 yrs : We are seeking an experienced Senior Ruby Developer to lead the development of... 
    Senior
    Permanent employment
    Full time
    Remote work
    Monday to friday
    Shift work
    Day shift

    Research Pandit

    Remote
    1 day ago
  • $135.1k - $182.9k per year

     ...and beautiful. We are currently seeking a Senior Software Engineer to join our rapidly...  ...What you'll work on: Work with a team of developers to solve complex problems and provide elegant...  ...the role may join below the midpoint and develop their skills over time. The final offer... 
    Senior
    Full time
    Internship
    Work at office
    Local area
    Flexible hours
    1 day per week

    Clio

    Remote
    3 days ago
  • $150k - $160k per year

     ...people, and we are actively looking for smart, motivated people who care deeply about the work they do. We are seeking a motivated Senior Cloud Operations Engineer with a passion for cloud administration, automation and product support. The Senior Cloud Operations... 
    Senior
    Full time
    Work at office
    Local area
    Remote work
    Flexible hours

    Journal Technologies

    Remote
    3 days ago
  •  ...stakeholders. Asegurar buenas prácticas de desarrollo, calidad y performance. Experiencia como Desarrollador OutSystems (Semi Senior o Senior). Dominio de OutSystems Reactive Web y Mobile . Experiencia en integraciones REST / SOAP . Conocimiento de APIs... 
    Senior
    Permanent employment
    Full time
    Freelance
    Flexible hours

    Join ready

    Remote
    1 day ago
  •  ...other Hogan applications, specifically Hogan CIS. Experience in Hogan integration with Zafin (vendor) platform. Other Languages English: C2 Proficient Seniority Senior... 
    Senior
    Remote job

    Luxoft

    Remote
    1 day ago
  •  ...relational databases (e.g., MySQL, PostgreSQL). Nice to have Vue.js Other Languages English: C1 Advanced Seniority Senior... 
    Senior
    Remote job

    Luxoft

    Remote
    1 day ago
  •  ...innovative platform on the planet, Tether is the place for you. Are you ready to be part of the future? About the job As a senior Backend Developer, you will be a part of the team that works on the development and maintenance of the backend components of multiple services... 
    Senior
    Permanent employment
    Full time
    Immediate start
    Remote work
    Worldwide

    Tether Operations Limited

    Remote
    a month ago
  •  ...amongst the companies that lead the world in technology and innovation. Your next chapter starts here.    We are seeking a Senior NICE CXone Developer to support IT, Security, and Business teams in designing, developing, and optimizing contact center solutions. The... 
    Senior

    High Tech Genesis

    Remote
    18 days ago
  • $125k - $135k per year

     ...more diverse organization. The Opportunity Hi, I'm Will; Manager, Software Development at Thrive Health. We're looking for Senior Full Stack Developers with a strong backgrounds in Python/Django, TypeScript/React, and Java/Spring. The successful candidate will play a... 
    Senior
    Full time
    Remote work
    Home office
    Flexible hours

    Thrive Health

    Remote
    3 days ago
  •  ...success, producing world-class video content and building, developing, and managing a number of high-traffic websites. Our award-...  ...means embracing thrilling challenges tailor-made for a star Senior Full-Stack Developer ! At Kodify, we love tech and are always thinking about... 
    Senior
    Permanent employment
    Full time
    Work at office
    Remote work
    Worldwide
    Flexible hours

    Kodify

    Remote
    2 days ago
  • $1000 - $3000 per month

     ...We're seeking experienced Backend or Fullstack Developers with a strong systems-design mindset to join our fully remote team. If you like...  ...Codex, this could be the right role for you. What you'll do Develop and maintain our web application Design and own our data layer... 
    Senior
    Long term contract
    Permanent employment
    Full time
    Contract work
    Work at office
    Remote work
    Work from home
    Flexible hours

    Powerprozesse

    Remote
    15 days ago
  • $85 - $115 per hour

     ...Job Responsibility: SENIOR FRONT-END DEVELOPER (React, TypeScript, Azure - 2 RESOURCES REQUIRED) Requisition #: R25-3322 (GOAPRDJP00000612) Location...  ..., C#, Azure App Services, Azure cloud-based development, MS SQL Server, PostgreSQL, Cosmos DB, and GitHub. DESCRIPTION OF... 
    Senior
    Hourly pay
    Long term contract
    Full time
    Contract work
    For contractors
    Work at office
    Remote work
    Work from home
    Monday to friday

    Tri-global

    Remote
    10 days ago
  • $110k - $145k per year

     ...and deletion. About the Role:  This is an existing role in our team. We are looking for a strategic and collaborative Senior Software Developer to join our Development & Engineering team to work on our Social Media Archiving Solutions. In this role, you will be a key... 
    Senior
    Remote job
    Full time
    Internship
    Work from home

    Pagefreezer

    Remote
    10 days ago
  •  ...Job Opportunity: Senior Unity Developer - Join Our XR Adventure! Are you a talented Unity developer with a passion for immersive experiences? Coal Car Studio is on the lookout for an experienced, senior Unity developer to play a key role in our VR/AR projects. We're a dynamic... 
    Senior
    Remote job
    Full time

    Coal Car Studio

    Remote
    10 days ago
  •  ...barriers to communication and free the flow of conversation for people everywhere.   TextNow is looking for an experienced Senior Web Developer to play a key role in the development of our voice and messaging platform on Web. You will be responsible for building high-performance... 
    Senior
    Remote job
    Work at office
    Immediate start
    Work from home
    Flexible hours

    TextNow

    Remote
    more than 2 months ago
  •  ...About the Role We are seeking a highly skilled and experienced Senior Backend Developer Lead with a strong emphasis on database expertise. In this...  ...Qualifications Extensive experience with database technologies (SQL, NoSQL, PostgreSQL, MongoDB etc.) Experienced Technology... 
    Senior
    Full time
    Remote work
    Work from home
    Flexible hours

    Sync.com

    Remote
    3 days ago
  •  ...portfolio. We are looking for a Junior Java Developer(Remote) for our client’s growing team and...  ...design patterns Good knowledge of SQL and working with relational databases...  ...functional teams, including product, QA, and senior developers, to deliver high-quality software... 
    Senior
    Permanent employment
    Full time
    Remote work

    TechBiz Global GmbH

    Remote
    5 days ago
  • $100k - $120k per year

     ...We are excited to announce a fantastic opportunity to join our team as a Senior Developer! This position is fully remote and open exclusively to Canadian citizens and permanent residents. We’re seeking a skilled and passionate developer to help build the next phase of our... 
    Senior
    Permanent employment
    Full time
    Remote work
    Work from home
    Home office
    Flexible hours

    ITExpert

    Remote
    more than 2 months ago
  •  ...products that deliver exceptional value for our customers. Period. Job Description  So, what will your new role look like? As a Senior Developer in the Migrate Foundation team, you’ll help drive complex, high-impact projects that shape the foundations of ShareGate Migrate.... 
    Senior
    Remote job
    Worldwide

    Workleap

    Remote
    more than 2 months ago
  • $110k - $145k per year

     ...edit, and deletion. About the Role:  This is an existing role in our team. We are seeking a strategic and technical Senior Cloud Infrastructure Developer to join our Development team on our Social Media Archiving product. The product is a production multi-tenant SaaS... 
    Senior
    Remote job
    Full time
    Internship
    Work from home

    Pagefreezer

    Remote
    10 days ago
  •  ...Szukamy Symfony Developera do projektów e-commerce opartych o Shopware 6. Pracujemy głównie przy rozwoju backendu, integracjach i customowych funkcjonalnościach dla sklepów działających na różnych rynkach. Szukamy osoby, która dobrze odnajduje się w pracy projektowej — potrafi... 
    Senior
    Permanent employment
    Full time

    Strix Group B.V.

    Remote
    1 day ago
  •  ...experienced in a workplace. To be surrounded by developers who they can learn from. We are truly...  ...you an exceptionally strong, mid-to-senior Backend Developer with an independent mindset? Do you...  ...You have a strong understanding of SQL databases (Postgres, MySQL..), Redis and... 
    Senior
    Full time
    Contract work
    For contractors
    Freelance
    Local area
    Remote work
    Home office

    Clearview

    Remote
    9 days ago
  •  ...students are mentored by some of our top developers, have the opportunity to use leading computing...  ...will also work closely with mid-level and senior engineers in developing solutions to...  ...C++, Java, JavaScript, Python, PHP, Ruby SQL Server Web Services (REST, SOAP) Data... 
    Senior
    Full time
    Internship
    Remote work

    CentralSquare Technologies

    Remote
    10 days ago
  • Senior PHP Applications Developer (CONTRACT) In this role you will plan, architect, design, develop, implement, test, and solve problems with complex applications involving authentication and databases used by the end users. You are expected to demonstrate innovation and... 
    Senior
    Contract work

    Ward Tech Talent

    Remote
    more than 2 months ago
  •  ...are utilising the very latest technologies to get there. As we continue to grow sustainably, a new position has arisen for a Senior Backend Developer reporting directly to the Product Lead . The Senior Back End Developer will form part of a team of 50 experienced IT... 
    Senior
    Daily paid
    Permanent employment
    Full time

    Moneybase plc

    Remote
    17 days ago
  •  ...engineering culture focused on quality, ownership, and long-term maintainability. The role We are looking for a Senior Golang Backend Developer to join our engineering team and take ownership of critical backend systems and services. You will work on the design... 
    Senior
    Long term contract
    Permanent employment
    Full time
    Remote work

    Jobtome

    Remote
    8 days ago
  •  ...to our TOP clients from our portfolio. We are looking for a C# developer for our client’s growing team and work closely with clients to drive...  ...and Turkey. At least 1 year of work experience with C# and SQL technologies. Deep understanding of OOP concepts. Working... 
    Remote work

    TechBiz Global GmbH

    Remote
    5 days ago
  • ÜBER UNS: Wir sind die 24 Log GmbH, ein innovatives und wachsendes Unternehmen im Bereich der SAP Logistik. Unsere Mission ist es, die komplexen Herausforderungen der modernen Logistik mit intelligenten, zielstrebigen und benutzerfreundlichen Lösungen zu meistern. Von der...
    Senior
    Permanent employment
    Full time
    Flexible hours

    24-LOG GmbH

    Remote
    11 days ago
  •  ...businesses in the United States and Europe. About the Role: The ERP Developer will collaborate closely with our ERP Systems Manager, ERP...  ...success in communicating with users, technical teams, and senior leadership to collect requirements and troubleshoot issues. Ability... 
    Senior
    Full time

    TechBiz Global GmbH

    Remote
    3 days ago
  •  ...looking for an experienced BizTalk Integration Developer to join our team. The ideal candidate will...  ...and .NET framework. ~ Familiarity with SQL Server and database design. ~ Excellent...  ...explain your ideas and recommendations to senior leaders, Well-organized and dependable... 
    Senior
    Contract work
    Temporary work
    Worldwide
    Flexible hours
    Shift work

    Mariner Innovations

    Remote
    1 day ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Senior SQL Developer. Be the first to apply!