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, 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 Casebook?
Great Place to Work Certified: We’re proud of our collaborative and supportive culture.
Competitive salary and benefits package.
Professional growth opportunities.
The chance to make a real difference by supporting those who help others.
Compensation: $ 125,000 - 160,000 Salary + Bonus + Benefits + Equity
See Casebook in action - Demo of Casebook: https://play.goconsensus.com/ac9bc58df
Additional Information
Benefits & Additional Information
At Casebook PBC, we offer:
Fully funded medical, dental, and vision plans.
401(k) contributions.
Company shares
Generous paid time off to recharge and refresh.
Visa sponsorship for this role is currently not available.