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)

POSITION SUMMARY:

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.

JOB RESPONSIBILITIES:

• 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).

JOB REQUIREMENTS

REQUIRED EDUCATION AND EXPERIENCE:

• 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 healthcare data and implementing and supporting enterprise-wide data warehouses. Or equivalent combination of education and experience.

• Experience leading initiatives to enhance workflows, optimize data-related processes, and improve operational efficiency

PREFERRED EDUCATION AND EXPERIENCE:

• Master's degree

• Experience working in clinical research

• Experience supervising staff or project teams

KNOWLEDGE, SKILLS & ABILITIES (KSAs):

• Ability in process development and system-level improvement,

• Skilled in developing processes or policies for data use and governance to ensure consistency, compliance, and data quality.

• Ability to supervise teams, providing guidance and mentorship to ensure work aligns with data standards and organizational goals.

• Adept at collaborating with scientific oversight committees to enhance the rigor, quality, and reproducibility of data-related processes.

• Proficiency in leveraging electronic medical record (EMR) data through Epic Clarity and Caboodle to extract, transform, and manage clinical research data.

• Advanced knowledge of enterprise-wide data warehouses, including design, integration, implementation, and optimization of large-scale datasets.

• Skilled in Structured Query Language (SQL) and at least one programming language (e.g., Python, R) for querying, transforming, and analyzing research data.

• Ability to implement and support data integrations and Application Programming Interfaces (APIs) within a Data as a Service (DaaS) environment to enhance research data accessibility.

• Expert knowledge of clinical data warehouses and research regulations

JOB BENEFITS:

• Competitive pay
• Tuition reimbursement and tuition remission programs
• Highly subsidized medical, dental, and vision insurance options
• Career Advancement/Professional Development: Access a wealth of ongoing training and development opportunities that will not only enhance your skills but also expand your knowledge base.
• Pioneering Research: Engage in groundbreaking research projects that are driving the forefront of biomedical science.

ABOUT THE DEPARTMENT:

As the primary teaching hospital for Boston University Chobanian & Avedisian School of Medicine and BU schools of public health and dentistry, intellectual rigor shapes our inquiries. Our research is led by a belief that skin color, zip code, and financial circumstances shouldn't dictate health.

Boston Medical Center is an Equal Opportunity/Affirmative Action Employer.If you need accommodation for any part of the application process because of a medical condition or disability, please send an e-mail toTalentacquisition@bmc.orgor call617-638-8582to let us know the nature of your request.

Compensation Range:

This range offers an estimate based on the minimum job qualifications. However, our approach to determining base pay is comprehensive, and a broad range of factors is considered when making an offer. This includes education, experience, skills, and certifications/licensures as they directly relate to position requirements; as well as business/organizational needs, internal equity, and market-competitiveness. In addition, BMCHS offers generous total compensation that includes, but is not limited to, benefits (medical, dental, vision, pharmacy), discretionary annual bonuses and merit increases, Flexible Spending Accounts, 403(b) savings matches, paid time off, career advancement opportunities, and resources to support employee and family well-being.

NOTE: This range is based on Boston-area data, and is subject to modification based on geographic location.

Equal Opportunity Employer/Disabled/Veterans

According to the FTC, there has been a rise in employment offer scams. Our current job openings are listed on our website and applications are received only through our website. We do not ask or require downloads of any applications, or "apps" job offers are not extended over text messages or social media platforms. We do not ask individuals to purchase equipment for or prior to employment.