Senior Database Engineer

<meta><p style="font-family:" basel="" grotesk",arial,sans-serif;font-size:13pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;"=""><b><strong style="font-size:13pt;white-space:pre-wrap;">About the Opportunity:</strong></b></p><p style="font-family:" basel="" grotesk",arial,sans-serif;font-size:11pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;"=""><span style="white-space:pre-wrap;">As a Sr. Database Engineer, you’ll join a close-knit team building the future of a platform designed to power immersive digital experiences for our customers and partners. In this role, you will leverage deep technical expertise to design, optimize, and operationalize large-scale data solutions spanning distributed compute, datalake, Relational and Vector databases that ensure high performance, scalability, and reliability. You'll work across the full modern data stack — from Lakehouse foundations to real-time inference — enabling advanced analytics, semantic search, and AI-driven capabilities at scale.</span></p><p style="font-family:" basel="" grotesk",arial,sans-serif;font-size:7pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;"=""><br></p><p style="font-family:" basel="" grotesk",arial,sans-serif;font-size:13pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;"=""><b><strong style="font-size:13pt;white-space:pre-wrap;">What You'll Do:</strong></b></p><ul data-pattern="discCircleSquare" data-depth="1" style="font-family:" basel="" grotesk",arial,sans-serif;font-size:11pt;font-weight:400;margin:8px="" 0px;line-height:1.6;padding:0px="" 0px="" 32px;list-style-type:disc;"=""><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Analyze and optimize production data solutions to identify and resolve issues related to performance, locking, and scalability</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Write and optimize complex SQL across the full stack — Spark SQL for distributed transformations, PostgreSQL for transactional and analytical workloads, and Delta Lake for versioned, ACID-compliant table management</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Design and build large-scale Spark and Azure Data Factory pipelines for batch and streaming ingestion, transformation, and feature engineering — leveraging both PySpark and Spark SQL for distributed processing at large scale</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Design and develop data lake architectures including Medallion Architecture to support advanced analytics and large-scale data ingestion</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Build and maintain production-grade data pipelines for efficient data movement and transformation across systems. Managing Delta table lifecycles, schema evolution, Z-ordering, time travel, and Change Data Feed to support reliable, performant analytics and OLTP and ML workloads</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Design and operate hybrid storage patterns combining PostgreSQL for transactional workloads — with optimized schemas, indexes, CTEs, window functions, and partitioning — alongside Delta Lake Lakehouse layers for analytical and ML workloads</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Design and implement reporting solutions that deliver actionable insights to business stakeholders</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Communicate database and data architecture designs to business and technical audiences, including business users, program sponsors, database administrators, ETL and BI developers</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Evaluate potential technology/tool solutions that meet business needs and facilitate internal and external discussions towards desirable outcomes</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Collaborate with solution architects and project resources on systems integration and compatibility, while acting as a leader in coaching, training, and providing guidance</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Create functional and technical documentation related to data architecture and business intelligence solutions</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Provide technical consulting to application development teams during application design and development for highly complex or critical projects</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Design data governance procedures to ensure compliance with internal and external regulations </span></li></ul><p style="font-family:" basel="" grotesk",arial,sans-serif;font-size:6pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;"=""><br></p><p style="font-family:" basel="" grotesk",arial,sans-serif;font-size:13pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;"=""><b><strong style="font-size:13pt;white-space:pre-wrap;">What We’re Looking For:</strong></b></p><ul data-pattern="discCircleSquare" data-depth="1" style="font-family:" basel="" grotesk",arial,sans-serif;font-size:11pt;font-weight:400;margin:8px="" 0px;line-height:1.6;padding:0px="" 0px="" 32px;list-style-type:disc;"=""><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">7+ years in data engineering, big data platforms, or a related discipline with hands-on production experience at scale</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Located in Eastern or Central time zone; you will work extensively with a team member in the UK </span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Proven experience analyzing and tuning production database systems for performance and reliability</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Expert-level SQL skills — complex joins, CTEs, window functions, query plan analysis, and optimization across both OLTP (PostgreSQL) and distributed engines (Spark SQL, Databricks SQL, Delta Lake)</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Hands-on experience with data lake technologies and data pipeline frameworks (e.g., Azure Data Lake, Azure Data Factory, Databricks)</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Deep expertise in Apache Spark — DataFrames, Spark SQL, UDFs, partitioning, broadcast strategies, and hands-on performance tuning experience</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Data warehouse and visualization experience, including demonstrated strong Logical, Physical, and Dimensional Modeling skills</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Solid command of Delta Lake internals — transaction log, schema enforcement, schema evolution, time travel, CDF, Z-ordering, liquid clustering, and OPTIMIZE/VACUUM operations</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Strong PostgreSQL experience — schema design, indexing strategies, partitioning, EXPLAIN/ANALYZE tuning, and extensions including pgvector for similarity search</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Strong Python skills — PySpark, pandas, async programming, building production data utilities</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Strong understanding of reporting and BI solution design, including Power BI or similar tools</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Experience in design of technology roadmaps and the transition from the current architectural framework to target architecture of the future</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Excellent verbal and written communication skills to document and present data models, strategies, standards, and concepts to both business and IT audiences</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Experience with the following tech & tools: </span></li><li style="list-style:none;font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><ul data-pattern="discCircleSquare" data-depth="2" style="font-family:" basel="" grotesk",arial,sans-serif;font-size:11pt;font-weight:400;margin-left:0px;margin-right:0px;line-height:1.6;padding:0px="" 0px="" 32px;list-style-type:circle;"=""><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">SQL Engines: Azure SQL Server, Spark, Cosmos DB, PostgreSQL, Elastic</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Azure Technologies: Cosmos DB, SQL Database, Analytics, Azure Databricks, Data Factory, Fabric, Power BI, Azure Data Lake</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">ETL Tools: Azure Data Factory, Azure Databricks, Azure Stream Analytics</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">Lakehouse: Delta Lake, Delta Live Tables</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;"><span style="white-space:pre-wrap;">LANGUAGES: SQL, Python, PySpark</span></li></ul></li></ul><p style="font-family:" basel="" grotesk",arial,sans-serif;font-size:6pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;text-align:start;"=""><br></p><p style="font-family:" basel="" grotesk",arial,sans-serif;font-size:13pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;text-align:start;"=""><b><strong style="font-size:13pt;white-space:pre-wrap;">What We Offer:</strong></b><span style="font-size:13pt;white-space:pre-wrap;"> </span><span style="font-size:11pt;white-space:pre-wrap;"> </span></p><ul data-pattern="discCircleSquare" data-depth="1" style="font-family:" basel="" grotesk",arial,sans-serif;font-size:11pt;font-weight:400;margin:8px="" 0px;line-height:1.6;padding:0px="" 0px="" 32px;list-style-type:disc;"=""><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;text-align:start;"><span style="font-size:11pt;white-space:pre-wrap;">Competitive base salary: $150,000-$180,000/year</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;text-align:start;"><span style="font-size:11pt;white-space:pre-wrap;">Flexible vacation policy – take the time you need to recharge </span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;text-align:start;"><span style="font-size:11pt;white-space:pre-wrap;">Comprehensive health, vision & dental insurance </span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;text-align:start;"><span style="font-size:11pt;white-space:pre-wrap;">401k with company contribution </span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;text-align:start;"><span style="font-size:11pt;white-space:pre-wrap;">Opportunity for career progression with plenty of room for personal growth </span></li></ul><p style="font-family:" basel="" grotesk",arial,sans-serif;font-size:7pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;text-align:start;"=""><br></p><p style="font-family:" basel="" grotesk",arial,sans-serif;font-size:13pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;text-align:start;"=""><b><strong style="font-size:13pt;white-space:pre-wrap;">What to Expect: </strong></b></p><ul data-pattern="discCircleSquare" data-depth="1" style="font-family:" basel="" grotesk",arial,sans-serif;font-size:11pt;font-weight:400;margin:8px="" 0px;line-height:1.6;padding:0px="" 0px="" 32px;list-style-type:disc;"=""><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;text-align:start;"><span style="font-size:11pt;white-space:pre-wrap;">1st Round: 30-45 minute interview with the Recruiter</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;text-align:start;"><span style="font-size:11pt;white-space:pre-wrap;">2nd Round: 45-minute interview with the Hiring Manager (Technical conversational)</span></li><li style="font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;text-align:start;"><span style="font-size:11pt;white-space:pre-wrap;">3rd Round: 45-minute interview with Tech Leader (Problem solving)</span></li></ul><p style="font-family:" basel="" grotesk",arial,sans-serif;font-size:11pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;"=""><i><b><strong style="color:rgb(0,0,0);font-size:11pt;font-style:italic;white-space:pre-wrap;">We do not work with outside recruiting agencies.</strong></b></i></p><p style="font-family:" basel="" grotesk",arial,sans-serif;font-size:11pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;"=""><br></p><p style="font-family:" basel="" grotesk",arial,sans-serif;font-size:11pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;"=""><i><em style="font-size:11pt;white-space:pre-wrap;">MarketOnce will accept applications for this role on an ongoing basis </em></i></p><p style="font-family:" basel="" grotesk",arial,sans-serif;font-size:11pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;"=""><i><em style="font-size:11pt;white-space:pre-wrap;"> </em></i></p><p style="font-family:" basel="" grotesk",arial,sans-serif;font-size:11pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;"=""><i><em style="font-size:11pt;white-space:pre-wrap;">MarketOnce is an Equal Opportunity Employer. We believe in creating a diverse and inclusive workplace where everyone has the opportunity to thrive. We are committed to hiring individuals based on their skills and qualifications, regardless of race, gender, age, sexual orientation, disability, or any other characteristic. We welcome and encourage applications from all backgrounds. </em></i></p>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...