Data Engineer Department: Équité Association Location: Remote (based in Canada) Status: Full-time / Permanent Posting Date: 2023-02-13T05:00:00Z Expiry Date: About Équité AssociationAs a not-for-profit organization, Équité Association supports Canadian insurers to fight fraud by using advanced analytics, intelligence best practices, and coordinated investigations. Combining expert investigative services and advanced analytics, Équité serves as a unified organization, delivering improved service and fraud analytics for vehicle and cargo recovery. Leveraging relationships with law enforcement, partners and industry organizations, Équité serves as a centre point for insurance crime across all insurers, and is protecting Canadians by working to eradicate insurance fraud and crime. Équité, is invested in diminishing crime in Canada, and protecting all Canadians against exploitation.About the RoleWe use a wide range of data and intelligence to achieve four objectives: Help insurers identify fraud through integrated advanced analytics and investigations; Enhance and enable cross-insurer investigations coordinated by Équité; Lead stakeholder in vehicle and hard-asset recover & identification services; andSupport law enforcement, regulators, professional colleges and other public investigative agencies to identify criminals and bring them to justice. We will also endeavour to raise public awareness about consumer scams: how they work and how to detect and prevent them. The Data Engineer, reports to the Director, Head of Technology Solutions and requires the ability to anticipate needs, think critically, and offer solutions to problems with a high level of professionalism and confidentiality. The Data Engineer role is primarily responsible for providing technical and data leadership for the application development team(s). Working with the Director, Head of Technology Solutions and the data & analytics team, the role will ensure best practices in creating and maintaining data architecture and related standards to ensure the foundation which reflects the data needs and concerns of the members.The position offers a motivated, astute person the opportunity to have an indelible impact on the organization's evolution—an organization focused on creating a vibrant, accessible culture that welcomes open discourse, supports the members, and balances technology, process and people. Specific accountabilities include:Create and maintain data architecture, data management standards and conventions, data naming standards, and metadata standards to ensure effective availability, scalability, security, and integrity of data assetsDevelop and maintain conceptual, logical and physical data modelsSetup the physical data model including all physical database configurations such as indexes, tablespaces, table partitions, table constraints, and relationshipsDesign, build and implementation of data pipelines onto AWS from a variety of input data source formats, frequencies and latenciesOwn the data mapping, business logic, transformations and data qualityMaintain and support existing platforms and evolve to newer technology stacks and architecturesUtilize AWS exciting features to help drive rapid business insights and leverage stronger analytical and data science capabilitiesWork closely with our Data Science and Analytics teams to leverage opportunities within our data for insights and business valueWork with a broad base of business stakeholders, vendors and insurance members in a highly collaborative environmentOther projects/duties as assigned for the overall benefit of the organization and its partners.Qualifications 5+ years of experience as a data or software engineer, including not-for-profit or NGO areasBachelors Degree; MS in Computer Science preferredStrong design & hands-on experience with DBMS (SQL Server), Hive and Spark Experience with data modelling and Data Model Driven ApproachExperience with AWS/Azure Cloud environmentProficiency in PythonPassion for engineering and maintaining data repositories to enable analytics and machine learningStrong organizational, collaboration, planning and communication skills. Impeccable attention to detailResults-focused approach and strong work ethicEnergized by a fast-paced environment Able to maintain a high level of integrity and discretion in handling confidential information. Scientific mind set to solve problemsExperience in the P&C insurance industry a strong assetComfortable and excels within remote workPlease send resume to:Équité AssociationE-mail: firstname.lastname@example.orgÉquité Association is committed to providing accommodation for people with disabilities. Applicants need to make their needs known in advance. Please be advised that only those applicants who are selected for interviews will be contacted.We encourage applications from all backgrounds and communities. We highly value our diversity and inclusion culture and welcome all candidates, including women, BIPOC, LGBTQ2S+ and allies.