Senior Analytics Engineer
Lighthouse
At Lighthouse, we’re on a mission to disrupt commercial strategy for the hospitality industry. Our innovative commercial platform takes the complexity out of data, empowering businesses with actionable insights, advanced pricing tools, and cutting-edge business intelligence to unlock their full revenue potential.
Backed by $370 million in series C funding and driven by an unwavering passion for growth, we’ve welcomed five companies into our journey and have surpassed $100 million in ARR in 2024. Our 700+ teammates span 35 countries and represent 34 nationalities.
At Lighthouse, we’re more than just a workplace – we’re a community. Collaborative, fun, and deeply committed, we work hard together to revolutionize the hospitality sector. Are you ready to join us and shine brighter in the industry’s most exciting rocket-ship? 🚀
What you will do
As a Senior Analytics Engineer, you will be a key player in our Data Warehousing team, focusing on building the data models, architecture, and pipelines that power our business. You will focus on critical areas like churn and revenue reporting, ensuring our data is reliable, tested, and accessible. Your work will involve crafting highly performant SQL queries, building robust data sets for analysis, and supporting our leadership team in making data-driven decisions. This is a hands-on role where you will also provide ad-hoc reports, work on dashboarding, and ensure the overall usability of our data.
Where you will have impact
- Conduct in-depth data analysis using SQL to improve key business metrics, such as our reporting and tracking of customer churn.
- Develop and maintain scalable data models and data architecture to support the analysis and interpretation of complex business data.
- Partner with key stakeholders across Finance, Account Management, Leadership team, and other.
- Uphold data integrity and accuracy by testing data pipelines and implementing software engineering best practices like version control.
- Empower teams to make data-driven decisions by creating visualizations and enabling self-service exploration of our data marts.
About our team
Within this role, you will be an important part of the Data Analytics department, specifically within the Data Warehousing pillar. We are the foundational pillar of Lighthouse's data ecosystem, singularly focused on enabling the efficient use and continuous development of our robust data infrastructure. Our mission is to ensure that our data assets are not only efficient and scalable but also possess unwavering integrity and are readily accessible to empower data-driven decisions across the entire organization.
Our responsibilities include:
- Optimizing Data Infrastructure: Monitor and enhance our data pipeline efficiency, ensuring scalability and managing costs to support Lighthouse's rapid growth.
- Guaranteeing Data Integrity: Maintain a robust data integrity framework with automated testing and documentation for reliable data marts.
- Streamlining Data Support: Develop tools and processes to streamline data sharing across systems, boosting efficiency and accuracy in data-driven decisions.
- Driving Data Automation: Automate reporting and data workflows to reduce manual effort and increase operational efficiency.
Working hand-in-hand with the Strategic Analytics team, we enable everyone at Lighthouse to leverage data for strategic decision-making.
Who you are
- A minimum of 5 years of hands-on experience as a data professional.
- High proficiency in writing performant SQL queries and Python scripts for analysis.
- Strong experience in data analysis, data modeling, and working with ELT/ETL tools and transformation tools like dbt.
- Proven experience in stakeholder management, including gathering and translating business requirements.
- Proficiency in creating clear and impactful data visualizations using BI tools like Looker, Tableau, or PowerBI.
- Solid understanding of software engineering best practices within a data context, such as version control and continuous integration.
- Excellent communication skills in English, with the ability to articulate complex data concepts to diverse audiences.
We welcome
- Experience with churn and revenue reporting.
- Experience working in a fast-paced, high-growth SaaS or technology company.
Technologies you will work with
SQL, Google BigQuery, dbt, Looker, GitLab, Jira, Python, Excel.
What’s in it for you
- Flexible working environment: Work from home or at one of our global offices.
- Flexible time off: Autonomy to manage your work-life balance.
- Collaborative team: High-bar, friendly, creative, and passionate colleagues.
- Career development: Workshops, frameworks, tools, training, and processes to realize your full potential.
- Impactful work: Shape products relied on by 75,000+ users worldwide.
- Mobility options: Mobility budget or company car tailored to your needs.
- Comprehensive health insurance: Extensive coverage for you and your dependents.
- Private pension funding: Group insurance to secure your future.
- Competitive compensation: Proactively maintained to value your work.
- Referral bonuses: Earn rewards for bringing in new talent.
#LI-Hybrid
Thank you for considering a career with Lighthouse. We are committed to fostering a diverse and inclusive workplace that values equal opportunity for all. We welcome candidates from all backgrounds, regardless of age, gender, race, religion, sexual orientation, and disability. We actively encourage applications from individuals with disabilities and are dedicated to providing reasonable accommodations throughout the recruitment process and during employment to ensure all qualified candidates can participate fully. Our commitment to equality is not just a policy; it's part of our culture.
If you share our passion for innovation and teamwork, we invite you to join us in shaping the future of the hospitality industry. At Lighthouse, our guiding light is to be an equal opportunity employer, and we encourage individuals from all walks of life to apply. Not ticking every box? No problem! We value diverse backgrounds and unique skill sets. If your experience looks a little different from what we've described, but you're passionate about what we do and are a quick learner, we'd love to hear from you.
We value the unique perspective and talents that you bring, and we're excited to see how your light can shine within our team. We can't wait to meet you and explore how we can grow and succeed together, illuminating the path towards a brighter future for the industry.