Data Engineer/Analyst

2 weeks ago

Canada Southampton Financial Inc Full time

Southampton Financial's Mission: Bring Clarity to Insurance

Southampton Financial is a value-added strategic investor in the Canadian property and casualty distribution space. We are the majority equity owner of Alteri Insurance and have acquired Onlia Insurance and aha insurance in recent months. Our goal is to build the insurance brokerage of the future by combining leading-edge technology with high-quality brokers catering to the overall insurance needs of Canadians by providing them with customized solutions to suit their individual needs.

At Southampton Group of Companies, we're not just merging companies; we're fusing expertise, innovation, and a relentless commitment to excellence. Our purpose is clear: to disrupt the insurance landscape in Canada. As we assemble a team of industry heavyweights, our goal is to make this vision a reality. In our collaborative, fast-paced, and agile environment, we strongly believe in empowering every member of our team to take ownership of their role. Together, we're dedicated to building a best-in-class experience for our customers.

Job Description

We are seeking a high-skilled and experienced all-round Data Engineer/Analyst to join our dynamic team. As a fully empowered data specialist you will play a pivotal role in shaping the technical direction and core backbone of our business from a data perspective

You will be involved in all aspects of data, including the building of pipelines/data warehouse, analysis and trending of data, and the visualization of that data in reports/dashboards.

Key Accountabilities:

  • Design and implement scalable and efficient data pipelines to extract, transform, and load data from various sources into target systems or data warehouses.
  • Collaborate with data engineers, data analysts and business stakeholders to gather requirements and translate them into technical specifications for ETL workflows.
  • Perform data profiling, cleansing, and transformation to ensure data accuracy, consistency, and integrity throughout the ETL process.
  • Writing stored procedures, functions, and queries in SQL or a relevant database language.
  • Data modeling and designing efficient database schemas for data warehouses or data marts.
  • Implement data quality controls and validation checks to identify and address data anomalies, inconsistencies, or errors.
  • Develop and maintain documentation, including technical specifications, data mappings, and workflow diagrams.
  • Experience working with version control systems and following software development best practices for code management and collaboration.
  • Perform deep dive analysis of customer data to identify key demographics.
  • Analysis of website traffic to understand how our sites are used, user engagement and conversion tracking etc.
  • Visualization of data through dashboards and reports

Qualifications

You Have:

  • 3+ 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) or AWS Glue.
  • 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.
  • Experience in parsing and transforming semi-structured data – JSON, XML.
  • Experienced in data integration patterns and techniques, including change data capture (CDC), incremental loading, and data synchronization.
  • Proficiency in SQL and experience working with relational databases, data modeling, and query optimization.
  • Advanced skills in data analysis using Python – experience working with different formats – xml, web API calls, Excel.
  • Proficient working with No SQL databases such as MongoDB.
  • Experience with data visualization tools such as Power BI for both static and dynamic reporting.
  • Well versed in Google Analytics.
  • Solid understanding of statistical analysis, hypothesis testing, and experimental design.
  • Experience with data wrangling, cleaning, and manipulation.
  • 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.
  • Self-motivated, proactive, and able to work independently with minimal supervision.

