Senior Manager, Clinical Data Warehouse Research

Position: Senior Manager, Clinical Data Warehouse Research

Department: Research - Support Services

Location: Boston, MA

Schedule: 40 hours per week, Remote (must be able to work Eastern Standard Time business hours)

The Senior Manager, Clinical Data Warehouse for Research (CDW‑R), reporting to the Director of Research Analytics and Reporting, leads and manages an Operations Manager and a team of analysts responsible for high‑quality, compliant, and efficient data extraction, provisioning, and reporting to support research initiatives. This role provides technical guidance in Structured Query Language (SQL) query development, implements and maintains data warehouse solutions, and ensures adherence to research and hospital data policies.

The Clinical Data Warehouse Research consolidates data from a wide range of legacy and current clinical systems, including Epic, using SQL Server; and works to ensure secure, accurate, and reproducible data retrieval for investigators across the Health System.
Proficiency in leveraging electronic medical record (EMR) data through Epic Clarity and Caboodle to extract, transform, and manage clinical research data is required.

• Manage an Operations Manager and a team of analysts:
  Manage performance of direct reports and team as a whole, prioritize and assign workloads, allocate resources, conduct performance appraisals, discipline staff as needed
• Train and support analysts in Structured Query Language (SQL) query development, complex data extraction, and data provisioning, providing guidance on best practices, query optimization, and fostering skill development to ensure all datasets are accurate, high‑quality, and compliant for research initiatives.
• Manage team performance and resources to oversee data warehouse extractions and data provisioning for the research community, translating complex data requests into clear, impactful datasets that support organizational goals.
• Design, develop, and implement data warehouse solutions, including views, stored procedures, and code blocks to access and transform large volumes of structured and semi‑structured data.
• Facilitate project completion by coordinating communication, developing documentation and specifications, performing testing, and consulting with research and IT teams.
• Establish governance and prioritization processes for the Clinical Data Warehouse for Research (CDW‑R), including overseeing timely responses to Privacy and Compliance data disclosure requests.
• Manage CDW‑R user relationships, serving as the primary point of contact for escalated user issues and setting clear expectations regarding data extraction capacity, research regulations, governance, and timelines.
• Collaborate with enterprise stakeholders, including researchers, clinicians, IT, Analytics Infrastructure, Institutional Review Board (IRB), Human Research Protection Program (HRPP), Privacy, Legal, and Compliance teams, to implement solutions that improve data collection, quality, and accessibility.
• Provide guidance and technical support to teams on system interfacing, platform usage, and implementation of data warehouse strategies.
• Stay current with trends and best practices in data analytics, informatics, and research methodologies to enhance team capabilities and CDW‑R platform performance.

(The above statements in this job description are intended to depict the general nature and level of work assigned to the employee(s) in this job. The above is not intended to represent an exhaustive list of accountable duties and responsibilities required).

• Bachelor's degree in computer science, Computer Information Systems, Applied Biostatistics, Public Health, Systems Improvement, Information Science, Research, or related field; and 5+ years of hands‑on experience designing, writing, and optimizing complex Structured Query Language (SQL) queries, stored procedures, views, and code blocks within data warehouse or enterprise analytics environments, including performance tuning and query plan analysis. At least two years of the above experience must include working with clinical…