Our Toronto based client has been at the forefront of the insurance industry for the past 100 years, and is leading the way in digital innovation for the industry. We have partnered with them to assist in their search for a Data Integration Developer. The developer will will design & develop logical/physical Data integration solutions (Enterprise Data Warehouse, Data Lake/Business Intelligence solutions) that support business objectives and the enterprise’s desire to become data-driven.
Develop an understanding of enterprise and business unit near, medium and long term data and business intelligence needs
Contribute to the definition of planning and solution development methodologies required to deliver logical data warehousing to support business intelligence capabilities
Contribute to the design of target architectures to meet the long term data and information needs of the enterprise
Contribute to the selection and implementation of logical data warehousing technologies required to support the achievement of the target logical data warehouse architecture
Design, develop, test moderately complex to complex ETL processes sourcing data from a variety of internal and external systems
Work closely with the Information Relationship Managers to understand business unit requirements, and assist in their documentation
Support or lead activities relating to end user training, production implementation, transfer of responsibilities to operations, and on-going support of the business intelligence components and solutions
Develop and maintain expertise in leading data warehouse/business intelligence strategies, trends and technologies within and beyond the financial services industry, basic and intermediate statistical analysis methods, and expertise in business intelligence tool-sets
3+ years of experience with data solutions. This includes data lake, data warehousing, data modeling, and data analysis.
Hands on ETL scripting experience.
Strong knowledge of database concepts and the ability to write SQL and understand entity relationship diagrams.
Hands-on experience with enterprise reporting and analysis tools (e.g. Power BI (preference), Spotfire, MS Analysis Services, Tableau, etc.)
Hands-on experience with statistical analysis tools (e.g. SAS Data Miner, R, Orange Data Mining, etc.)
Hands-on experience with programming languages (e.g. Python, Java, etc.)
Hands-on experience with relational databases such as DB2, SQL Server, Progress
Hands on experience with cloud database platforms i.e. Snowflake
Hands on experience with data profiling and data integration tools (e.g. Informatica Data Quality, Data Cleaner, Pentaho Data Integration, Informatica PowerCenter, etc.