• Define enterprise data architecture strategy and roadmap. • Design scalable cloud-native data platforms on GCP and Azure. • Develop conceptual, logical, and physical data models. • Drive Data Mesh, Data Fabric, governance, and analytics initiatives. • Mentor engineering and analytics teams. • Partner with stakeholders to translate business requirements into solutions. • Support AI/ML, advanced analytics, and modern data platform initiatives.

• Monitor and support the Production Data Warehouse environment • Troubleshoot and resolve issues related to ETL jobs, data loads, and performance bottlenecks • Coordinate with development, infrastructure, and business teams to ensure smooth operations and incident resolution • Perform root cause analysis for incidents and recurring issues and contribute to the continuous improvement of support and maintenance processes.

• Proactively monitor and support the Production Data Warehouse environment daily to guarantee seamless stability and uninterrupted operations. • Drive the successful execution and punctual completion of all End-of-Day (EOD) and End-of-Month (EOM) processes. • Expertly troubleshoot and resolve challenges related to ETL jobs, data loading, and performance issues to keep systems running optimally. • Collaborate closely with development, infrastructure, and business teams to ensure smooth workflows and swift incident resolutions. • Create and maintain comprehensive documentation, including operational procedures, runbooks, and support guides, to empower the team and streamline processes.

Title: Senior Data Analytics Engineer - Data Insights Location: Spain Remote Job Description: 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. Job Purpose and Overview Appfire is seeking an experienced full-time Senior Analytics Engineer! 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 What We Would Like to See: - 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. Preferred Qualifications: - 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 Benefits & Perks Equity - Every Appfire team member is eligible for company equity, fostering a true sense of ownership and connection to our growth. Time Off & Flexibility - 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. Health & Wellbeing - Private health insurance - 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.