Senior SQL Developer

Who are we?First Derivatives (FD) is a leading software and services company, with world-leading intellectual property in ultra-high-performance analytics (KX) across industries, and extensive domain expertise and capabilities in capital markets systems and technology (managed services and consulting).Client: CPPIB Role: Senior SQL Developer - Capital MarketsLocation: Toronto (Hybrid) 4 days/week ONSITEContract: 6 months to start plus multiple extensionsJob Description:We are seeking an SQL Developer to join our stimulating and dynamic team. The ideal candidate will have a deep understanding of ETL and SQL and compatible coding languages (SQL, Python, VBA, etc); as well as investment compliance monitoring. Experience in capital markets (either front, middle, or back office) is a must. This position requires excellent analytical skills and a self-starting attitude. Exposure to Shareholding Disclosure tools and related applications (e.g., Aosphere Rulefinder, FundApps, Bloomberg, etc.) is an asset.Responsibilities:1. Develop, implement, and optimize ETL processes, executing related tasks such as extraction, transformation, loading, integration, and error handling.2. Understand market data from sources such as Bloomberg, MarkIT as well as RIMES; and leverage technical skill set to perform complex analyses on large volumes of unstructured data to investigate and resolve exceptions.3. Gather, interpret and document complex business line information to support decision-making as well as target state employee training, adapting as needed.4. Collaborate closely with cross-functional stakeholders to ensure developed solutions are duly tested and fulfill specified business requirements.5. Contribute to the design, development, and implementation of data warehouse and data integration solutions.6. Provide training to compliance monitoring team, documenting material in a playbook structure.7. Continuously seek opportunities to improve processes and technologies. Qualifications:1. Bachelor's degree in computer science, Information Systems, or a related field.2. Proven experience working with SQL, SQL Server, Oracle and (ETL tools (DataStage, SQL/PLSQL, Talend); Scheduling tools (JAMS); Tidal and Database (Oracle).3. Experience with investment compliance monitoring (shareholding disclosure, etc.)4. Excellent analytical and problem-solving skills.5. Ability to work independently and as a part of a team.6. Strong communication skills, both written and verbal.7. Detail-oriented and excellent organizational skills.KX technology is designed to capture and analyze data to make real-time decisions in a world where data volumes generated by markets and machines are increasing exponentially, and existing technologies fail due to technological or commercial limitations.KX is widely adopted throughout the financial industry, and is poised for accelerated growth across high-tech manufacturing, automotive, oil and gas, utilities and telecommunications.Managed Services and ConsultingFD provides a range of services worldwide to its clients in the capital markets sector, including many of the world's leading banks, focused on supporting mission-critical systems as well as helping them to achieve and maintain regulatory compliance.FD provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. Financial Services,Banking,Capital Markets