Senior Data Analytics Engineer - Data Insights

In this role you will build, define and activate Appfire's company-wide data asset (Snowflake) from ground up data sources. You will work with stakeholders across Appfire to integrate, test, connect, and build brand new data and metrics within our Snowflake metrics layers, achieving a trusted, accessible and well-defined view of information across the company.

Our Analytics Engineers build metric foundations for reporting, analysis and experimentation, pushing the boundaries of decisions across the company under an aligned view of the world. They leverage their expertise in metric development, DBT, data modeling, SQL and Python. Using these skills you will transform data from raw data warehouse into data artifacts powering impactful analytic use cases (e.g. metrics, dashboards, adhoc analysis and self-service solutions) that enable and push the boundaries of decisions across the company. As an Analytics Engineer you will sit at the intersection of business and data, working collaboratively to enable and achieve meaningful outcomes by evolving our ecosystems to scale impact. We're growing quickly and have a lot to accomplish.

What You Will Do:

• Understand decision needs by interfacing with fellow Analytics Engineers, Data Engineers, Data Analysts and Business Partners
• Architect, build, and launch efficient & reliable data models and pipelines in partnership with Data Engineering, leveraging DBT and Snowflake
• Design and implement metrics and dimensions enabling self-service analysis and structured views of Appfire's KPI's that scale trust, accountability and decision impact
• Define and share best practices on metric, dimension, and data model development and definitions for analytics use cases, * Private health insurance through IMQ or Adeslas, fully covered by Appfire for enrolled employees
• Family members may also be added at a discounted rate through payroll deduction
• €400 gross annual sport allowance for gym memberships, outdoor activities, sports equipment, running gear, and other wellness-related expenses

Work-from-Home Support - Appfire provides €50 per month to help cover home office and remote work expenses.

Community & Volunteering - Employees receive 3 fully paid volunteering days each year through Appfire Town, our Corporate Social Responsibility (CSR) program supporting local communities.

Do you have experience in SoC?, * 5+ years of relevant industry experience

• Passion for high data quality and impactful analytics engineering work
• Expert SQL skills for data modeling and query optimization.
• Extensive experience with self service, advanced analytics, semantic and metrics layers
• 3+ Years of Experience with Python and DBT
• Strong understanding of data warehousing concepts and best practices.
• Efficient problem-solving and analytical skills
• Proven ability to succeed in both collaborative and independent work environments at a remote-work company
• Proven experience managing concurrent complex data projects from start to finish
• Continuous learner with an eye on industry trends and new technologies.
• Excellent communication and documentation skills with the ability to explain technical concepts to a non-technical audience.
• Ability to effectively leverage AI tools and techniques to enhance dbt development, increase efficiency, and strengthen documentation., * Experience with dbt (Data Build Tool) and its implementation for data transformation and modeling.
• Proven experience with data wrangling and designing/developing experience owning end to end SDLC and implementation, with full ownership of stakeholder management and expectation setting, prioritization, development and delivery.
• Proficiency in source code management tools such as GIT, BitBucket, etc.
• Experience working with Cloud Technologies (AWS/GCP/Azure)
• Experience working with various semi structured data formats (ex. JSON)
• Experience building data solutions for future scale and analytics use-cases
• 3+ years of development experience on industry standard BI tools
• ML analytics engineering experience a plus
• Marketing Analytics experience a plus

• 25 days of annual leave per calendar year (January-December)
• Up to 10 unused vacation days may be carried over to the following year and must be used by December 31
• Reduced summer hours to support better work-life balance
• Flexible bank holidays, allowing employees to exchange one public holiday for another
• This role is fully remote within Spain, with the option to work from our Bilbao office whenever preferred

Learning & Development

Grow with Appfire University - our custom, on-demand learning platform designed to support continuous learning and professional development.

At Appfire, we believe that great work happens when people get to choose how they work. After 20 years of creating software that empowers teams to break silos and collaborate seamlessly, we've learned that one size does not fit all. That's why at Appfire, you choose. Choose to work where you thrive: Whether from home, in one of our offices, or while exploring the world, you decide where you're most productive. From hardware and software to access to two decades of collective wisdom on working effectively in a remote-first company, we've got you covered. Choose to balance your life without compromise: Plan your workday around your needs and what matters most to you. Enjoy flexible time off without the hassle of complicated approvals. From day one, we trust you to deliver quality work without sacrificing your personal life, hobbies, loved ones, and well-being. Choose to grow on your terms: Take charge of your professional growth with access to online learning platforms, facilitated training, leadership programs, and internal hackathons. Collaborate with a global team to gain fresh perspectives. When you're ready for a new challenge, our internal mobility program is here to support your journey. No one knows you better than you do. So join us and customize your experience. Choose how you want to work. Choose Appfire., Since its inception, Appfire has been a remote-first company. With 850+ employees (who we call fireflies) across 28 countries, we foster an environment where everyone is respected. We invest in team members by ensuring they grow professionally and personally. Making an impact At Appfire, CSR means embedding purpose, responsibility, and impact into everything we do. We use our people, products, and partnerships to make a meaningful difference in the world, we act responsibly as a business, and we empower communities while strengthening our skills and culture and fostering belonging across Appfire. In 2015, Appfire joined the Pledge 1% network of organizations committed to philanthropy. Appfire has since grown our Pledge 1% program to include all four pledge types - product, profit, equity, and employee time. We were among the first to do this, and we're proud that Pledge 1% is part of our evolution. Our business Appfire mission to equip and connect every team so they can plan and deliver their best work. We are committed to building a durable, multi-generational business, and to evolving, innovating, and scaling in a way that ensures stability and opportunity for years to come What's our secret sauce? * We follow teams. We do our research and build software that solves real-life collaboration challenges while being easy to implement and a joy to use. We're proud to support over 20,000 customers and growing, including 55% of the Fortune 500. From the entertainment delivered by Netflix to the devices crafted by Samsung, and Dell Technologies and the financial transactions handled by Visa, Edward Jones, and US Bank, Appfire's technology is indispensable. Our products also play a pivotal role in streamlining operations and fostering innovation at companies like Tesla and significant institutions such as NASA, Boeing, and many more. * We enhance. Our software is designed to give developers, knowledge workers, and teams the ability to extend and get greater value from the platforms they've invested in and enjoy. So far, our solutions extend and enhance the capabilities offered by Atlassian, Microsoft, monday.com, and Salesforce. * We build bridges and invest in our partners. Appfire's success is underscored by its channel program as its primary path to market. Today, Appfire has a dedicated Channel team supporting 800+ channel partners. * We make security and privacy a priority, but we also keep it simple for our customers. We've achieved International Organization for Standardization (ISO) 27001 and ISO 27017 and System and Organization Controls (SOC) SOC 2, Type I and SOC 2, Type II certifications. Our award-winning Appfire Trust Center, offers our customers, partners, and prospects the latest security, privacy, and compliance information, including pre-completed questionnaires (CAIQ, SIG, and VSA) with an accelerated NDA process and just one EULA to cover it all. Market recognition Appfire has been consistently recognized for company growth, culture, corporate social responsibility, and product excellence and has been included among the Deloitte Technology Fast 500, Inc. Best Workplaces, BuiltIn Best Places to Work, and Inc. 5000. Learn more about our accomplishments, which would not be possible without our team members, partners, and customers: https://appfire.com/awards.