Boston Medical Center (BMC)
Senior Manager, Clinical Data Warehouse Research
Boston Medical Center (BMC), Boston, Massachusetts, us, 02298
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)
Reporting to the Director of Research Analytics and Reporting, the Senior Manager, Clinical Data Warehouse Research (CDW-R) leads an Operations Manager and a team of analysts responsible for high‑quality, compliant, and efficient data extraction, provisioning, and reporting to support research initiatives. The 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.
Responsibilities
Manage an Operations Manager and a team of analysts: oversee, prioritize workloads, allocate resources, conduct performance appraisals, and discipline staff as needed.
Train and support analysts in SQL query development, complex data, and data provisioning; provide guidance on best practices and query optimization.
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 CDW‑R, including timely responses to Privacy and Compliance data disclosure requests.
Serve as the primary point of contact for escalated CDW‑R user issues, 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—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.
Qualifications
Bachelor’s degree in computer science, information systems, biostatistics, public health, or related field; 5+ years of hands‑on experience designing, writing, and optimizing complex SQL queries, stored procedures, views, and code blocks within data warehouse or analytics environments, including performance tuning and query plan analysis.
At least two years of experience working with clinical healthcare data and implementing and supporting enterprise‑wide data warehouses.
Proficiency in leveraging electronic medical record (EMR) data through Epic Clarity and Caboodle to extract, transform, and manage clinical research data.
Experience leading initiatives to enhance workflows, optimize data‑related processes, and improve operational efficiency.
Preferred
Master’s degree.
Experience working in clinical research.
Experience supervising staff or project teams.
Benefits
Competitive pay
Tuition reimbursement and tuition remission programs
Highly subsidized medical, dental, and vision insurance options
Career advancement and professional development opportunities
Pioneering research projects in biomedical science
Boston Medical Center, a Boston University Affiliated Center, is an Equal Opportunity/Affirmative Action Employer. If you require accommodation for any part of the application process due to a medical condition or disability, please contact Talent Acquisition by email at Talentacquisition@bmc.org or by phone at 617‑638‑8582.
Compensation Range:
$104,000.00 – $151,000.00. This estimate is based on minimum qualifications; total compensation includes competitive salary, bonuses, benefits, and professional development resources.
Equal Opportunity Employer/Disabled/Veterans. Only applications received through our website are considered; we do not accept applications via email or text messages.
#J-18808-Ljbffr
Reporting to the Director of Research Analytics and Reporting, the Senior Manager, Clinical Data Warehouse Research (CDW-R) leads an Operations Manager and a team of analysts responsible for high‑quality, compliant, and efficient data extraction, provisioning, and reporting to support research initiatives. The 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.
Responsibilities
Manage an Operations Manager and a team of analysts: oversee, prioritize workloads, allocate resources, conduct performance appraisals, and discipline staff as needed.
Train and support analysts in SQL query development, complex data, and data provisioning; provide guidance on best practices and query optimization.
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 CDW‑R, including timely responses to Privacy and Compliance data disclosure requests.
Serve as the primary point of contact for escalated CDW‑R user issues, 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—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.
Qualifications
Bachelor’s degree in computer science, information systems, biostatistics, public health, or related field; 5+ years of hands‑on experience designing, writing, and optimizing complex SQL queries, stored procedures, views, and code blocks within data warehouse or analytics environments, including performance tuning and query plan analysis.
At least two years of experience working with clinical healthcare data and implementing and supporting enterprise‑wide data warehouses.
Proficiency in leveraging electronic medical record (EMR) data through Epic Clarity and Caboodle to extract, transform, and manage clinical research data.
Experience leading initiatives to enhance workflows, optimize data‑related processes, and improve operational efficiency.
Preferred
Master’s degree.
Experience working in clinical research.
Experience supervising staff or project teams.
Benefits
Competitive pay
Tuition reimbursement and tuition remission programs
Highly subsidized medical, dental, and vision insurance options
Career advancement and professional development opportunities
Pioneering research projects in biomedical science
Boston Medical Center, a Boston University Affiliated Center, is an Equal Opportunity/Affirmative Action Employer. If you require accommodation for any part of the application process due to a medical condition or disability, please contact Talent Acquisition by email at Talentacquisition@bmc.org or by phone at 617‑638‑8582.
Compensation Range:
$104,000.00 – $151,000.00. This estimate is based on minimum qualifications; total compensation includes competitive salary, bonuses, benefits, and professional development resources.
Equal Opportunity Employer/Disabled/Veterans. Only applications received through our website are considered; we do not accept applications via email or text messages.
#J-18808-Ljbffr