Sr Data Engineer - US Remote

Company Description

Company Description

At Casebook PBC, our software makes people’s lives better. We are committed to empowering community well-being through adaptive, research-based, and practice-driven technology. Designed to “help the helpers,” our innovative and award-winning SaaS solutions enhance outcomes in human services. We continually expand and evolve the Casebook Platform, aiming to support more agencies and inspire industry-wide innovation.

At Casebook PBC, we are dedicated to fostering a multicultural, unprejudiced, and welcoming workplace where everyone feels included and valued. We believe that different perspectives, backgrounds, and experiences strengthen our ability to innovate and serve our clients effectively. Every employee is respected and empowered to contribute at their highest potential. Our commitment goes beyond providing opportunities—we actively create an environment where everyone has the support, resources, and recognition they need to thrive.

Job Description

💡 Location: This is a remote US-based role. Candidates must be authorized to work in the US.

About the Engineering Team

At Casebook, our Engineering team drives innovation and efficiency across our technological infrastructure. This team of passionate experts collaborates with cross-functional teams to build seamless deployment pipelines, champion best practices, and stay at the forefront of emerging technologies. Their work ensures Casebook remains agile and adaptive in a rapidly evolving landscape.

Job Summary:

We are looking for a Senior Data Engineer to serve as a PostgreSQL and Redshift maintenance, update and optimization lead for a large and live microservices Cloud native system.  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):

• 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 and provide guidance to maintain data integrity and quality

• Work with data engineers, developers and product team to ensure a common understanding of application behavior and data requirements

• Provide leadership in building automated data transformation framework for legacy data integration

• Work closely with system integration partner and client data engineering teams

• Consult with engineers on data models to ensure that new data elements are well-defined to support functionality additions effectively

• 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 variable reporting business needs

• Review and sign off on production data fixes

• Model data growth to meet performance standards and lead strategy to assure current and future reporting performance experience 

• Lead planning and strategy to provide customers external access to data warehousing dataset and data reports

Qualifications

What You Have (Skills and Requirements):

• Exceptional ability to analyze highly normalized and distributed microservices based datasets to deliver lower normalization level warehouse database solution for optimal user reporting experience

• Candidates should have several years’ experience working with technical and operational management and process owners

• Strong ability to balance short and long term goals and communicate their trade-offs clearly

• 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, interpers