Staff Platform Data Engineer
Tech Stack
Job Description
At SpotOn, we’re helping restaurants and small businesses compete and win with flexible payment and software technology—backed by real people who really care.
From seamless point-of-sale systems to integrated restaurant management solutions, every SpotOn tool is designed to help local businesses increase profits and create better experiences for their customers and employees.
Recently, SpotOn was:Named one of Fast Company’s Most Innovative Companies of 2024Awarded Great Places to Work and Built In’s Best Workplaces for the third year in a rowSelected as the Best Overall Restaurant POS by NerdWallet Rated the top-rated point-of-sale (POS) for restaurants, bars, retail, and small businesses by Capterra usersWe’re committed to caring hard and moving fast so that we can continue to grow and make a positive impact together.
That’s where you come in.
As a platform data engineer within the data and analytics team at SpotOn you will take a lead role in the design and development of our enterprise data architecture.
You will help guide the architecture of data solutions to meet our rapidly scaling demands of data repositories by working with stream-aligned engineering teams to provide effective and efficient solutions for their use cases You will bridge the gap between the data requirements of both SpotOn consumer applications and internal analytics and will have a high level of autonomy in selection of tools and infrastructure for a modern data platform.
The ideal candidate will be able to:Database Architecture and Design:Guide engineering teams towards using ideal/preferred database technologies for the problem being solved.Govern database creation and configuration in cloud environments for optimal performance, scalability, and security utilizing best practices and IAC.Participate in infrastructure planning, including resource allocation, and ensure alignment with business goals.Data Governance and Security:Lead initiatives on data governance, ensuring compliance with internal policies and external regulations.Develop and enforce best practices for data security, backup, and disaster recovery in cloud environments.Implement and maintain encryption, access controls, and auditing mechanisms.Database Maintenance and Support:Oversee the maintenance of a fleet of production databases, ensuring high availability and reliability.Collaborate with development teams to automate database upgrades, patching, and migrations, ensuring minimal downtime and reducing manual intervention.Respond to and resolve any database-related incidents, performing root cause analysis and implementing preventive measures.Performance Tuning and Optimization:Monitor and analyze the performance of databases, identifying bottlenecks, areas of inefficiency, and implementing remediations in cooperation with stream-aligned teams.Conduct regular database audits to ensure performance standards are met and sustained.Optimize SQL queries, indexing, and schema design to improve system efficiency.Development and Collaboration:Collaborate closely with development teams to integrate database solutions into application architectures.Provide hands-on support in database development tasks, such as writing stored procedures, triggers, and complex queries.
Evangelize best practices in these areas among the larger engineering team.Lead and mentor other engineers on database best practices, standards, and troubleshooting techniques.Scalability and Capacity Planning:Conduct regular capacity planning and scalability assessments, ensuring databases can handle growing data volumes.Implement sharding, partitioning, and other techniques to manage large datasets efficiently.Be a resource for stream-aligned teams to help in planning for new features and growth.Innovation and Continuous Improvement:Stay updated with the latest trends and technologies in cloud databases and OLTP systems.Recommend and implement new tools, technologies, or processes that could improve database performance or management.
What skill are we searching for?
Advanced knowledge of performance tuning, data modeling, and governance of transaction databases such as MongoDB, Postgres and MySQL.
Knowledge of 1+ programming language (e.g. Python, C++, Scala, Java, JavaScript etc.).3+ Experience managing databases in cloud SaaS environments.7+ years experience of engineering with a focus in data.Hands on experience leading data governance and optimization of large OLTP databases.Experience working at scale with numerous OLTP databases with large data sets.Experience working with AWS DB Technologies; other vendors a plus.Knowledge of DevOps practices such as Infrastructure As Code (IAC).Ability to work within a small team with a mindset to teach and lead others, while at the same time collaborating with many other teams across the department.Experience with migrating from self-hosted to cloud, or between cloud solutions.Here’s a bit about what we have to offer:Competitive pay.Training budget 3500 PLN gross per year.Access to e-learning platforms (O’Reilly).Fully paid private healthcare in LuxMed.Access to the Worksmile platform with a monthly top-up.Company free breakfasts/lunches in the office once a week.Group English classes with a native speaker.New Macbook Pro, 4K monitors or whatever tools you need.Flexible working hours.New, modern, bright and comfortable office space in the city centre.
A lot of free parking spots around the office.Access to the company’s library.Great working atmosphere.Chill out room with a PlayStation and games.Free snacks and beverages in a kitchen.Company parties and social activities.Employee referral program.Relocation Package within Poland.