Senior Data Engineer - Data Insights

Role Description

Data is the fuel behind Appfire's global footprint. We’ve grown fast, and now our focus has shifted toward building the most mature, high-performing data platform in our industry. 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. Leveraging your expert Python, SQL, and cloud infrastructure skills, you will develop pragmatic architectures that ensure stability and performance across the organization.

As a key member of our central data insights team, you will evolve our custom data lake ("firelake" built on AWS and Snowflake). To accelerate our platform optimization efforts, you will ruthlessly eliminate technical debt, resolve edge cases, and introduce modern, AI-driven development practices. This isn't just about maintaining pipelines; it's about architecting a highly secure, resilient, and scalable foundation that empowers company-wide decision-making.

If you love solving complex data puzzles, driving overarching data strategy, and seeing the direct impact of your work across an entire organization, let's talk.

Qualifications

• 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.
• 5+ years of experience autonomously building scalable data products, pipelines, and solutions that support company-wide systems and overarching business goals.
• Exceptional personal organization and multitasking skills, with the ability to work with minimal supervision while driving 3-5 concurrent cross-departmental projects.
• 5+ years of advanced SQL optimization and complex ETL/ELT pipeline development, with extensive, hands-on experience in Snowflake.
• 5+ years of advanced Python programming.
• 5+ years of experience designing and maintaining AWS cloud environments. Strong, hands-on proficiency with Terraform and Docker is required.
• Deep operational experience with Airflow for orchestration, dbt (3+ years) for transformation, and familiarity with managing Fivetran pipelines.
• Proven ability to design pragmatic, cost-effective architectures from scratch that prioritize security, scalability, and high performance without over-engineering.
• Incredibly strong troubleshooting skills with a ruthless dedication to reducing technical debt, optimizing CI/CD pipelines, and enforcing strict version control and testing standards.
• Solid understanding of modern data governance principles, including automated data classification, PII masking, and row/column-level access controls.
• 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.
• A team-oriented mindset with a passion for coaching and providing constructive feedback to junior team members.

Requirements

• 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.
• 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.
• Develop standard integration patterns as well as custom data pipelines that interface with atypical APIs to efficiently extend our data delivery capabilities.
• Architect and maintain highly efficient, cost-effective scalable data solutions and cloud infrastructure from scratch.
• Be the key driver in the evolution of our custom data lake ("firelake" built on AWS/Snowflake), serving as the ultimate subject matter expert on our tech stack and data infrastructure.
• 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.
• Spearhead AI adoption in our daily engineering workflows to automate Pull Requests, enforce new "definition of done" standards, and accelerate CI/CD, test coverage, and release management.
• 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.
• 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.
• Implement advanced PII management by leveraging automated data classification techniques, applying masking policies, and enforcing sophisticated row-level and column-level security practices.
• Develop and deploy robust monitoring solutions and governance strategies to ensure accurate, secure data is available on time and to the correct audience.
• Autonomously lead 3-5 concurrent cross-departmental data projects, driving everything from requirements gathering and UAT to production deployment.
• Partner seamlessly with business, analytics, and engineering teams, translating complex technical architectures into relatable concepts to influence stakeholders and align goals.
• Champion best practices, systematically reduce technical debt, write clear documentation, and provide both technical and soft-skill mentorship to junior team members.

Benefits

• 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.
• 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. After 5 years of employment, employees receive 30 days 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.
• Every employee receives 3 fully paid days each year to participate in Appfire Town, our Corporate Social Responsibility (CSR) program supporting local communities.