About the role
SQL Developer
Location : Hybrid | Vancouver, BC
Duration : 12 months
Daily Responsibilities :
The successful candidate will design, develop, and maintain database solutions that support our business reporting, data flows and job scheduling initiatives. You will be responsible for developing stored procedures for business reporting, creating and managing SSIS packages to facilitate efficient data flows, and monitoring active batch processes to schedule and optimize jobs. Your work will directly impact decision- making and operational efficiency across the organization.
Key Responsibilities
- Design, develop, and maintain stored procedures that support business reporting needs.
- Optimize queries and database operations to ensure performance and reliability.
- Collaborate with business to translate reporting requirements into data flows/ Queries
- Create, manage existing SSIS packages to support data extraction, transformation, and loading (ETL) processes.
- Ensure data quality, integrity, and security throughout the data flow process.
- Work closely with data engineering and data architects to understand and implement best practices for data integration.
- Troubleshoot and resolve issues related to job execution and data flow interruptions.
- Develop and maintain automated scripts and workflows to enhance batch job scheduling and maintenance.
- Maintain comprehensive documentation for all developed procedures, packages, and job scheduling processes.
- Ensure that all database solutions adhere to company policies, industry regulations, and security standards.
- Assist with audits and implement improvements based on audit findings.
Must-have Skills :
- Proven experience in SQL development, including creating and optimizing stored procedures.
- Strong knowledge of SQL Server Integration Services (SSIS) for developing ETL packages.
- Familiarity with job scheduling and batch processing concepts.
- Proficiency in working with SQL Server and understanding of database design principles.
- Knowledge of UNIX-like operating systems and shell scripting skills.
- Ability to interpret business requirements and translate them into technical solutions.
- Strong problem-solving skills with a detail-oriented mindset.
- Bachelor’s/master’s degree in computer science, Information Technology, or a related field (or equivalent experience).
- Minimum 7-8 years of relevant experience in SQL development and database management.
Nice-to-have Skills :
- Experience with additional data integration tools and technologies.
- Proficiency in writing and optimizing code in at least one programming languages like Python.
- Familiarity with agile development methodologies.
- Knowledge of data warehousing concepts and data modelling best practices.
About Finance Professionals Inc.
WHO WE ARE
We are a specialist FinTech and Financial Services recruitment consultancy. We have been helping clients attract, hire and retain staff across all areas from technology to finance. By being specialists in our sectors, we are able to use our deep and active network of professionals to quickly match the best people with great permanent and contract job opportunities.
WHAT WE DO:
We deliberately work on a small number of assignments allowing us the time to deeply search for talent for your business. By partnering with an excellent client base including Banks, Financial Services Firms, FinTech companies at various stages and established multinationals, we are able to present compelling career opportunities to industry professionals.
SECTORS WE WORK IN: -FinTech -Infrastructure -Financial Systems -Banking & Securities -Wealth Management & Advisory -Fund Management -Fund Services -Payment Services -Financial Services -Insurance -Real Estate Investment Trusts -Real Estate Development -Construction Finance and Private Equity
SKILLS WE PLACE: -Accounting & Finance -Banking Operations & Middle Office -Risk & Compliance -Fund Accounting -PMO -Business Analysts -IT Manager -Cloud Professionals -DBA -Data Specialists -Design -QA & Testing -Developers
About the role
SQL Developer
Location : Hybrid | Vancouver, BC
Duration : 12 months
Daily Responsibilities :
The successful candidate will design, develop, and maintain database solutions that support our business reporting, data flows and job scheduling initiatives. You will be responsible for developing stored procedures for business reporting, creating and managing SSIS packages to facilitate efficient data flows, and monitoring active batch processes to schedule and optimize jobs. Your work will directly impact decision- making and operational efficiency across the organization.
Key Responsibilities
- Design, develop, and maintain stored procedures that support business reporting needs.
- Optimize queries and database operations to ensure performance and reliability.
- Collaborate with business to translate reporting requirements into data flows/ Queries
- Create, manage existing SSIS packages to support data extraction, transformation, and loading (ETL) processes.
- Ensure data quality, integrity, and security throughout the data flow process.
- Work closely with data engineering and data architects to understand and implement best practices for data integration.
- Troubleshoot and resolve issues related to job execution and data flow interruptions.
- Develop and maintain automated scripts and workflows to enhance batch job scheduling and maintenance.
- Maintain comprehensive documentation for all developed procedures, packages, and job scheduling processes.
- Ensure that all database solutions adhere to company policies, industry regulations, and security standards.
- Assist with audits and implement improvements based on audit findings.
Must-have Skills :
- Proven experience in SQL development, including creating and optimizing stored procedures.
- Strong knowledge of SQL Server Integration Services (SSIS) for developing ETL packages.
- Familiarity with job scheduling and batch processing concepts.
- Proficiency in working with SQL Server and understanding of database design principles.
- Knowledge of UNIX-like operating systems and shell scripting skills.
- Ability to interpret business requirements and translate them into technical solutions.
- Strong problem-solving skills with a detail-oriented mindset.
- Bachelor’s/master’s degree in computer science, Information Technology, or a related field (or equivalent experience).
- Minimum 7-8 years of relevant experience in SQL development and database management.
Nice-to-have Skills :
- Experience with additional data integration tools and technologies.
- Proficiency in writing and optimizing code in at least one programming languages like Python.
- Familiarity with agile development methodologies.
- Knowledge of data warehousing concepts and data modelling best practices.
About Finance Professionals Inc.
WHO WE ARE
We are a specialist FinTech and Financial Services recruitment consultancy. We have been helping clients attract, hire and retain staff across all areas from technology to finance. By being specialists in our sectors, we are able to use our deep and active network of professionals to quickly match the best people with great permanent and contract job opportunities.
WHAT WE DO:
We deliberately work on a small number of assignments allowing us the time to deeply search for talent for your business. By partnering with an excellent client base including Banks, Financial Services Firms, FinTech companies at various stages and established multinationals, we are able to present compelling career opportunities to industry professionals.
SECTORS WE WORK IN: -FinTech -Infrastructure -Financial Systems -Banking & Securities -Wealth Management & Advisory -Fund Management -Fund Services -Payment Services -Financial Services -Insurance -Real Estate Investment Trusts -Real Estate Development -Construction Finance and Private Equity
SKILLS WE PLACE: -Accounting & Finance -Banking Operations & Middle Office -Risk & Compliance -Fund Accounting -PMO -Business Analysts -IT Manager -Cloud Professionals -DBA -Data Specialists -Design -QA & Testing -Developers