• Serve as the primary consultant for multiple clients, providing expert‑level guidance on EHR data structures, reporting capabilities, and best practices • Lead requirements‑gathering sessions and translate complex clinical and departmental workflows into actionable technical specifications • Build and maintain strong client relationships, ensuring satisfaction, transparency, and long‑term partnership • Anticipate client needs and proactively recommend solutions, improvements, or new data opportunities • Design, build, and optimize sophisticated EHR data extracts, with emphasis on Epic Clarity/Caboodle or Cerner CCL/HealtheIntent • Develop and refine SQL queries, data models, and extract logic to support analytics, reporting, and operational use cases • Ability to handle large-scale EHR datasets, ensure data integrity, completeness, and consistency • Troubleshoot complex data issues and collaborate with internal engineering teams to enhance data pipelines and performance • Adapt solutions to diverse client environments, EHR vendors, and module configurations • Lead validation efforts to ensure accuracy, completeness, and consistency of extracted EHR data • Conduct advanced root‑cause analysis on data discrepancies and guide clients through remediation strategies • Establish and maintain validation frameworks, documentation, and repeatable processes for long‑term data quality • Ensure all work adheres to healthcare data governance, privacy, and security standards • Collaborate with clinical, operational, and technical stakeholders across client organizations • Provide training, documentation, and knowledge transfer to empower clients in understanding and using their data • Mentor junior consultants, contribute to internal best practices, and support continuous improvement across the consulting team • Participate in solution design discussions and help shape the consulting practice’s methodology and standards