Senior Manager, Clinical Data Warehouse Research
Boston Medical Center (BMC)
full-time
Posted on:
Location Type: Remote
Location: Remote • Massachusetts • 🇺🇸 United States
Visit company websiteSalary
💰 $104,000 - $151,000 per year
Job Level
Senior
Tech Stack
PythonSQL
About the role
- 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.
Requirements
- 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.
- Experience leading initiatives to enhance workflows, optimize data-related processes, and improve operational efficiency.
- Master's degree (preferred).
- Experience working in clinical research (preferred).
- Experience supervising staff or project teams (preferred).
- 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 APIs within a Data as a Service (DaaS) environment to enhance research data accessibility.
- Expert knowledge of clinical data warehouses and research regulations.
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.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
Structured Query Language (SQL)data warehouse solutionsstored proceduresviewscode blocksperformance tuningquery plan analysisdata extractiondata provisioningdata integration
Soft skills
team managementperformance appraisalmentorshipcollaborationprocess developmentoperational efficiencycommunicationguidanceproblem-solvingleadership
Certifications
Bachelor’s degreeMaster's degree (preferred)