We connect public companies and retail investors through compelling stories that ignite, inspire, and lead to action.
Senior Database Engineer
Location
Colorado
Posted
41 days ago
Salary
$150K - $180K / year
Seniority
Senior
Job Description
Senior Database Engineer
Market One
• Analyze and optimize production data solutions to identify and resolve issues related to performance, locking, and scalability • 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 • 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 • Design and develop data lake architectures including Medallion Architecture to support advanced analytics and large-scale data ingestion • 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 • 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 • Design and implement reporting solutions that deliver actionable insights to business stakeholders • Communicate database and data architecture designs to business and technical audiences, including business users, program sponsors, database administrators, ETL and BI developers • Evaluate potential technology/tool solutions that meet business needs and facilitate internal and external discussions towards desirable outcomes • Collaborate with solution architects and project resources on systems integration and compatibility, while acting as a leader in coaching, training, and providing guidance • Create functional and technical documentation related to data architecture and business intelligence solutions • Provide technical consulting to application development teams during application design and development for highly complex or critical projects • Design data governance procedures to ensure compliance with internal and external regulations
Job Requirements
- 7+ years in data engineering, big data platforms, or a related discipline with hands-on production experience at scale
- Located in Eastern or Central time zone; you will work extensively with a team member in the UK
- Proven experience analyzing and tuning production database systems for performance and reliability
- 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)
- Hands-on experience with data lake technologies and data pipeline frameworks (e.g., Azure Data Lake, Azure Data Factory, Databricks)
- Deep expertise in Apache Spark — DataFrames, Spark SQL, UDFs, partitioning, broadcast strategies, and hands-on performance tuning experience
- Data warehouse and visualization experience, including demonstrated strong Logical, Physical, and Dimensional Modeling skills
- Solid command of Delta Lake internals — transaction log, schema enforcement, schema evolution, time travel, CDF, Z-ordering, liquid clustering, and OPTIMIZE/VACUUM operations
- Strong PostgreSQL experience — schema design, indexing strategies, partitioning, EXPLAIN/ANALYZE tuning, and extensions including pgvector for similarity search
- Strong Python skills — PySpark, pandas, async programming, building production data utilities
- Strong understanding of reporting and BI solution design, including Power BI or similar tools
- Experience in design of technology roadmaps and the transition from the current architectural framework to target architecture of the future
- Excellent verbal and written communication skills to document and present data models, strategies, standards, and concepts to both business and IT audiences
- Experience with the following tech & tools: SQL Engines: Azure SQL Server, Spark, Cosmos DB, PostgreSQL, Elastic Azure Technologies: Cosmos DB, SQL Database, Analytics, Azure Databricks, Data Factory, Fabric, Power BI, Azure Data Lake ETL Tools: Azure Data Factory, Azure Databricks, Azure Stream Analytics Lakehouse: Delta Lake, Delta Live Tables
Benefits
- Competitive base salary: $150,000-$180,000/year
- Flexible vacation policy – take the time you need to recharge
- Comprehensive health, vision & dental insurance
- 401k with company contribution
- Opportunity for career progression with plenty of room for personal growth
Related Guides
Related Job Pages
More Backend Engineer Jobs
Senior Full Stack Software Development Engineer
ZillowReimagining real estate to make it easier than ever to move from one home to the next.
Role Description As a Senior Software Development Engineer, you’ll lead the delivery and ongoing support of projects from end-to-end. In addition, you will: - Contribute to the design of new features. - Review the code of your peers. - Advocate for standard methodologies. - Facilitate engineering discussions. - Mentor junior engineers. - Participate in an inclusive, energetic and highly multi-functional team. This role has been categorized as a Remote position. “Remote” employees do not have a permanent corporate office workplace and, instead, work from a physical location of their choice, which must be identified to the Company. U.S. employees may live in any of the 50 United States, with limited exceptions. In addition to a competitive base salary and benefits, this position is also eligible for equity awards based on factors such as experience, performance and location. Qualifications - 5+ years of software development experience with ES6, React, Typescript, and GraphQL. - Experience with Python, Java, NodeJS, and Go for APIs and services. - Experienced in a range of persistence strategies including relational and non-relational databases. - Fluent in English and Spanish (both written and spoken). - Must be authorized to work in Mexico. - Highly skilled with multiple modern development technologies used to design, deliver, debug, and maintain front-end user interfaces and back-end software systems. - Recognized as a technical leader on your team for several years and have an impact beyond your team. - Passionate about setting standard methodologies and raising the bar for systems design, testing, code quality, and maintainability. Benefits - Competitive base salary. - Benefits package. - Equity awards based on experience, performance, and location. Company Description At Zillow, we’re reimagining how people move—through the real estate market and through their careers. As the most-visited real estate platform in the U.S., we help customers navigate buying, selling, financing and renting with greater ease and confidence. - Zillow was named one of FORTUNE 100 Best Companies to Work For® in 2025. - Included on the PEOPLE Companies That Care® 2025 list. - Committed to creating an innovative, inclusive, and engaging culture. - Equal opportunity employer committed to fostering an inclusive environment.
Software Engineer | React + Node.js + TypeScript
Babel GroupBABEL es una consultora tecnológica multinacional especializada en aplicar sus servicios y conocimiento tecnológico en los procesos de aceleración digital de sus clientes, grandes empresas y organismos públicos. Nuestro plan estratégico Hiperespacio 2029 promete ser un viaje emocionante, lleno de oportunidades para crecer y desarrollarse profesionalmente.
Role Description En Babel Chile buscamos un/a Fullstack Developer para integrarse a equipos ágiles que trabajan en proyectos tecnológicos de mediana y alta complejidad para nuestros clientes. - Experiencia sólida en desarrollo frontend y backend. - Orientado a la construcción de soluciones escalables, mantenibles y de buena calidad técnica. - Foco en tecnologías modernas del ecosistema JavaScript/TypeScript. Serás parte de un equipo de desarrollo colaborativo, participando en la construcción y evolución de aplicaciones web modernas, con foco en: - Experiencia de usuario. - Integración de servicios. - Desarrollo de funcionalidades end-to-end. Esperamos que puedas aportar tanto en la capa frontend como backend, trabajando con buenas prácticas de desarrollo, diseño técnico y despliegue continuo. Qualifications - Capacidad de moverte cómodamente en un rol fullstack. - Buen criterio técnico para diseñar soluciones mantenibles. - Orientación a la calidad del código y buenas prácticas. - Capacidad de trabajo colaborativo con equipos multidisciplinarios. - Autonomía, proactividad y foco en la mejora continua. Requirements - Experiencia en desarrollo frontend con HTML5, CSS3, JavaScript. - Experiencia en ReactJS y manejo de Hooks. - Conocimientos en frameworks y herramientas modernas como Gatsby, Formik y Vite. - Experiencia en desarrollo backend con TypeScript y Node.js. - Experiencia en GraphQL Apollo. - Experiencia en consumo e integración de APIs REST. - Experiencia en desarrollo responsive bajo enfoque mobile first. - Manejo de Git. - Experiencia con GitLab CI/CD o herramientas similares de integración continua. - Experiencia trabajando con metodologías ágiles y herramientas como Jira, Kanban o Scrum. - Experiencia en desarrollo de microservicios reactivos. - Experiencia en Unit Testing con Jest. - Conocimientos en Servicios AWS, idealmente con experiencia en: - S3 - Lambda - API Gateway - EKS - CloudWatch - Redis - Manejo de SonarQube. - Conocimiento de UML, diagramas de secuencia y diagramas de proceso. - Conocimiento de patrones de diseño. - Manejo de principios SOLID y Clean Code. Benefits - Modalidad Remota (Desde Chile). - Contrato a plazo fijo con posibilidad de extensión acorde a desempeño y proyectos. - Ser parte de proyectos tecnológicos desafiantes. - Trabajo con equipos colaborativos y dinámicos. - Espacio para aportar desde lo técnico y seguir desarrollándote.
• Build and maintain web applications using React with JavaScript/TypeScript. • Develop and maintain backend services using Python. • Work with relational/SQL databases and NoSQL databases such as MongoDB. • Implement CI/CD pipelines and maintain unit tests to ensure code quality. • Collaborate and communicate effectively across a distributed team.
Senior Software Developer, Platform Experience
Wealthsimple TechnologiesWealthsimple is on a mission to help everyone achieve financial freedom by reimagining what it means to manage your money. Using smart technology, we take financial services that are often confusing and expensive and make them transparent and low-cost for everyone.
Build something people love Wealthsimple's mission is to help everyone achieve financial freedom – by making financial services simple, transparent, and low-cost. We're Canada's largest fintech, trusted by over 3 million clients with more than $100 billion in assets. We move fast, we own our work, and we care deeply about the people using our products. If that sounds like you, keep reading. We're proud of what we've built — and we're just getting started. Read our Culture Manual and learn more about how we work. About the team The Platform Experience team sits as a bridge between Platform and Product engineering. We enable product teams to ship reliable code by partnering directly with developers to solve production challenges and with implementation of systematic improvements. We're central to Wealthsimple's reliability mission: when our products are reliable, clients trust us with their financial future. We focus on protecting critical flows, reducing time to detect and resolve incidents, and ensuring we learn from every issue to prevent recurrence. About the role Reporting to the Manager of Software Development, you'll work alongside a senior group of Software Developers to improve reliability across Wealthsimple's products. You'll take ownership of significant components and services, partnering with product teams to identify and resolve production issues. This role offers the opportunity to work across the full stack, contribute to platform primitives that make reliability the default, and help maintain Wealthsimple’s high standard for security, reliability and user experience. What you'll do - Partner directly with product engineers to diagnose and resolve production issues, building solutions that prevent recurrence. - Take end-to-end ownership of system components, designing with reliability and maintainability as primary concerns. - Contribute to platform tools and frameworks that help all engineers ship reliably. - Collaborate with Platform, Product, and Data partners to align technical decisions with client needs. - Help establish technical standards and best practices for development at Wealthsimple. Skills you bring - 6+ years of software development experience building products with demonstrated growth in technical scope and autonomy. - Experience in optimizing platform engineering and/or infrastructure. - Knowledge of 2 or more of the following languages: Ruby on Rails / TypeScript / Kotlin. - Experience using LLMs to drive broad changes across codebases (Claude). - Strong problem-solving skills with the ability to tackle complex issues across multiple systems and keen interest in getting to the root cause. - Experience designing and maintaining production systems with high availability requirements. - Strong communication and collaboration skills. You can explain complex technical concepts clearly and work effectively with stakeholders across different backgrounds. Why Wealthsimple? 🌸 Top-tier health benefits and life insurance 📈 Long-term group savings with employer match, through Wealthsimple for Business 🌴 20 vacation days, 4 wellness days, and unlimited sick and mental health days per year ✈️ 90 days away: work outside Canada for up to 90 days per year 👥 Employee resource groups, including Rainbow (2SLGBTQ), Women of WS, and Black at WS 🌎 We are a hybrid team with over 1,500 employees across North America. The people are one of the best parts of working here: you'll collaborate with incredibly talented, curious, and driven teammates who are deeply committed to doing great work. ICYMI Technology & Innovation at Wealthsimple: We move quickly and build thoughtfully. That means we're always looking for better ways to work — whether that's new tools, AI, or rethinking how we approach a problem. We don't expect you to have all the answers, but we do expect curiosity and a willingness to evolve alongside the products we're building. Inclusion Statement: We're building products for a diverse world, and we need a diverse team to do it well. We strongly encourage applications from everyone, regardless of race, religion, colour, national origin, gender, sexual orientation, age, marital status, or disability status. Accessibility Statement: We're committed to an accessible hiring experience. If you need any accommodations throughout the interview process, please let us know — we'll work with you to make sure you have what you need. We also welcome any feedback on how we can better accommodate candidates with accessibility needs. AI in Hiring: We may use artificial intelligence (AI) tools to support parts of our hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our team but don't replace human judgment – all final hiring decisions are made by people. If you have questions about how your data is used, reach out to us.


