[Remote] Senior Data Engineer - Data Insights

Note: The job is a remote job and is open to candidates in USA. Appfire is a software company that empowers teams to collaborate seamlessly. They are seeking a Senior Data Engineer to take ownership of their core infrastructure, develop architectures for their data platform, and drive AI adoption in engineering workflows.

Responsibilities

• 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
• 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)
• 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

Skills

• 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
• Experience in or foundational knowledge of MLOps. You can provide recommendations and establish best practices to guide our strategic expansion into this space
• Experience interfacing with LLMs, creating AI agents, or leveraging AI tools to accelerate daily engineering workflows (e.g., automating code reviews, CI/CD enhancements)

Benefits

• Every Appfire team member is eligible for company equity, fostering a genuine sense of ownership and shared success as we continue to grow.
• Unlimited Paid Time Off (PTO)
• 10 paid company holidays annually
• Medical insurance fully covered by Appfire (100% employer-paid)
• Dental insurance with costs shared 50/50 between Appfire and employees
• Vision insurance
• Group Term Life Insurance
• Voluntary Life Insurance
• Critical Illness coverage
• Accident Insurance
• Long-Term Disability coverage
• Employee Assistance Program (EAP)
• Employees are eligible for fitness and wellness reimbursements through our benefits provider.
• Appfire University, our custom on-demand learning platform designed to support continuous professional development.
• Three fully paid volunteer days per year to participate in our Corporate Social Responsibility (CSR) initiatives and support local communities.
• Flexible Spending Accounts (FSA)
• Monthly remote-work stipend
• Dedicated Amazon account for ordering approved equipment and peripherals
• Competitive 401(k) plan with company matching to help build long-term financial security
• This role is fully remote and can be performed anywhere within the United States.
• Appfire also offers access to our offices in Boston, Burlington, and New York.

Company Overview