Nice To Have:

  • Familiarity with Property & Casualty Insurance/Brokerage domain

  • Data Engineering Specialist

    19 hours ago

    Canada Data Elephant Full time

    About UsData Elephant is a boutique data and analytics consulting firm based in Vancouver, BC. We help Canadian organizations develop data strategies, modernize their data platforms, and unlock the power of data, analytics, and AI.We're looking for a Cloud Data Solutions Architect to join our growing team. In this role, you'll contribute to the design,...

  • Databricks Data Engineer

    3 days ago

    Canada Data Elephant Full time

    About UsWe're a boutique data and analytics consulting firm based in Vancouver, BC, helping Canadian organizations develop data strategies, modernize their data platforms and unlock the power of data, analytics, ML and GenAI. As a certified partner with leading cloud platforms, including AWS, Azure and Databricks, we deliver strategic solutions that create...

  • Databricks Data Engineer

    1 day ago

    Canada Data Elephant Full time

    About Us We're a boutique data and analytics consulting firm based in Vancouver, BC, helping Canadian organizations develop data strategies, modernize their data platforms and unlock the power of data, analytics, ML and GenAI. As a certified partner with leading cloud platforms, including AWS, Azure and Databricks, we deliver strategic solutions that create...

  • Data Engineering Lead for Cloud Data Platforms

    3 days ago

    Canada Data Elephant Full time

    About Data ElephantWe're a boutique data and analytics consulting firm based in Vancouver, BC, helping Canadian organizations develop data strategies, modernize their data platforms, and unlock the power of data, analytics, ML, and GenAI.Our MissionWe deliver strategic solutions that create real business impact. Our team thrives on solving complex...

  • Senior data engineering analyst

    2 days ago

    Canada National Bank Full time

    A career as a Senior Data Engineering Analyst in the Cross-Functional Cybercrimes Data team at National Bank means acting as an analytical data specialist. You will work on data engineering projects such as designing databases, creating data pipelines for data ingestion, cleansing, and transformation, as well as optimizing the performance of data processing...

  • Data Engineer

    1 day ago

    Canada NXT Move IT Solutions Inc Full time

    Company DescriptionNXT Move IT Solutions Inc. is a Toronto-based company providing cutting-edge IT services, expert consulting, and technology recruitment solutions across North America. We specialize in application development, cloud architecture, DevOps engineering, cybersecurity, data platforms, and enterprise systems. Serving clients locally and...

  • Data Engineer

    2 weeks ago

    Canada hireVouch Full time

    Our client is a leading data and cloud services provider that works with enterprise companies to build systems and infrastructures for them. As a Data Engineer, you'd be responsible for designing, building, and optimizing data pipelines, ensuring seamless data flow and analytics capabilities. This is a 6-month contract, with a possibility of extension. ...

  • Data Engineer

    2 weeks ago

    Canada hireVouch Full time

    Our client is a leading data and cloud services provider that works with enterprise companies to build systems and infrastructures for them.As a Data Engineer, you'd be responsible for designing, building, and optimizing data pipelines, ensuring seamless data flow and analytics capabilities.This is a 6-month contract, with a possibility of...

  • Data Analyst

    3 days ago

    Canada Insight Global Full time

    Insight Global is seeking a Business Analyst for one of our largest technology clients. The Business Analyst will perform data analysis and interpret information to provide management with insights and assist with decision-making and other functions. This individual will play a pivotal role in reporting, especially in building custom reports and bridging the...

  • Data Engineer

    2 weeks ago

    Canada Summer Full time

    Title: Data EngineerLocation: Remote CanadaAbout this Role: As a Data Engineer, you will play a crucial role in designing, building, and optimizing our data infrastructure. You'll be responsible for developing scalable data pipelines, implementing ETL processes, and ensuring the quality and integrity of our data. Your expertise will contribute to the success...

  • Data Engineer

    2 weeks ago

    Canada Summer Full time

    Title: Data Engineer Location: Remote Canada About this Role: As a Data Engineer, you will play a crucial role in designing, building, and optimizing our data infrastructure. You'll be responsible for developing scalable data pipelines, implementing ETL processes, and ensuring the quality and integrity of our data. Your expertise will contribute to the...

  • Data Engineer

    3 weeks ago

    Canada KData AI Full time

    Company DescriptionKData AI is a leading firm in Data and AI Engineering in the cloud, dedicated to delivering exceptional results for businesses worldwide. We specialize in transforming data into actionable insights through innovative AI and engineering solutions. Follow us on Twitter: @KDataAI.Role DescriptionThis is a full time role for a Data Engineer....

  • Data Engineer

    3 weeks ago

    Canada KData AI Full time

    Company DescriptionKData AI is a leading firm in Data and AI Engineering in the cloud, dedicated to delivering exceptional results for businesses worldwide. We specialize in transforming data into actionable insights through innovative AI and engineering solutions. Follow us on Twitter: @KDataAI.Role DescriptionThis is a full time role for a Data Engineer....

  • Data Analyst

    3 days ago

    Canada iA Groupe financier iA Financial Group Full time

    Are you passionate about data? Would you like to have a leadership role while being responsible for delivering business intelligence and artificial intelligence solutions to multiple business sectors? We have the right opportunity for you. This position will have several stimulating challenges, including responsibility for proposing and implementing...

  • Data Engineer

    3 weeks ago

    Canada Insight Global Full time

    Job Title: Data Engineer Job Type: 5 month contract + possibility of extension, Fully Remote Canada/US Job Salary: $55 - $75 / Hour (CAD) Job Description Day-to-day: Insight Global is seeking an experienced data engineer to join a marketing data analytics team to build and maintain the database infrastructure using software engineering best practices,...

  • Data Engineer

    4 weeks ago

    Canada Insight Global Full time

    Job Title: Data EngineerJob Type: 5 month contract + possibility of extension, Fully Remote Canada/USJob Salary: $55 - $75 / Hour (CAD)Job DescriptionDay-to-day: Insight Global is seeking an experienced data engineer to join a marketing data analytics team to build and maintain the database infrastructure using software engineering best practices, data...

  • Senior Data Analyst

    3 weeks ago

    Canada eLocal Full time

    Position: Sr. Data AnalystLevel: Mid-SeniorLocation: Remote (Applicants must reside in one of the following Canadian provinces: Alberta, British Columbia, or Nova Scotia).eLocal, part of Brookfield Asset Management, is a fast-growing and profitable national leader in pay-for-performance digital advertising. We connect millions of local consumers each year to...

  • Python Data Engineer

    3 weeks ago

    Canada High 5 Games Full time

    Position Overview:As a Python Data Engineer at High 5 Casino, you will be responsible for designing, implementing, and maintaining data pipelines, databases and our in-house real-time player interaction software. You will collaborate with cross-functional teams to ensure seamless data integration, support data-driven decision-making, and contribute to the...

  • Data Engineer

    6 days ago

    canada | ca hireVouch Full time

    Our client is a leading data and cloud services provider that works with enterprise companies to build systems and infrastructures for them.As a Data Engineer, you'd be responsible for designing, building, and optimizing data pipelines, ensuring seamless data flow and analytics capabilities.This is a 6-month contract, with a possibility of...

  • Big Data Pipeline Developer

    10 hours ago

    Canada Data Elephant Full time

    About the Role:We're looking for a Data Engineer to join our growing team. As a key member of our data engineering team, you will be responsible for designing, developing, and deploying modern data solutions using Azure, AWS, and Databricks.Your primary focus will be on building scalable and efficient data pipelines that meet the needs of our clients. You...