Data Engineer

Join Smarsh, a leading provider of compliance solutions for the financial services industry. As a Database Engineer, you will be a subject-matter expert for our data infrastructure, driving architecture, scaling, and reliability decisions. You will work with SQL Server environments, tackle complex technical problems, and shape how our clients meet their compliance needs. Enjoy a range of benefits, including flexible time off, wellness programs, retirement savings, and more.

• Operar como experto en la materia para la infraestructura de datos que impulsa la plataforma, tomando decisiones sobre arquitectura, escalabilidad y confiabilidad.
• Trabajar de manera independiente en problemas ambiguos y desconocidos, estableciendo la dirección técnica para los pipelines de datos en tiempo real y el rendimiento del sistema.
• Colaborar con líderes de diferentes áreas para resolver desafíos complejos y influir en la estrategia más allá de su equipo inmediato.

• We're looking for someone who brings deep technical judgment, mentors others, and is motivated to make an impact through thoughtful, high-leverage engineering
• A demonstrated ability to set database performance strategy by tuning queries and indexes and establishing standards that others follow
• Strong command of data security practices (encryption, access controls, auditing), with the ability to shape how the team approaches them
• We're looking for a recognized subject-matter expert who operates independently, drives clarity through ambiguity, and raises the bar for those around them
• Deep expertise designing logical and physical data models, including schema design and data relationships, at a level others rely on for direction
• Ability to communicate technical direction, trade-offs, and risk clearly to stakeholders outside your immediate team
• Ability to plan for data growth and scale infrastructure with the full flow of work in mind, not just the immediate ask
• The credibility and collaborative instinct to influence peers and cross-functional partners, not just execute their requests
• Advanced, wide-ranging experience with database systems, with the judgment to operate independently in unfamiliar or ambiguous situations
• Strong command of modern development practices and Agile methodologies, with a voice in how the team applies them
• A track record of independently troubleshooting complex issues in systems that require high availability, serving as an escalation point for others
• A proactive approach to identifying and solving problems that cross team boundaries
• Comfort setting a course through evolving, ambiguous requirements rather than waiting for them to be resolved
• If you don't meet every qualification listed below, we still encourage you to apply. We value diverse experiences and perspectives. Progression to this level reflects demonstrated ability to perform as a subject-matter expert, not years of experience alone
• 7+ years of hands-on experience with Microsoft SQL Server in a production environment, with demonstrated impact as a subject-matter expert
• Deep expertise in schema and data model design, including normalization, partitioning, and indexing strategy for both OLTP workloads
• Advanced proficiency in performance tuning, including T-SQL and stored procedure optimization, execution plan analysis, and query tuning at scale
• Proven, hands-on experience managing and troubleshooting SQL Server databases at terabyte scale, including tables with billions of rows, and sustained throughput exceeding 100k transactions per second
• Demonstrated ability to diagnose and resolve production capacity and contention issues at this scale, including lock/latch contention, TempDB performance, and transaction management
• Experience designing for horizontal as well as vertical scalability, anticipating data growth before it becomes a production risk
• Familiarity with NoSQL technologies (e.g., MongoDB, Cassandra, DynamoDB) is a plus
• Experience with cloud database platforms (e.g., AWS RDS/Aurora, MongoDB Atlas) is a plus