Sr Data Engineer

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 projectsDesign and oversee database models, schemas, data processing scripts, and data validation approachImplement data governance policies consistent with client requirementsGuide the development of data management framework that meets business needs and ensures users can find the information they need with speed and precisionEnsure data quality in deployments of the Casebook Platform and provide guidance to maintain data integrity and qualityWork with data engineers, developers and product team to ensure a common understanding of application behavior and data requirementsProvide leadership in building automated data transformation framework for legacy data integrationWork closely with system integration partner and client data engineering teamsConsult with engineers on data models to ensure that new data elements are well-defined to support functionality additions effectivelyDevelop and track measures regarding the effectiveness and usability of features and the quality of collected dataEvaluate and recommend data products, tools and services to support variable reporting business needsReview and sign off on production data fixesModel 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