At Casebook PBC we build things that matter.

We are looking for a Lead Data Engineer to serve as a data architect and technical lead for “all things data” in the Casebook Platform. Responsibilities include data modeling, design of the data pipeline supporting reporting and analytics, data quality initiatives, and data analysis to improve our product and human services outcomes. The position is also responsible for serving as a data domain expert in client engagements.

What You’ll Do (Responsibilities):

• Create data vision, goals, and priorities for Casebook in collaboration with executive team
• Conceptualize and guide data processing, warehouse and analysis projects
• Design and oversee database models, schemas, data processing scripts, and data validation approach
• Implement data governance policies consistent with client requirements
• Guide the development of data management framework that meets business needs and ensures users can find the information they need with speed and precision
• Ensure data quality in deployments of the Casebook Platform
• Work with data engineers, developers and product team to ensure common understanding of application behavior and data requirements
• Develop human services domain expertise to provide effective leadership
• Ensure that data conversion from legacy human services systems into the Casebook data model yields high quality data
• Work closely with system integration partner and client data engineering teams
• Consult with engineers about how database tables should be structured, ensure that new data elements are well-defined; and consult on how validations are implemented.
• Develop and track measures regarding the effectiveness and usability of features and the quality of collected data.
• Evaluate and recommend data products, tools and services to support business needs
• Review and sign off on production data fixes
• Conceptualize and influence data related warehousing and interface projects

What You Have (Skills and Requirements):

• Exceptional ability to process and synthesize information to deliver optimal solutions and identify roadblocks.
• Candidates should have several years’ experience working with technical and operational management and process owners
• Strong ability to conceive and communicate the broader data picture
• Solid experience translating business requirements into conceptual, logical and physical data models
• Extensive experience with ETL design and implementation of multiple databases
• Experience with metadata definition, implementation and maintenance
• Ability to organize and prioritize multiple assignments
• Initiative and judgment to get results, work under pressure and complete job assignments in an accurate, timely and professional manner
• Strong presentation, interpersonal and communication skills
• Understanding of system development life cycle, technical project management approaches and requirements, design and test techniques
• Experience with PostgreSQL and related technologies strongly desired
• Experience with cloud services in data management and analysis, preferably AWS
• Strong experience with distributed platforms and information management systems.
• Experience doing data analysis with Python, R or Scala
• Bachelor’s degree in computer science, information management or information systems, or equivalent experience