Onlia’s mission: Bring clarity to Insurance
Onlia offers innovative digital insurance and a telematics app that incentivises good driving to the Ontario market. Onlia’s mission is to bring clarity to insurance and simplify consumer’s relationship with their insurance company through a digital experience, and best in class customer service. Launched in 2018, Onlia is a joint venture between Achmea, the largest insurance group of the Netherlands, and Fairfax Financial, a Canadian-based financial holding company.
We are here to disrupt insurance in Ontario and are building a team of heavy hitters to make that a reality. We work collaboratively in a fast-paced and agile environment. Every member of our team is empowered to take ownership of their role, and to assist in the build of a best-in-class experience for our customers.
Are you a bright, critical thinker who is looking to solve important business challenges? Are you both business-oriented and technical? We are looking for someone who can work with stakeholders to define measurement needs and can execute on measurement plans through analysis, dashboarding, and modeling. You will also give hands-on support for business units, providing ad-hoc data and analytics outputs as needed. If this sounds like you, keep reading!
We are seeking an experienced ETL/ELT (Extract, Transform, Load) Developer with expertise in Azure Data Factory (ADF) to join our dynamic team. As an ETL Developer, you will be responsible for designing, developing, and maintaining efficient data integration and ETL/ELT processes using Azure ADF. Your role will involve collaborating with cross-functional teams to gather requirements, design data pipelines, and implement scalable solutions to support our data integration needs. You will play a crucial role in ensuring the quality, reliability, and performance of our data processing workflows.
Key Accountabilities:
KA 1 Develop, test, and maintain ETL processes and data integration workflows using Azure Data Factory (ADF) and related technologies.
KA 2 Implement efficient data pipelines to extract, transform, and load data from various sources into target systems or data warehouses.
KA 3 Collaborate with data engineers, data analysts and business stakeholders to gather requirements and translate them into technical specifications for ETL workflows.
KA 4 Perform data profiling, cleansing, and transformation to ensure data accuracy, consistency, and integrity throughout the ETL process.
KA 5 Monitor, troubleshoot, and resolve issues related to data integration, ETL processes, and job failures to ensure smooth and uninterrupted data flow.
KA 6 Writing stored procedures, functions, and queries in SQL or a relevant database language.
KA 7 Implement data quality controls and validation checks to identify and address data anomalies, inconsistencies, or errors.
KA 8 Develop and maintain documentation, including technical specifications, data mappings, and workflow diagrams.
KA 9 Experience working with version control systems and following software development best practices for code management and collaboration.
Qualifications and Competencies 5+ years proven experience as an ETL Developer, Data Engineer, or similar role, with expertise in designing and developing data integration solutions using Azure Data Factory (ADF). Proficiency in SQL and experience working with relational databases, data modeling, and query optimization. Strong understanding of ETL concepts, data warehousing principles, and data integration patterns. Familiarity with data modeling tools and techniques, such as ER diagrams, dimensional modeling, and star schemas. Understanding of data integration patterns and techniques, including change data capture (CDC), incremental loading, and data synchronization. Knowledge of Microsoft Azure platform, including Azure Data Factory, Azure Data Lake, Azure SQL Database, and Azure Storage. Self-motivated, proactive, and able to work independently with minimal supervision. Experience with other data integration and ETL tools, such as SSIS, Informatica, or Talend, is a plus. Familiarity with cloud computing concepts, particularly in Azure, and understanding of cloud-based data integration and analytics services. Strong problem-solving skills and ability to troubleshoot and resolve complex data-related issues. Excellent communication skills and ability to collaborate effectively with cross-functional teams. Strong attention to detail and commitment to deliver high-quality solutions within deadlines.
Nice to Have Experience working with Microsoft Power BI Expertise with PostgreSQL
Indicators of Success Critical thinking – The ability to generate meaningful analytic insight in the face of ambiguity and lack of clear direction. Mental flexibility – The ability to quickly pivot between different projects, ideas, and solutions as the business needs and as priorities shift. Attention to detail – Creation of deliverables that are of high business value, impeccably accurate, and delivered in business-friendly language.
WORKING AT ONLIA
Our aim is to create a workforce that is diverse, promotes positivity, and demonstrates the values of equality, fairness, and respect in everything we do. We are dedicated to an anti-discrimination approach and provide equal opportunity for employment and advancement throughout Onlia regardless of gender, race, ethnicity, national origin, age, sexual orientation or identity, education, or disability. We respect and value diverse life experiences and cultures and ensure that all voices are valued and heard.
Onlia welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.