TreviPay The Pay by Invoice Company is the global B2B payments infrastructure partner for manufacturers retailers travel companies and banks. With our fully managed platform intelligent apps and 40 years of buyer intelligence we help buyers buy and sellers grow and get paid faster. Enabling more than $8B in global trade annually TreviPay operates in 35 countries with offices in Kansas Mexico City San Jose CR Rijswijk NL and Melbourne AU.
We are seeking a highly skilled BI & Analytics Engineer to join us in our Overland Park KS office to help 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
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
Why you will love working at TreviPay
Competitive salary
Paid parental leave
Generous paid time off
Medical dental vision FSA Life/AD&D long and short term disability
401K matching
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 customers day just a little bit better
work/life balance makes us all more effective
TreviPay is an Equal Opportunity and Affirmative Action Employer. We welcome all veterans and disabled applicants.
Individuals with disabilities will be provided reasonable accommodation to participate in the job application and/or interview process. Please contactemailprotectedto request an accommodation.
Required Experience:
IC
TreviPay The Pay by Invoice Company is the global B2B payments infrastructure partner for manufacturers retailers travel companies and banks. With our fully managed platform intelligent apps and 40 years of buyer intelligence we help buyers buy and sellers grow and get paid faster. Enabling more tha...
TreviPay The Pay by Invoice Company is the global B2B payments infrastructure partner for manufacturers retailers travel companies and banks. With our fully managed platform intelligent apps and 40 years of buyer intelligence we help buyers buy and sellers grow and get paid faster. Enabling more than $8B in global trade annually TreviPay operates in 35 countries with offices in Kansas Mexico City San Jose CR Rijswijk NL and Melbourne AU.
We are seeking a highly skilled BI & Analytics Engineer to join us in our Overland Park KS office to help 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
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
Why you will love working at TreviPay
Competitive salary
Paid parental leave
Generous paid time off
Medical dental vision FSA Life/AD&D long and short term disability
401K matching
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 customers day just a little bit better
work/life balance makes us all more effective
TreviPay is an Equal Opportunity and Affirmative Action Employer. We welcome all veterans and disabled applicants.
Individuals with disabilities will be provided reasonable accommodation to participate in the job application and/or interview process. Please contactemailprotectedto request an accommodation.
Job Location:
Monthly Salary:
Posted on:
Vacancies:
