Senior Backend Engineer (Campaign Overview and Reporting)

<p>We’re looking for <strong>an experienced backend-oriented developer</strong> to join our reporting focused team called<strong> Bobby Tables</strong>. Our number-crunching service aggregates data from multiple sources within and outside Smartly.io making it one of the most data-heavy parts of the application. Customers can analyze performance of their ad campaigns by using the flexible report builder and data visualizer tool our team has developed.</p> <p>Besides providing a customer-facing interface to the online analytical processing (OLAP) system that allows it to run complex analysis, the service offers programmatic access to the Reporting engine powering such features as automated actions and automated budget optimizations. The challenges lie in different areas: the scale of the database (several terabytes of data), complexity of database queries powered by flexible query language exposed as REST API, having numerous stakeholders both on client and data ingestion sides. The data structures have been evolving from being focused on one ad serving channel to being abstract cross-channel.</p> <p>Technologies we use are PostgreSQL with <a href="https://www.smartly.io/blog/scaling-our-analytical-processing-service-sharding-a-postgresql-database-with-citus">Citus extension</a>, Ruby with some Rails gems, RabbitMQ. Campaigns Overview is built using React. Besides, we have several Node.js-powered services to simplify data ingestion. We use TypeScript to generate JavaScript code.</p> <h2><strong>As a Senior Engineer you will…</strong></h2> <ul> <li>Work on making Campaign Overview and Reporting solution more self-served for Smartly.io teams | Enable other Smartly.io teams to send data and generate reports</li> <li>Plan, implement and support the improvements to our Reporting engine both in the backend and in the frontend</li> <li>Collaborate with Designer, Lead Engineer, Engineering Manager, Product Manager within your team and work with other functions in product discovery and go to market activities</li> <li>Contribute to the Architecture Vision of the Reporting solution</li> <li>Mentor other developers</li> <li>Be part of continuous improvement of the team</li> </ul> <h2><strong>What we are looking for:</strong></h2> <ul> <li>Having 5+ years of experience in backend development</li> <li>Agility to write efficient code in different languages and paradigms (we use Ruby, React, Nest, koa, and a bit of PHP)</li> <li>Strong background in complex SQL-based OLAP systems</li> <li>Understanding of challenges in larger engineering organizations (200+ developers)</li> <li>Self-driven attitude, willingness to touch business context</li> </ul> <h2><strong>What we offer you:</strong></h2> <p>Our projects are a part of the DNA of our product, which means that every team will have some skin in the game. Your work will have a direct impact our customers and our business. You will own your work, and we will support you in that ownership. We value work life balance and have a strong <a href="https://www.smartly.io/culturehandbook" target="_blank">culture</a> that we hope all of our Smartlies bring their own flavour to. As a company we provide a competitive salary, option package and a generous package of benefits.</p> <h3><strong>What to expect from our recruitment process:</strong></h3> <p><strong>First meeting</strong>: we're getting to know each other. </p> <p><strong>Coding challenge</strong>: you'll get a challenge to test your coding skills which you can do at a time that suits you. </p> <p><strong>Meeting the Team Lead</strong>: learn more about your future team.</p> <p><strong>Technical interviews</strong>: you take part in an interactive coding interview with one of our developers followed by a discussion around Systems Design and Architecture.</p> <p><strong>Explore and Expand</strong>: we'll dig deeper into your main interests and core skills.</p> <p>#LI-JF2 #LI-hybrid</p><h2><strong>Meet Smartly.io</strong></h2> <p>Smartly.io is one of the world’s largest SaaS digital advertising platforms. We help brands better reach audiences, engage creatives and learn what performs best across the largest media platforms, including Facebook, Instagram, Snap, Pinterest, TikTok, and Google.</p> <p>We manage nearly $5B in ad spend and help 700+ brands worldwide. Our leading end-to-end technology and outstanding customer helps brands like Walmart, FanDuel, L’Oreal, Warner Bros. Discovery, Nestle, and Disney/ESPN to better reach audiences, engage creatives and learn what performs best.</p> <p>We offer growth-minded people opportunities to make an impact in a fast-paced, collaborative and inclusive environment built on a culture of trust, transparency, and feedback. You’ll work with a team of 600+ Smartlies, representing 60+ nationalities. We operate in 13 countries across 24 locations. </p> <p>At Smartly.io, you can enjoy the freedom to harmonize work and personal life. As a global, hybrid organization, we are mindful to collaborat