Sr Data Engineer

Company Description

At Casebook PBC, our software makes people’s lives better. Our company is committed to empowering community well-being through the delivery of adaptive, research-based and practice-driven technology. Designed to “help the helpers,” our innovative and award-winning SaaS solutions help improve outcomes in human services. We are continually expanding and updating the Casebook Platform in the hopes that our technology will reach a broader array of agencies, and that we will push the entire industry to innovate and aspire to a higher standard. 

Job Description

About Engineering Team:

At Casebook, our Engineering team is the driving force behind innovation and efficiency within our technological infrastructure. Comprising passionate experts in development, operations, and automation, they ensure seamless deployment pipelines and champion best practices in infrastructure as code. Through close collaboration with cross-functional teams, they bridge the gap between development and operations, fostering a culture of collaboration and shared responsibility. With a relentless focus on innovation and optimization, they remain at the forefront of emerging technologies, ensuring 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, 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

Additional Information

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.