Senior Software Engineer, Data Platform

Remote In: CA, CO, CT, Washington DC, FL, GA, IA, IL, IN, KS, LA, MA, MD, NC, NJ, NV, NY, OR, TX, UT, VA, VT, WA

AgentSync is built on Salesforce and AWS, effectively leveraging every aspect of those platforms and pushing the edges of what is possible within their ecosystems. We treasure stability, scalability, and customer experience as first-order principles, striving to create thoughtful, delightful user interfaces and seamless workflows. Behind the scenes, we build secure, scaled integrations into database sources of truth (e.g. NIPR, FINRA), obscuring the complexity of this data through translation into an understandable, reportable data model.

As a Senior Software Engineer (Data) on the Data & API Platform team, you will lead the design, development, and maintenance of critical data-intensive services that form the foundation of AgentSync’s product offerings. You'll play a pivotal role as a thought leader and innovation catalyst, collaborating on the design of new services and enhancing existing ones to integrate seamlessly across our product suite and systems.

What you’ll do:

• Architect, design, develop, and maintain scalable and efficient production data services using software development and ETL/ELT best practices and patterns
• Monitor and troubleshoot database performance issues, identifying bottlenecks and implementing solutions (optimized queries, indexes, schema designs, etc.) to improve performance and uptime
• Create robust systems and processes to ensure the accuracy and reliability of data across the AgentSync ecosystem.
• Drive productivity and efficiency improvements by evaluating and implementing appropriate technologies and processes to support Data & API platform initiatives
• Champion code quality through comprehensive testing, code reviews, documentation, and advocacy of development best practices
• Collaborate with cross functional team members (e.g. product managers) to understand data requirements and translate them into technical solutions
• Mentor and support less senior engineers in development practices, database design, and troubleshooting techniques

Your experience:

• Advanced experience with SQL, database performance tuning, query optimization, and database schema design (dbt experience is a plus)
• Advanced experience with Python (any experience with golang or Java is a plus)
• A proven track record of implementing complex data extraction solutions (ETL/ELT)
• Experience with event-driven architectures and technologies such as Kafka
• Experience with workflow orchestration tools such as Dagster or Airflow
• Experience with infrastructure as code tools such as Terraform
• Experience working with an AWS architecture to develop and maintain data …