Senior Data Engineer

Coalition Inc; Canada; Remote; CAD 90,000 - 130,000; Full time

Job summary

Join Coalition Inc as a Data Engineer to architect scalable data models that support our data-driven decisions. You'll work closely with cross-functional teams to ensure data quality and security, while driving innovation in our analytics practices. This role offers an opportunity to impact a rapidly growing organization while enjoying competitive compensation and comprehensive benefits.

Benefits

100% medical, dental, and vision coverage

Flexible PTO

Annual home office stipend and WeWork access

Mental & physical health wellness programs

Competitive compensation and opportunity for advancement

Qualifications

• 5+ years of experience in data engineering or analytics engineering.
• Hands-on experience with ETL/ELT pipelines.
• Strong programming skills in Python or R.

Responsibilities

• Architect and evolve robust data models.
• Optimize performance and reliability of data delivery.
• Mentor junior team members and promote best practices.

Skills

SQL

Python

Data Modeling

Data Pipeline

Data Governance

Education

Bachelor’s degree in Data Engineering, Computer Science, or related fields

Tools

Snowflake

Apache Spark

Tableau

Job description

Coalition is the world's first Active Insurance provider designed to help prevent digital risk before it strikes. Founded in 2017, Coalition combines comprehensive insurance coverage and innovative cybersecurity tools to help businesses manage and mitigate potential cyberattacks.

Opportunities to make an impact with bold thinking are real—and happening daily at Coalition.

Responsibilities

• Architect, own, and continuously evolve robust, scalable data models that empower all facets of Coalition’s business and support future growth.
• Establish and uphold best practices to ensure data fidelity, metric consistency, and trusted “single source of truth” throughout all data models and business intelligence platforms.
• Serve as a key liaison with Product, Analytics, Engineering, and Business stakeholders to define, implement, and report on KPIs, OKRs, and key business metrics—proactively monitoring for anomalies and insights.
• Drive improvements in our analytics data stack—optimizing performance, reliability, and data delivery as the business and datasets rapidly scale.
• Lead the integration and operationalization of new data sources, building and refining end-to-end ETL/ELT pipelines and distributed data processing jobs.
• Mentor, coach, and provide technical guidance to junior team members, promoting best engineering practices and fostering a culture of excellence and collaboration.
• Champion data security, governance, and privacy compliance in all data engineering initiatives.

Skills and Qualifications

• Bachelor’s degree in Data Engineering, Computer Science, Software Engineering, Information Systems, or a related technical discipline (e.g., Mathematics, Statistics)
• 5+ years of professional experience in data engineering, analytics engineering, or software engineering roles
• Advanced SQL expertise with demonstrated ability to design scalable data models, optimize query performance, and write clear, well-documented code
• Strong programming abilities in Python or R
• Hands-on experience with Snowflake or similar cloud data warehouse platforms
• Proficiency with modern data pipeline and orchestration tools (e.g., dbt, Airflow, Dagster, Prefect)
• Experience with distributed data processing frameworks such as Apache Spark or similar
• Familiarity with streaming ETL frameworks, such as Apache Flink, for real-time data processing
• Experience with data visualization and business intelligence platforms (e.g., Tableau, Looker, or similar)
• Excellent communication skills, with an ability to explain complex technical subjects to non-technical stakeholders
• Demonstrated sense of ownership, passion for data quality and system reliability, and a commitment to building secure, robust data infrastructure

Bonus Skills

• Experience in insurance, insurtech and fintech industries
• Experience in using developer productivity tools and AI-powered assistants such as Cursor for augmented coding to streamline and enhance day-to-day development efforts
• Experience with cloud platforms such as AWS, GCP, or Azure
• Exposure to containerization and orchestration tools like Docker and Kubernetes
• Familiarity with CI/CD processes as they relate to data pipelines and analytics engineering
• Knowledge of data governance, data cataloging, lineage, and security best practices
• Advanced proficiency in additional programming languages (e.g., Scala, Java, Go)
• Advanced knowledge of data modeling concepts (star/snowflake schemas, normalization/denormalization)
• Exposure to data privacy regulations and compliance (GDPR, CCPA, HIPAA, etc.)
• 100% medical, dental, and vision coverage
• Flexible PTO
• Annual home office stipend and WeWork access
• Mental & physical health wellness programs like Headspace, Lumino, and more!
• Competitive compensation and opportunity for advancement

Why Coalition?

Work at Coalition is centered on the joint mission to Protect the Unprotected. We have built a remote-first, highly inclusive culture that welcomes people from diverse backgrounds. We trust each other to take responsibility, share ownership of outcomes, and put in the work together to protect businesses from digital risk. Coalition’s exceptional growth stems from its ability to address real-world problems for organizations of all sizes while remaining true to our founding values of character, humility, responsibility, purpose, authenticity, and inclusion.

We’re always looking for collaborative, inquisitive individuals to join #OurCoalition.

Coalition is committed to protecting your privacy and handling your personal information responsibly. We collect, use, and store personal information as necessary for the recruitment process and in compliance with applicable privacy laws and regulations in all regions where we operate. We want you to understand what personal information we collect, how we use it, and your rights regarding access, correction, and deletion of your data where applicable. Information submitted, collected, and processed as part of your application is subject to Coalition's Privacy Policy. For further details, please review our full Privacy Policy or contact us with any questions regarding how your information is handled.

Coalition is proud to be an Equal Opportunity employer. Our policy is to provide equal employment opportunities to all individuals, without discrimination or harassment on the basis of any characteristic protected by applicable laws in each country where we operate. This commitment includes, but is not limited to, ensuring equal treatment in recruitment, selection, training, promotion, transfer, compensation, and all other aspects of employment. Coalition does not tolerate discrimination or harassment of any kind, and we are dedicated to fostering an inclusive and supportive workplace.

Accommodations

Coalition is committed to providing reasonable accommodations to qualified individuals with disabilities, including applicants and employees, in accordance with applicable laws and regulations in each country where we operate. Our policy is to support equal opportunity in the hiring process by considering qualified applicants regardless of disability or other protected characteristics, unless providing accommodation would impose an undue hardship or disproportionate burden. If you require accommodation to complete an application, interview, pre-employment testing, or participate in the selection process, please contact us at [e-mail]. We also consider all qualified applicants, including those with criminal histories, in line with applicable laws and regulations in each jurisdiction.

To all potential candidates: Coalition primarily does not use third-party recruiting services. Potential candidates will only be contacted by Coalition, Inc. during the recruitment process. You can always verify any opportunity on our official careers page http://www.coalitioninc.com/careers.

To all recruitment agencies: Coalition does not accept unsolicited agency resumes. Do not forward resumes to our email alias, employees, or other physical or virtual organization locations. Coalition is not responsible for any fees related to unsolicited resumes.