Appfire

Appfire

Senior Data Engineer - Data Insights

Canada · Senior

Sponsorship not specifiedDetected 2 days ago
PythonCode ReviewSQLSnowflakeAWSCloud PlatformsDockerTerraformCI/CDMachine LearningAirflowdbtData EngineeringLLMsAgentic AIMLOpsCybersecurityAgileJiraCustomer SuccessLeadershipCommunicationCollaborationMentoring

About the role

  • Data is the fuel behind Appfire's global footprint.
  • We are looking for a Senior Data Engineer to take ownership of our core infrastructure, champion engineering excellence, and help shape the future of our data ecosystem.
  • As a key member of our central data insights team, you will evolve our custom data lake ("firelake" built on AWS and Snowflake).

Responsibilities

  • Solution Lifecycle Ownership: Own the complete solution development lifecycle, from driving initial requirements to building Proof of Concepts (POCs) and Minimum Viable Products (MVPs), and continuously iterating to improve and scale production solutions.
  • Data Delivery & Pipelines: Work closely with internal and external partners to stand up and optimize robust data delivery solutions. Build, manage, and scale complex data pipelines (ETL and reverse ETL) utilizing expert-level Python and Airflow.
  • Custom Integrations: Develop standard integration patterns as well as custom data pipelines that interface with atypical APIs to efficiently extend our data delivery capabilities.
  • Pragmatic Architecture: Architect and maintain highly efficient, cost-effective scalable data solutions and cloud infrastructure from scratch.
  • Ingestion & Data Quality: Manage Fivetran and custom pipeline operations, proactively handle schema drift, and implement rigorous data quality checks to ensure we have ingested a true and accurate representation of all source systems.
  • AI Implementation: Drive the integration of AI capabilities directly into our data solutions by interfacing with LLMs and developing intelligent assistants and agents to solve complex business problems.
  • Continuous Innovation: Stay on the forefront of the rapidly evolving data landscape and drive proof-of-concepts for new tools to ensure we leverage best-in-class technologies to scale quickly.
  • PII & Security Management: Implement advanced PII management by leveraging automated data classification techniques, applying masking policies, and enforcing sophisticated row-level and column-level security practices.
  • Work in a product-first SaaS B2B environment focused on building and scaling solutions for large enterprise customers
  • Deliver meaningful, high-impact work that directly influences product direction and customer success

Requirements

  • Engineering Background: 5+ years in a data or software engineering role with a deep understanding of the full data lifecycle, modern data warehousing, and agile software development best practices.
  • Proven Delivery: 5+ years of experience autonomously building scalable data products, pipelines, and solutions that support company-wide systems and overarching business goals.
  • Project Leadership: Exceptional personal organization and multitasking skills, with the ability to work with minimal supervision while driving 3-5 concurrent cross-departmental projects.
  • Technical Expertise
  • Data Warehousing & SQL: 5+ years of advanced SQL optimization and complex ETL/ELT pipeline development, with extensive, hands-on experience in Snowflake.
  • Advanced Python & Development: 5+ years of advanced Python programming.
  • Cloud Infrastructure & IaC: 5+ years of experience designing and maintaining AWS cloud environments.
  • Strong, hands-on proficiency with Terraform and Docker is required.
  • Orchestration & Ingestion: Deep operational experience with Airflow for orchestration, dbt (3+ years) for transformation, and familiarity with managing Fivetran pipelines.
  • Strategic Communication: Strong written and verbal skills, with a proven ability to translate and simplify complex technical architectures to both engineering peers and non-technical business stakeholders.

Skills

  • Data Governance & Security

Compensation

  • After 5 years of employment, employees receive 30 days per year.

Benefits

  • Every Appfire team member is eligible for company equity, fostering a true sense of ownership and connection to our growth.
  • Employees receive 25 days of paid time off per year.
  • Appfire provides comprehensive coverage through Empire Health, including medical, dental, and vision insurance.
  • Additional protection includes life insurance, critical illness coverage, accidental death and dismemberment, and long-term disability insurance.
  • To promote health and well-being, Appfire offers a yearly sport allowance of CAD 600, which can be used to cover the cost of various fitness or outdoor activities from gym memberships to sports equipment.
  • Our commitment extends to all employment practices, including recruitment, hiring, training, promotion, compensation, benefits, and termination.
  • Bonus Points (Standout Qualifications)

Company info

  • This isn't just about maintaining pipelines; it's about architecting a highly secure, resilient, and scalable foundation that empowers company-wide decision-making.

Equal opportunity

  • Equal Employer Opportunity (EEO)
Apply directly at Appfire →Create a free account for alerts like thisView Appfire immigration profile

This listing is sourced directly from Appfire's careers page and normalized into a canonical job model.