About this role.
Sporty is hiring a remote-first Senior BI Engineer to build and maintain a scalable business intelligence platform. The role centers on semantic data modeling, advanced SQL, governed KPI definitions, Metabase dashboards, and trusted reporting datasets using Amazon Redshift and relational databases. This person will work closely with business stakeholders and Data Engineers to resolve data issues, improve reporting quality, and increase self-service analytics adoption. Success requires at least five years of BI or analytics engineering experience, strong ownership, and excellent communication skills. The company offers flexible working hours, annual leave, equipment, quarterly performance bonuses, and company retreats.
Role DNA
A quick view of the complexity, pace, ownership and collaboration implied by the job description.
Job Complexity
4/5Pace & Pressure
4/5Autonomy Level
5/5Communication Load
5/5Salary analysis
Estimated compensation compared with the broader US market for similar roles.
Core skills
Skills and capabilities most closely associated with this opportunity.
Cover letter sample
Dear Hiring Team,
I am excited to apply for the Senior BI Engineer role at Sporty. With extensive experience translating business needs into reliable data models, SQL-based reporting datasets, and self-service dashboards, I can help strengthen trusted decision-making across the organization.
- Advanced SQL, dimensional modeling, semantic-layer design, and data-quality validation
- Stakeholder partnership to define consistent KPIs, metrics, and reporting standards
- Clear, intuitive dashboard delivery and investigation of data discrepancies through resolution
I am particularly drawn to Sporty’s remote-first culture and the opportunity to improve analytics accessibility while working closely with business stakeholders and Data Engineers. I would welcome the opportunity to contribute a proactive, ownership-oriented approach to your BI platform.
Sample interview questions
I start by clarifying the business decision the metric will support, its intended audience, grain, source systems, calculation logic, exclusions, time-zone rules, and ownership. I document the definition in a shared metrics catalog, implement it centrally in a semantic model where possible, validate it against known totals, and establish change-control practices so every dashboard uses the same governed definition.
I first reproduce the discrepancy and compare dashboard filters, date logic, aggregation grain, joins, and refresh timing. I trace the metric back through the semantic layer and SQL to source tables, use targeted reconciliation queries to isolate the variance, then partner with Data Engineers if the issue originates upstream. After correcting it, I document the root cause, add validation checks where practical, and communicate the impact and resolution to stakeholders.
For a self-service model, I begin with clearly defined business processes and establish the appropriate fact-table grain. I use conformed dimensions, intuitive business naming, reusable measures, and documented relationships while limiting direct exposure to unnecessary technical complexity. I also test common reporting paths for correctness and performance, then collect user feedback to refine the model without compromising governance.
I would inspect the query plan and identify expensive scans, skewed joins, redistribution, nested logic, and unnecessary data movement. Typical improvements include filtering early, selecting only needed columns, restructuring joins and aggregations, using appropriate distribution and sort keys, materializing reusable intermediate datasets, and ensuring statistics are current. I would benchmark changes against representative workloads and validate that results remain correct.
I prioritize requests using business impact, urgency, reach, data readiness, effort, and whether a solution can be reused broadly. I make priorities transparent through a shared backlog, deliver quick wins when they do not disrupt strategic work, and align stakeholders on timelines and trade-offs. For recurring requests, I look for opportunities to build governed self-service datasets or reusable dashboard components instead of producing one-off analyses.
About the role
We are looking for a Senior BI Engineer to design, build and maintain our business intelligence platform. You will be responsible for transforming data into trusted, actionable insights by developing semantic data models, defining business metrics and delivering intuitive dashboards. You will work closely with business stakeholders and Data Engineers to ensure reporting is accurate, scalable and aligned with business objectives.
What you’ll be doing
- Partner with stakeholders to understand reporting requirements and translate business needs into scalable analytical solutions.
- Design, build and maintain dashboards and reports using Metabase.
- Define, document and maintain business metrics, KPIs and reporting standards across the organisation.
- Develop and optimise SQL queries for reporting and analytics.
- Design semantic data models and reporting datasets that enable self-service analytics.
- Validate data accuracy and ensure consistency across dashboards and reports.
- Investigate data discrepancies and drive issues through to resolution in collaboration with Data Engineers.
- Analyse business performance, identify trends and provide actionable insights and recommendations.
- Promote best practices in business intelligence, reporting and data visualisation.
- Maintain documentation for dashboards, metrics, business definitions and reporting processes.
- Drive adoption of business intelligence solutions by supporting stakeholders and promoting data-driven decision making.
- Contribute to the evolution of the analytics platform by identifying opportunities for improvements in reporting capabilities and data accessibility.
What you’ll bring
- 5+ years of experience in Business Intelligence, Analytics Engineering or a similar role.
- Advanced SQL skills and experience working with large analytical datasets.
- Strong experience building dashboards and reports using Metabase or a similar business intelligence platform.
- Experience working with Amazon Redshift and relational databases.
- Strong understanding of dimensional modelling and semantic layer design.
- Experience defining business metrics, KPIs and reporting standards.
- Ability to independently investigate business and data issues from identification through resolution.
- Excellent communication and stakeholder management skills.
- Proactive mindset with strong ownership and accountability.
What’s in it for you
- Sporty is a remote first company in pursuit of sustainability
- A competitive salary + individual performance based bonuses every quarter
- 28 days paid annual leave
- Our core working hours are 10am-3pm in your local time zone with flexibility outside of this
- Referral bonuses & flash bonuses
- Top of the line equipment
- Annual company retreats to provide great internal networking opportunities
Interview Process
- Remote video screening with our Talent Acquisition Team
- Online home assignment
- Remote video interview with Team Members (3×45 Mins)
If you’re interested, we encourage you to apply! Every application is reviewed by a member of our team (AI is not used in our recruitment process), and we aim to respond within 48 hours.
Annual salary information is not provided for this position. Explore salary ranges for similar roles in our Salary Directory ›
Upload your resume now
- To unlock remote work opportunities and be discovered by global employers.
This job listing has been manually reviewed by the Jobicy Trust & Safety Team for compliance with our posting guidelines, including verification of the company's legitimacy, accuracy of job details, clarity of remote work policy, and absence of misleading or fraudulent content.
