Senior Engineer, API and Data (Open to Remote) (New York, NY, US, NY 10019)

About the Role

Day-to-day, this position involves a deep dive into the complexities of relational databases, including Oracle, PostgreSQL, and MySQL, to optimize performance, scalability, and reliability. The engineer will also be responsible for the enhancement and maintenance of legacy Java-based APIs, alongside the development of modern Python-based services. The ability to assess and mitigate downstream data impacts is crucial, as is the capacity to collaborate cross-functionally with various teams to ensure the alignment of technical strategies and goals.

Given the critical nature of this role, the Senior Engineer will be expected to demonstrate strong technical judgment, an ability to innovate, and a keen sense of problem-solving. The position offers a unique opportunity to influence both the current stability of systems and the future architectural direction of the company's platforms.

What You Will Do

• Own and evolve the data flows powering the Metadata API ecosystem, ensuring accuracy, scalability, and reliability across systems.
• Design and optimize relational database schemas, queries, and stored procedures across Oracle, PostgreSQL, and MySQL.
• Maintain and enhance legacy Java-based APIs, while contributing to the development of modern Python-based API services.
• Orchestrate ETL processes and manage the safe propagation of schema and data changes across upstream and downstream systems.
• Troubleshoot data and API issues, partnering cross-functionally on platform architecture, API design, and system improvements.
• Collaborate with cross-functional teams to align technical strategies and goals.
• Assess downstream data impacts across systems, ensuring minimal disruption to services.
• Develop and implement data models that serve as the 'source of truth' for the organization.
• Engage in continuous learning, adopting new technologies and methodologies to stay abreast of industry trends.
• Participate in the planning and execution of strategic projects, focusing on the modernization of legacy systems and the development of future platforms.

What We Are Looking For

• 5+ years of backend or data engineering experience, with strong SQL expertise across relational databases (Oracle, PostgreSQL, MySQL).
• Experience designing 'source of truth' data models and managing ETL pipelines or data propagation workflows.
• Proficiency in Java and Python for API development (JAX-RS and FastAPI a plus), and a solid understanding of RESTful design principles.
• Experience working in cloud-based, containerized environments (e.g., AWS, Kubernetes) with familiarity in CI/CD and version control.
• Strong problem-solving, communication, and collaboration skills, with the ability to assess downstream data impacts across systems.
• Ability to work effectively in a remote environment, with excellent time management and self-motivation skills.
• Experience with agile development methodologies and version control systems like Git.
• Knowledge of data security and privacy principles, ensuring the protection of sensitive information.

Nice to Have

• Experience with containerization using Docker and container orchestration using Kubernetes.
• Familiarity with NoSQL databases and their applications.
• Knowledge of data warehousing and business intelligence tools.
• Experience with DevOps practices and tools such as Jenkins, Terraform, or similar.

Benefits and Perks

• Competitive salary range.
• Annual profit award or bonus, subject to company results.
• Comprehensive benefits program, including Medical/Prescription drug insurance, Dental, and Vision.
• Health Care/Dependent Care Flexible Spending Account and Health Savings Account.
• Pre-Tax and Roth 401(k) options.
• Short and Long-Term Disability Insurance, Life/AD&D Insurance.
• Commuter Benefits and Student Loan Repayment Program.
• Educational Assistance and generous paid time off.
• Remote work stipend and support for home office setup.
• Access to cutting-edge technologies and training opportunities.
• Collaborative and dynamic work environment with a team of experienced professionals.

• Highlight transferable skills: Even if you don't have direct experience with all the required technologies, emphasize the skills you do have that could be transferable, such as experience with other programming languages or database systems.
• Prepare for technical assessments: Be ready for technical interviews or coding challenges. Practice solving problems on platforms like LeetCode or HackerRank to improve your coding skills.
• Showcase your projects: If you have personal projects or contributions to open-source projects, make sure to include them in your application. This can demonstrate your skills and passion for the field.
• Demonstrate your understanding of system architecture: Show that you have a solid grasp of how different components of a system interact and how you can optimize these interactions for better performance and scalability.
• Ask informed questions: During the interview, ask questions that demonstrate your interest in the company and the role, such as what challenges the team is currently facing or how the company approaches professional development for its engineers.