BI Solutions Consultant

17 Edith Dr, Toronto, ON M4R 1Y9, Canada, Full Time

First Derivative is a leading provider of products and consulting services to the capital markets industry, with over 2700 staff globally. First Derivatives (FD) is a provider of regulatory and IT consulting services to the capital markets industry as well as high-performance time series database software. The combined proposition gives FD a differentiated offering within capital markets, an industry increasingly challenged by regulation and data management. Additionally, FD has begun to establish itself in a number of industries outside of capital markets.About This RoleThe successful candidate will work with the Business Intelligence development team with a focus on Database and ETL script execution as well as Cognos and Tableau Reporting.

Strong SQL anddatabase skills are required. The individual will be responsible for all interface file loading to the ETL as well as transformation of data to defined outputs. The individual will be responsible for implementing business rules by designing and developing Source-To-Target-Mappings, Data Extraction Rules and ETL processes and tools to enable cleansing, transformation and loading of data into the Data Warehouse.BI Solutions ConsultantJob Requirements What can you bring to the bank?. It helps if you have:Must have skills: · 5 years of experience in Database/SQL skills in one or more popular database technologies preferably SQL Server, DB2, Oracle, PostgreSQL, and Mongo· Solid understanding of networking basics· 3 years of experience with Linux/Unix/Windows· 3 years of experience with SSIS or other ETL tool· Experience working with Cognos – (creating new reports, setting up automation using the internal scheduling tool and Events, Knowledge of Cognos 11 Administration including installation & configuration, permissions, and data connections etc.)· Familiarity with query analysis and performance tuning techniques on the SQL Server/Oracle platforms· SDLC/Agile methodology experience including familiarity with Atlassian tools (Jira, Confluence, and Bitbucket)· Experience writing and reviewing Python and or C#/VB code· Solid experience with scheduling tools like Autosys· Excellent Analysis and Design skills with verbal and written communication skills with strong analytical, problem-solving, and collaborative skills.· Excellent interpersonal skills to effectively interface with customers, team members, and other colleagues.Nice to have skills:· Knowledge of Tableau Administration including publishing, permissions, and data connections· Experience working with xml and JSON data via database tables and REST APIs· Experience with big data solutions like Hadoop using Hive and Spark· Working experience with testing tools like Jenkins· Knowledge of workflow tools like Alteryx.KXKX technology is designed to capture and analyse 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.Who are we?FD Technologies plc (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).



Apply for this Job

To apply, please visit the following URL:→