Senior SQL Developer
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.
- ...Experience Required: 10 Top 3 Required Skills 1. SQL, SQL Server , 2.proficiency with Selenium using C# 3.JIRA,... ...deliver high-quality outcomes with minimal supervision. • Develop, maintain, and execute automated test scripts, embedding automation...SeniorContract work
- ...company lives in the intersection of our people, our customers, and our brands. We are looking for a talented and experienced Senior JavaScript Developer to join our team. In this role, you will be responsible for leading the design and development of complex web applications,...SeniorFull timeWork at officeWork from home
- ...company lives in the intersection of our people, our customers, and our brands. We are looking for a talented and experienced Senior PHP Developer to join our team and play a key role in building and maintaining our web applications. You will be responsible for the entire development...SeniorFull timeWork at officeWork from home
$132k - $165k per year
...over Customer Success Work the Problem Be Curious Own the Outcome Respect Each Other YOUR IMPACT As a Senior Full Stack Software Developer, you will be responsible for leading the design, development, and delivery of scalable full-stack applications, shaping...SeniorLong term contractLocal area$60k - $100k per year
...solutions, and working with the business through an entire cycle to develop, test and implement the solutions into production. The... ...Redux, Node.js, GraphQL, Apollo or similar (desirable) ~ Microsoft SQL Server and Azure SQL databases ~ An understanding of workflow based...SuggestedLong term contractFull timeTemporary workInternshipLocal areaRemote workFlexible hours- ...are currently seeking an experienced and passionate Java Software Developer to join our dynamic team. As a Java Software Developer, you will... ...development experience 2+ years of experience working with Microsoft SQL Server or similar RDBMS Experience working with web-based APIs...Full timeLocal areaRemote work
- ...We are looking for a skilled Senior/Team Lead Full Stack (Node.js/React) developer with 5+ years of professional experience to join our new team for working on enterprise-level project from the Canada Please note that this role requires a hybrid work format (3 days in the...SeniorFull timeWork at officeRemote workMonday to friday
- ...are seeking a highly skilled and passionate Full Stack Software Developer with a strong focus on Java to join our growing engineering team.... ...Spring Security). Experience with relational databases (e.g., SQL, PostgreSQL, MySQL) and ORM frameworks (e.g., Hibernate, JPA)....Local areaFlexible hours
$120k - $137k per year
...Obsess over Customer Success Work the Problem Be Curious Own the Outcome Respect Each Other YOUR IMPACT As a Cloud Developer within the RunMyJobs Platform Engineering team, you will design, build, and evolve the cloud infrastructure that powers Redwood's...Local area$50k - $110k per year
...placed by Nigel Frank nearly 10 years ago, is looking to hire a Senior Dynamics NAV Developer to support their MS Dynamics NAV 2017 environment. They are... ...NAV development using C/SIDE and C/AL, along with solid SQL experience. Java experience is also highly valued, particularly...SeniorLong term contractContract work- ...This is a remote position. Sr. APEX/ORDS Software Developer Location: Remote (Ontario Government) Closing Date: July... ...well-designed, tested, and maintainable applications. Develop SQL and PL/SQL code, stored procedures, packages, and database...SeniorFull timeRemote work
- ...Job Responsibility: A division of Harris, Northstar's Research and Development team is seeking an Angular Software Developer to implement front end development of our web based applications. You will be working with the latest technology and have a chance to advance and grow...Full timeWork at officeLocal areaRemote work
- ...Description Hillview Consulting is looking for a Java Full Stack Developer to join our team on-site in Ontario. This contract position... ...skills and attention to detail ~ Strong communication and teamwork abilities ~ Experience with database management (SQL, NoSQL)...Hourly payContract work
$51k - $55k per year
...Responsibilities Build and maintain the core Drupal front-end theming layer for the main Tyndale website as well as Christian Careers Canada Develop and maintain a usable pattern library, including a series of utility classes, for the creation of content in the content management...Work at office$200 per day
...This is a remote position. Job Overview We are looking for aspiring Web Developer Interns who want to gain practical experience in website development and design. This remote internship, lasting between 1 and 6 months, allows interns to work on real-world...Long term contractContract workInternshipRemote workFlexible hours- ...iOS Developer Intern / Co-op (Remote) Job Description: Guhuza is seeking an iOS Developer to join our remote team and contribute to the development of our iOS app. As an iOS Developer at Guhuza, you will play a crucial role in building and enhancing our mobile application...Temporary workPart timeInternshipRemote work
$65k per year
...stories . About the role We are currently looking for a Senior Network Engineer to join the Foundever family! 80% virtual and 20... ...experience Ability to work large or medium size projects, develop documentation, and testing processes, a must. Ability to understand...SeniorLocal areaRemote workWork from homeShift work$137k - $206k per year
...Ready to be a Titan? As a Senior Software Engineer will be part of the engineering team... ...stack (C# / .NET, ASP.NET MVC, Web APIs) and SQL databases (Microsoft SQL Server or any... ...and other tools that are typically used by developers on Microsoft technology stack. B.S., M....SeniorRemote jobInternshipLocal areaFlexible hours$115.47k - $135.08k per year
Senior Advisor Association of Municipalities of Ontario (AMO) Toronto | Hybrid work arrangement (approx. 2 days/week in office)... ...people and communities across Ontario. Key responsibilities: Develop and execute advocacy strategies to advance municipal interests...SeniorWork at officeWork from home2 days per week- ...law firms in the country. Job Overview We're looking for a Senior AI/ML Engineer to help expand our next-generation document intelligence... .... Programming: Proficient in Python; comfortable with SQL and data engineering patterns. Strongly Preferred: Working understanding...SeniorFull timeRemote work
- ...main liaison, representing enablement across the Commerce line of business, ensuring alignment with go-to-market strategy. Help develop and maintain engaging learning product enablement resources (courses, job aid, etc.), demos, and workshops for internal teams, partners...SeniorRemote work
$165k - $183k per year
...skills to the next level? We’re looking for a Senior Software Engineer to join our Ads team.... ...dynamic challenges, and we take pride in developing and maintaining scalable and fault-tolerant... ...such as Rails. ~ Highly proficient with SQL, capable of writing and reviewing complex...SeniorRemote jobLong term contractPermanent employmentTemporary workWork at officeWork from homeFlexible hours- ...to maximize revenue. Support Manager, S&T Sales in customer service activities related to the Ontario Power Market customers. Develop and maintain a collaborative and positive working relationship with various groups within Energy Services to assist in the development...SeniorLong term contractFull timeTemporary workWork from homeFlexible hours
- ...technical teams learn, grow, and deliver exceptional outcomes? As a Senior Implementation Enablement Manager, you'll play a key role in... ..., ensuring clarity and efficiency with Coveo implementations. Develop and execute a design-to-cost program strategy to support Coveo’s...Senior
$110k - $160k per year
...re looking to connect with experienced Guidewire certified Developers to support the design and delivery of Guidewire solutions... ...expected before you move forward. Who You Are: A Senior Guidewire Developer with certification in one or more InsuranceSuite products....SeniorFull timeRemote work- ...Senior Civil/Structural Engineer Spark Power is looking for a Civil/Structural Engineer... ...Manager, you will be responsible for developing and stamping Structural engineering packages... ...as part of a multidisciplinary team to develop/deliver cost effective and constructible...SeniorFull timeManual laborFlexible hours
- ...North Burlington Baptist Church (NBBC) is seeking a Senior Pastor to provide spiritual and pastoral leadership to the congregants of the church. We are a church that values authentic relationships, biblical teaching, and practical discipleship. Worship services feature a contemporary...SeniorLong term contractPermanent employmentFull timeTemporary workPart timeInternshipRelocation
$20 - $30 per hour
Job Responsibility: PT Bookkeeper - QuickBooks Online Do you love being a bookkeeper? Looking for a great place to do what you love? If so, then we want to hear from you. About Us: We are a full service Accounting/Bookkeeping firm located in Newmarket, Ontario. ...SeniorHourly payPermanent employmentPart timeCasual workWork at officeWork from homeMonday to fridayFlexible hours- ...Requisition Number: 105666 Senior Microsoft Security Consultant Salary: 115k-125k base + bonus Location: You will have the flexibility to work fully remotely or in one of our hybrid offices in Toronto or Montreal Insight at a Glance ~14,000+ engaged teammates...SeniorWork at officeLocal areaRemote work
- ...Title: Senior Development Officer - Major Gifts Employee Working Location: Remote (Ontario; Preferably GTA) Employment Status:... ...Advanced understanding of major gift fundraising and the ability to develop and execute complex donor strategies. ~ Demonstrated success...SeniorPermanent employmentFull timeWork at officeRemote work
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior SQL Developer. Be the first to apply!
- sql developer Ontario
- oracle sql developer Ontario
- senior software developer Ontario
- working with seniors Ontario
- senior human resources Ontario
- senior director of operations Ontario
- construction senior project manager Ontario
- senior program manager Ontario
- senior development manager Ontario
- senior data scientist Ontario
