Senior Data Engineer

Summary

Join Casebook PBC as a Senior Data Engineer and lead the maintenance, updates, and optimization of our PostgreSQL and Redshift databases within a large, live microservices cloud-native system. You will be responsible for data modeling, designing data pipelines for reporting and analytics, and ensuring data quality. This role also involves serving as a data domain expert in client engagements. You will collaborate with cross-functional teams, including data engineers, developers, and product teams. Casebook offers a competitive salary and benefits package, including fully funded medical, dental, and vision plans, 401(k) contributions, company shares, and generous paid time off.

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
• Bachelor’s degree in computer science, information management or information systems, or equivalent experience

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

Preferred Qualifications

• 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

Benefits

• Fully funded medical, dental, and vision plans
• 401(k) contributions
• Company shares
• Generous paid time off to recharge and refresh
• Competitive salary and benefits package
• Professional growth opportunities