Senior Data and Database Engineer

LENA is a national nonprofit on a mission to transform children’s futures through early talk technology and data- driven programs. Research shows that back-and‐forth interaction between children and their adult caregivers in the earliest years is a key to long‐term outcomes. We integrate our “talk pedometer” technology into innovative programs to support parents, caregivers, and teachers to accelerate children’s language development, school readiness, and social-emotional health.

• Develop a deep understanding of the data and data structures in use w where the data is, how it relates to other data, and how to use it. Readily share and teach this knowledge to others.
• Set and implement the standards by which we store, move, delete, secure, and access data. Ensure that we comply with internal and external standards, best practices, and regulatory requirements when applicable. This also includes maximizing data and database performance and availability.
• Ensure accuracy and correctness in data-driven outputs to the greatest extent possible; work with Product Managers, the Research Team, the Partner Success Team and others to establish agreed upon algorithms and computations, help to ensure that the same “number” is reported in the “same way” across outputs.
• Define the data schemas for our data storage mechanisms. Ensure that data pipelines can operate across different schemas where applicable. Apply the same or similar schema standards to the furthest extent possible.
• Work with others on the Software Development Team, develop the back-end SQL, software code, and other items to support LENA Online and other systems; embed business logic to the greatest extent possible, design for simplicity and future change, and tune for performance.
• Support ad-hoc data requests from LENA management and others and help requestors to determine exactly what they need to fulfill their request and accurately; support the Partner Success Team and the Help Desk operation by performing various data change and deletion tasks.
• Investigate and implement new technologies and/or techniques that enable better performance, support significant scale-up, and/or decrease hard or soft costs related to data storage and data driven outputs.
• Perform other duties as assigned.

• Demonstratable experience creating, managing, and ensuring the performance of large, mission critical and high-transaction databases, data pipelines, and reporting mechanisms servicing both internal and external users in B2B environments.
• Experience using 100% cloud-based data products and services across multiple cloud providers.
• Ability to readily understand complex mathematical formulas and algorithms; to create and augment complex data models; and to monitor and troubleshoot incoming and outgoing data pipelines with sometimes unreliable data.
• To appropriately use AI to troubleshoot issues, modify existing solutions, or to provide starting points for new solutions.
• Expert in T-SQL;
  Advanced in Azure Power Platform, JSON, DAX;
  Proficient in Amazon RDS, Docker, Honeycomb, Flyway, Git, Jenkins, DynamoDB;
  Some Microsoft SQL DBA experience
• Understanding of agile SDLC processes and ability to work in “sprints”
• Excellent organizational skills and attention to detail.

A bachelor’s degree in Computer Science, Engineering, or related field, or equivalent work experience. At least 7 years previous experience in the areas/technologies described.

• Mission-driven. It matters to you that your work makes a positive and durable impact on the world, and LENA’s mission speaks to you. You are culturally competent and…