Data Engineer

We currently have a Full-time permanent position available for a Data Engineer in our Information Technology Department. The position will report to the Software Development Manager. If you are passionate about the ability for technology to drive business performance and you love working various stakeholders to define and craft solutions that delights end users, this role is for you.

Peace Hills Insurance has a strong history of leveraging technology to enable our business partners to delivery world-class service to our customers. The priority for this role will be for the design and development of the Enterprise Data Warehouse (or equivalent technology) to serve the needs of our data analysts and developers. The role is responsible for designing and building all processes required to maintain and extract data from source systems, transform it according to business rules, and load it into appropriate data models.

PHI is currently implementing a new core technology platform and this role will be initially assigned to support that project.


The successful candidate in this role will have these characteristics:

  • High Say-Do Ratio: You do what you say you will do and follow through with commitments. We measure our success not on our plans but on our ability to successfully execute and deliver value to the
  • Masterful Multi-Tasker: You balance competing priorities and are able to meet your commitments across multiple
  • Active Problem Solver: When you see an issue that has an ability to impact your projects you jump in to resolve the issue to keep the projects on
  • Innately Inquisitive: You love to tackle a new challenge and learn all about it from every perspective.
  • Technology Aficionado: The application of technology to solve business problems is one of your passions. You can look at a business problem and understand how technology can be used to deliver amazing staff, partner, and customer
  • Natural Communicator: You distill complex concepts and problems into clear and easy to understand communications for individuals at all levels of the
  • Team Player: You recognize that large transformations are only successful when a team is working together effectively.
  • Proven Performer: You have a history of success in large technology-based You have a history of successfully leading data centric projects for complex technology driven transformations.


Your time will be spent:

  • Designing and developing the enterprise analytics data warehouse (or equivalent technology).
  • Building and maintaining ETL pipelines that harvest data from operational systems and load the data into the warehouse.
  • Working with Business Analysts and Developers to ensure the warehouse contains the appropriate data models to handle both analytical and system reporting needs.
  • Ensuring that data security and access to data is applied as warranted.
  • Working with 3rd party vendors to ingest and publish bulk data into and out of the warehouse as required.
  • Administrating all aspects of the warehouse as required, including availability monitoring, performance monitoring, retention planning, user access, disaster planning, etc.
  • Working with development teams to ensure future data model changes in operational systems are incorporated into the warehouse.
  • Ensuring standards and best practices are incorporated into data solutions.

Prior experience and qualifications of interest include:

  • Post-secondary degree in business, information technology, or related field
  • 10 years of experience working in a similar role responsible for EDW Development
  • Experience in the implementation of Data Warehouse/Data Lake and ETL concepts in the cloud
  • Experience with SQL Server, including exceptional understanding of structured storage concepts
  • Exceptional understanding of big data storage concepts and applicable use of related technologies
  • Exceptional communication skills across a range of forums and channels and stakeholders
  • Understanding and experience with unstructured data and related technologies would be considered an asset
  • Experience in highly regulated industries/financial services; experience in the insurance industry would be considered an asset


Working at Peace Hills

Peace Hills understands that by reducing work-life struggles, individuals can enjoy a healthier lifestyle while improving productivity at work. Ensuring an appropriate work/life balance and a collegial and supportive work environment are just a couple of ways we do this.


If you are interested in this great opportunity, submit your resume to Peace Hills Insurance at

We thank all applicants for their interest, however only those candidates shortlisted will be contacted.


Application Deadline: July 11, 2022