💡 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

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

• Subject matter expertise in Business Intelligence toolings and solutions

• Bachelor’s degree in computer science, information management or information systems, or equivalent experience

Why Join Us?

• Casebook PBC is proud to be a certified Great Place to Work: https://www.greatplacetowork.com/certified-company/7015438

• Competitive salary and benefits.

• Opportunities for professional growth and development.

• Collaborative and supportive team environment.

• The chance to make a real difference by supporting those who help others.

Compensation:  $ 125,000 - 160,000 Salary + Bonus + Benefits + Equity
 

Demo of Casebook: https://play.goconsensus.com/ac9bc58df

Additionally, Casebook PBC offers competitive salaries and a comprehensive benefits plan, including fully funded medical, dental and vision plans, 401k contributions and generous paid time off.

We value our employees and are committed to supporting them as they help make our vision a reality.

Visa sponsorship for this role is currently not available.