via Pinpoint
$120K - 200K a year
Design, develop, and optimize data models and transformation pipelines within Snowflake using dbt, ensuring data quality and performance.
Deep experience with Snowflake, mastery in dbt, advanced SQL skills, and strong data modeling expertise, especially for analytical use cases.
Senior Analytics Engineer Department: Data Employment Type: Full Time Location: Costa Rica Reporting To: Gordon Wong Description Newfire Global Partners is a leading technology firm that specializes in building transformative software solutions for some of the world’s most innovative companies. With a presence across four continents, Newfire Global brings deep expertise in digital healthcare, AI-driven analytics, and enterprise technology. The firm’s track record of delivering scalable, high-impact solutions has made it a trusted partner for organizations seeking to drive meaningful change through technology. We are passionate about the purpose-driven mission to help improve the quality of care for patients and are building a collaborative, innovative, and inclusive culture. We are a fully funded company founded by serial entrepreneurs with a stable client base. Opportunity for impact Newfire Global Partners, a leader in developing disruptive healthcare technology, collaborates with Fortune 500 companies and start-ups to drive transformation. Newfire is seeking a Senior Analytics What's the Project? Our client is a is looking for a talented, curious, driven individual to join as our primary Senior Analytics Engineer. This individual will be responsible for owning and scaling the data transformation layer, serving as the foundational source of truth for all business insights, and requiring a deep commitment to data integrity and performance. Your day-to-day activities: Collaborate with data analysts, business stakeholders, and engineers to define, design, and build the critical data models that power business intelligence. Own the development, maintenance, and optimization of the data transformation layer using dbt. Design and implement scalable dimensional and fact models within Snowflake to support reporting, analysis, and data science use cases. Identify, investigate, and resolve data quality and performance issues within the data warehouse. Work closely with data consumers to understand their requirements and translate them into robust data structures and metrics definitions. Get to know the data as well or better than anyone else As a Senior team member, you will be expected to actively participate in our hiring processes by serving on interview panels for future roles across the company. Please note that employment will be contingent upon providing documentation verifying your legal work authorization in the country of residence, in accordance with applicable law. You’re a perfect match if you have: Database Expertise (Snowflake): Deep experience with Snowflake's architecture, optimization, and advanced features (e.g., materialized views, clustering keys, query performance tuning). Expert dbt Proficiency: Demonstrated mastery in using dbt (Data Build Tool) for defining, testing, documenting, and deploying data transformation pipelines. Experience with dbt Cloud or similar CI/CD for data is a strong plus. Advanced Data Modeling: Strong conceptual and practical understanding of relational and dimensional modeling (e.g., Kimball methodology, normalization/denormalization) specifically tailored for analytical use cases. Expert SQL Skills: Ability to write complex, efficient, and optimized SQL queries for data transformation and analysis. Tableau Skills: Strong experience in connecting Tableau to Snowflake, developing high-impact dashboards, and optimizing Tableau workbook performance against large data sets. Fluency in other BI tools such as Sigma or Omni is a plus. Business Acumen: Experience modeling and engineering data related to marketing, product, and/or finance metrics. Experience with healthcare patient visits metrics is a strong plus. Communication: Ability to articulate technical constraints, data architecture choices, and data model logic clearly to both technical peers and business stakeholders. Data Governance & Quality Assurance: Meticulous attention to detail in QA processes, data lineage, and implementation of data quality checks (e.g., dbt tests). Requirements Translation: Experience translating abstract business questions into concrete, technical data model requirements. Ownership: Taking full responsibility for the integrity, performance, and reliability of the data models you build, ensuring stakeholders have complete trust in the data used for decision-making.
This job posting was last updated on 1/14/2026