Inscrivez-vous pour accéder à toutes les fonctionnalités de notre service.
  • Recherche d'offres d'emploi
  • Favoris
  • Créer un CV
    Nouveau
  • Salaires
  • Souscriptions

Senior SQL Developer

Temps plein

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.

L'offre d'emploi a été publiée il y a 1 jour
Des emplois similaires qui pourraient vous intéresserBasé sur l'offre Senior SQL Developer à à domicile
  • $115.32k - $125.05k par année

     ...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
    Emploi permanent
    Temps plein
    Travail à distance
    Lundi au vendredi
    Travail posté
    Équipe de jour

    Research Pandit

    Remote
    il y a 1 jour
  • $135.1k - $182.9k par année

     ...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
    Temps plein
    Stage
    Travail au bureau
    Zone locale
    Horaires flexibles
    1 jour par semaine

    Clio

    Remote
    il y a 3 jours
  •  ...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
    Emploi permanent
    Temps plein
    Freelance
    Horaires flexibles

    Join ready

    Remote
    il y a 1 jour
  •  ...other Hogan applications, specifically Hogan CIS. Experience in Hogan integration with Zafin (vendor) platform. Other Languages English: C2 Proficient Seniority Senior... 
    Senior
    Travail à distance

    Luxoft

    Remote
    il y a 1 jour
  • $150k - $160k par année

     ...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
    Temps plein
    Travail au bureau
    Zone locale
    Travail à distance
    Horaires flexibles

    Journal Technologies

    Remote
    il y a 3 jours
  •  ...relational databases (e.g., MySQL, PostgreSQL). Nice to have Vue.js Other Languages English: C1 Advanced Seniority Senior... 
    Senior
    Travail à distance

    Luxoft

    Remote
    il y a 1 jour
  •  ...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
    il y a 18 jours
  •  ...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
    Emploi permanent
    Temps plein
    Recrutement immédiat
    Travail à distance
    Le monde entier

    Tether Operations Limited

    Remote
    Il y a un mois
  • $125k - $135k par année

     ...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
    Temps plein
    Travail à distance
    Bureau à domicile
    Horaires flexibles

    Thrive Health

    Remote
    il y a 3 jours
  •  ...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
    Emploi permanent
    Temps plein
    Travail au bureau
    Travail à distance
    Le monde entier
    Horaires flexibles

    Kodify

    Remote
    il y a 2 jours
  • $1000 - $3000 par mois

     ...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
    Contrat Longue Durée
    Emploi permanent
    Temps plein
    Сontrat
    Travail au bureau
    Travail à distance
    Travail à domicile
    Horaires flexibles

    Powerprozesse

    Remote
    il y a 15 jours
  • $110k - $145k par année

     ...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
    Travail à distance
    Temps plein
    Stage
    Travail à domicile

    Pagefreezer

    Remote
    il y a 10 jours
  • $85 - $115 par heure

     ...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
    Taux horaire
    Contrat Longue Durée
    Temps plein
    Сontrat
    Pour les contractants
    Travail au bureau
    Travail à distance
    Travail à domicile
    Lundi au vendredi

    Tri-global

    Remote
    il y a 10 jours
  •  ...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
    Travail à distance
    Travail au bureau
    Recrutement immédiat
    Travail à domicile
    Horaires flexibles

    TextNow

    Remote
    Il y a 2 mois
  •  ...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
    Travail à distance
    Temps plein

    Coal Car Studio

    Remote
    il y a 10 jours
  •  ...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
    Temps plein
    Travail à distance
    Travail à domicile
    Horaires flexibles

    Sync.com

    Remote
    il y a 3 jours
  •  ...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
    Travail à distance
    Le monde entier

    Workleap

    Remote
    Il y a 2 mois
  •  ...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
    Emploi permanent
    Temps plein
    Travail à distance

    TechBiz Global GmbH

    Remote
    il y a 5 jours
  • $100k - $120k par année

     ...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
    Emploi permanent
    Temps plein
    Travail à distance
    Travail à domicile
    Bureau à domicile
    Horaires flexibles

    ITExpert

    Remote
    Il y a 2 mois
  • $110k - $145k par année

     ...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
    Travail à distance
    Temps plein
    Stage
    Travail à domicile

    Pagefreezer

    Remote
    il y a 10 jours
  •  ...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
    Emploi permanent
    Temps plein

    Strix Group B.V.

    Remote
    il y a 1 jour
  • 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
    Сontrat

    Ward Tech Talent

    Remote
    Il y a 2 mois
  •  ...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
    Contrat Longue Durée
    Emploi permanent
    Temps plein
    Travail à distance

    Jobtome

    Remote
    il y a 8 jours
  • Ü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
    Emploi permanent
    Temps plein
    Horaires flexibles

    24-LOG GmbH

    Remote
    il y a 11 jours
  •  ...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
    Temps plein
    Сontrat
    Pour les contractants
    Freelance
    Zone locale
    Travail à distance
    Bureau à domicile

    Clearview

    Remote
    il y a 9 jours
  •  ...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
    Temps plein
    Stage
    Travail à distance

    CentralSquare Technologies

    Remote
    il y a 10 jours
  •  ...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
    Tarif journalier
    Emploi permanent
    Temps plein

    Moneybase plc

    Remote
    il y a 17 jours
  •  ...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
    Сontrat
    Travail temporaire
    Le monde entier
    Horaires flexibles
    Travail posté

    Mariner Innovations

    Remote
    il y a 1 jour
  •  ...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... 
    Travail à distance

    TechBiz Global GmbH

    Remote
    il y a 5 jours
  •  ...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
    Temps plein

    TechBiz Global GmbH

    Remote
    il y a 3 jours

Voulez-vous recevoir plus d'offres d'emploi ?

S'abonner et recevoir des offres d'emploi similaires à Senior SQL Developer. Soyez parmi les premiers à postuler !