BI & Analytics Engineer
At TreviPay, we believe loyalty begins at the payment. Thousands of sellers use our global B2B payments and invoicing network to provide choice and convenience to buyers, open new markets and automate accounts receivables. With integrations to top eCommerce and ERP solutions and flexible trade credit options, TreviPay brings 40 years of experience serving leaders in manufacturing, retail and transportation. Every day, TreviPay employees are challenged and empowered in a supportive, collaborative, entrepreneurial environment. We are seeking a highly skilled remote BI & Analytics Engineer in our Costa Rica location to bridge the gap between data engineering and our analytics team. This role is responsible for transforming raw data into scalable, trusted datasets and delivering high-impact analytics solutions through our modern BI visualization platform and leveraging our cloud data platform. The ideal candidate has strong expertise in SQL/PL-SQL, semantic layer modeling, BI development, and data platform integration (Snowflake preferred), along with experience enabling embedded analytics and self-service data capabilities. Key Responsibilities Data Modeling & Transformation Design, build, and maintain scalable data models (dimensional, star/snowflake schemas) Develop and optimize SQL / PL-SQL transformations for analytics consumption Implement and manage semantic layers to standardize business logic and metrics Ensure data quality, consistency, and governance across datasets BI Development & Analytics Delivery Develop and maintain dashboards, liveboards, and search-driven analytics (preferably in ThoughtSpot) Translate business requirements into intuitive, self-service analytics solutions Partner with stakeholders to define KPIs, metrics, and reporting standards Data Platform & Engineering Integration Work within Snowflake for data modeling, performance tuning, and cost optimization Collaborate with data engineering teams on data pipelines and ingestion frameworks Optimize query performance and warehouse utilization Embedded Analytics & Enablement Support embedded analytics use cases (APIs, SDKs, or iframe-based integrations) Enable external and internal users with governed, scalable analytics access Drive adoption of BI tools through best practices and training Governance & Best Practices Define and enforce standards for: Data modeling Naming conventions Metric definitions Contribute to data cataloging and documentation Required Qualifications 4+ years of experience in analytics engineering, BI development, or data analysis Strong proficiency in SQL (required) Hands-on experience with modern BI tools (ThoughtSpot strongly preferred; alternatives include Tableau, Power BI, Looker) Proven experience designing semantic layers / business models Experience working with Snowflake or similar cloud data platforms Strong understanding of: Data warehousing concepts Dimensional modeling Data governance practices Preferred Qualifications Experience with embedded analytics architecture Familiarity with dbt or similar transformation frameworks Exposure to API-driven data access or BI integrations Experience supporting external-facing analytics products Understanding of data contracts and data product thinking Soft Skills Strong stakeholder communication and business translation skills Ability to operate in a cross-functional environment (Product, Data Engineering, Business) Proactive problem-solving with a focus on scalability and usability We are seeking a highly skilled remote BI & Analytics Engineer to bridge the gap between data engineering and our analytics team. This role is responsible for transforming raw data into scalable, trusted datasets and delivering high-impact analytics solutions through our modern BI visualization platform and leveraging our cloud data platform. The ideal candidate has strong expertise in SQL/PL-SQL, semantic layer modeling, BI development, and data platform integration (Snowflake preferred), along with experience enabling embedded analytics and self-service data capabilities. Key Responsibilities Data Modeling & Transformation Design, build, and maintain scalable data models (dimensional, star/snowflake schemas) Develop and optimize SQL / PL-SQL transformations for analytics consumption Implement and manage semantic layers to standardize business logic and metrics Ensure data quality, consistency, and governance across datasets BI Development & Analytics Delivery Develop and maintain dashboards, liveboards, and search-driven analytics (preferably in ThoughtSpot) Translate business requirements into intuitive, self-service analytics solutions Partner with stakeholders to define KPIs, metrics, and reporting standards Data Platform & Engineering Integration Work within Snowflake for data modeling, performance tuning, and cost optimization Collaborate with data engineering teams on data pipelines and ingestion frameworks Optimize query performance and warehouse utilization Embedded Analytics & Enablement Support embedded analytics use cases (APIs, SDKs, or iframe-based integrations) Enable external and internal users with governed, scalable analytics access Drive adoption of BI tools through best practices and training Governance & Best Practices Define and enforce standards for: Data modeling Naming conventions Metric definitions Contribute to data cataloging and documentation Required Qualifications 4+ years of experience in analytics engineering, BI development, or data analysis Strong proficiency in SQL (required) Hands-on experience with modern BI tools (ThoughtSpot strongly preferred; alternatives include Tableau, Power BI, Looker) Proven experience designing semantic layers / business models Experience working with Snowflake or similar cloud data platforms Strong understanding of: Data warehousing concepts Dimensional modeling Data governance practices Preferred Qualifications Experience with embedded analytics architecture Familiarity with dbt or similar transformation frameworks Exposure to API-driven data access or BI integrations Experience supporting external-facing analytics products Understanding of data contracts and data product thinking Soft Skills Strong stakeholder communication and business translation skills Ability to operate in a cross-functional environment (Product, Data Engineering, Business) Proactive problem-solving with a focus on scalability and usability What is in it for me? · Work in a friendly and caring company where teamwork is key · Work with skilled people that are invested in your success and growth · Remote working is the new normal with flexible work options and paid holidays · Competitive salary with a comprehensive benefits package starting day one · Work in a fun environment that promotes creative thinking and a positive attitude · Career development opportunities · An open-door policy which means your voice will always be heard · A robust Employee Referral program At TreviPay we believe: · in saying yes to unique and challenging requirements · empowered team members are creative team members · our products make the customer’s day just a little bit better · work/life balance makes us all more effective