Highly skilled Full-Stack Data Engineer, Modernization & Migration to join our Insurance Licensing & Compensation Engineering team, focusing on migrating legacy licensing & compensation capabilities to vendor Platform & Data Lake.
Compensation
Base salary range is expected to be between $86,100.00 CAD - $136,100.00 CAD
Responsibilities
Analyze data structures, relationships, transformations, and business rules across multiple legacy systems, and related upstream and downstream platforms.
Design and develop ETL/ELT pipelines using Informatica, Azure Data Factory (ADF), SQL, or Databricks to support data conversion, integration, and downstream delivery.
Support the migration and conversion of data into the target compensation platform and the Data Lake.
Perform source-to-target mapping, data profiling, cleansing, transformation, validation, and reconciliation throughout the migration lifecycle.
Design and maintain 3NF, dimensional, and analytical data models supporting business processing, reporting, reconciliation, and downstream consumption.
Requirements
Bachelor’s degree in Computer Science, Software Engineering, Data Engineering, or a related field
Develop coding, testing, and debugging to support existing extensions/tools such as IRT, De-Dup, OIA, Immunization Forecaster and PR Upload.
Responsibilities
Conduct technical analysis, preparation of detailed programming specifications, program design, writing and/or generating code, and conduct unit tests
Translate technical specifications for sustainment and upgrade into working, tested applications
Undertake proof of technology with test data to simulate application load and performance tuning related applications
Provide software expertise in various computing platforms, operating systems, database technology, communication protocols, middleware and gateways
Provide impact analysis, effort estimate and solution design/development for supported solutions due to DHIR solution upgrades, software upgrades or any new requirements
Lead the evolution of our custom Salesforce system, architecting, managing, and delivering solutions that empower every area of our business.
Compensation
Hiring salary range for this position is between $140,000 – $150,000.
Responsibilities
Drive Custom Salesforce Development
Champion Integration and Modernization
Strategic Partnership
Full Lifecycle Ownership
Technical Leadership
Requirements
Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field, or an equivalent combination of education and significant, relevant professional experience
Nice to have: Experience with Kinaxis and/or SAP development