Clinical Trials Data and Technology Analyst

RIH Rhode Island Hospital; Rhode Island; Hybrid; USD 78,000 - 129,000; Full time

Job summary

Brown University Health is seeking a Clinical Trials Data and Technology Analyst to advance data-driven applications and optimize data pipelines. The Senior Analyst will work with cross-functional teams to enhance business intelligence, data visualization, and cloud-based data architecture including Snowflake integration and API use.

Responsibilities include data querying, reporting, and supporting eRegulatory systems, Redcap, and datamart development.

Qualifications

• Experience integrating data from diverse sources and systems with complex databases.
• Ability to assess data completeness and quality to support data-driven decisions.
• Strong collaboration with medical professionals and research staff.

Responsibilities

• Engage with customers, technical teams, and leadership to align application setup with objectives.
• Design data structures and schemas; craft reports for insights.
• Provide training and user support for staff on BI tools.
• Stay updated on features to drive continuous improvement.
• Manage documentation and change control procedures; liaise with vendors.

Skills

Data integration

Data quality analysis

Analytical thinking

Interpersonal skills

Autonomy & collaboration

Power BI

Tools

Jasper Studio

Python

PySpark

R

Job description

SUMMARY

The Clinical Trials Data and Technology Analyst plays a pivotal role specializing in the development and advancement of our data-driven applications (OnCore, eReg, OnCore/Epic interface, Fabric, Snowflake). Focused on optimizing data engineering, streamlining data pipelines, and elevating application management, the Senior Analyst will collaborate closely with cross-functional teams to enhance business intelligence and data visualization. Working under the direction of the Clinical Trials Data and Technology Manager, this role encompasses responsibilities in querying and extracting data, deploying pipelines for business intelligence, and managing cloud-based data architecture, including Snowflake integration and API utilization. Brown University Health employees are expected to successfully role model the organization's values of Compassion, Accountability, Respect, and Excellence as these values guide our everyday actions with patients, customers and one another. In addition to our values, all employees are expected to demonstrate the core Success Factors which tell us how we work together and how we get things done. The core Success Factors include: Instill Trust and Value Differences Patient and Community Focus and Collaborate

RESPONSIBILITIES

• Engages and consults with customers, technical teams, and leadership to align application setup with strategic objectives.
• Designs data structure and schema for data collection and crafts custom reports for comprehensive insights.
• Provides technical training and user assistance for staff, ensuring proficient usage of applications.
• Stays abreast of application features and technological advancements to drive continuous improvement.
• Maintains a repository of application documentation and change control procedures
• Serves as a liaison between the organization and external vendors, such as Advarra and other software providers.
• Collaborates with cross-functional teams on data pipelines, data analysis, data visualization, and metric reporting.
• Identifies requirements, prioritizes enhancements, and develops reports that align with organizational reporting needs.
• Participates in data migration and data flow initiatives to ensure seamless integration across systems.
• Develops programs using relevant programming languages to transform and manipulate data, facilitating information reformatting and new file creation.
• Manages and optimize cloud-based data storage and retrieval processes, leveraging modern technologies like Snowflake and APIs.
• Oversees the management of eRegulatory systems to ensure compliance and data integrity.
• Provides support for the Redcap ecosphere within Clinical Trial Management, ensuring efficient data management.
• Serves as the technical lead in the development and management of the datamart and informatics structure, which underpins the organization's reporting program.

MINIMUM QUALIFICATIONS

• Showcase experience in integrating data from diverse sources and systems, exhibiting high-level manipulation of intricate databases.
• Demonstrate analytical skills to assess data completeness, quality, and acceptability, contributing to data-driven decision-making.
• Display exceptional interpersonal skills to effectively collaborate with medical professionals, research staff, and trainees, fostering a deeper understanding of research studies.
• Exhibit the ability to work autonomously and collaboratively, adapting to diverse project requirements.
• Previous exposure to analysis reporting tools such as Power BI, Jasper Studio, R, and Python and PySpark is preferred.
• Leverage strong organizational skills to efficiently manage a dynamic portfolio of requests and projects.
• Proficiency in leveraging Fabric's unified analytics platform to manage, store, and analyze data within Lakehouse architectures, including experience with Dataflow version 2 for advanced ETL operations.

Pay Range: $78,416.00-$129,355.20

EEO Statement: Brown University Health is committed to providing equal employment opportunities and maintaining a work environment free from all forms of unlawful discrimination and harassment.

Location: Remote-Rhode Island - N/A Providence, Rhode Island 02901

Work Type: M-F 8:00am-5:00pm

Work Shift: Day

Daily Hours: 8 hours

Driving Required: No

As Rhode Island's largest health system and private employer, Brown University Health is the state's premier provider of health services and includes the only Level I Trauma Center for southeastern New England. Today, more than 20,000 people work at Brown University Health and bring their unique skills, experiences, and compassion to their jobs every day.

Formed in 1994, Brown University Health is a not-for-profit health system based in Providence, RI comprising three teaching hospitals of The Warren Alpert Medical School of Brown University: Rhode Island Hospital and its Hasbro Children's; The Miriam Hospital; and Bradley Hospital, the nation’s first pediatric psychiatric hospital for children; Newport Hospital, Saint Anne's Hospital and Morton Hospital, community hospitals offering a broad range of health services; Gateway Healthcare, the state’s largest provider of community behavioral health care; and Brown Health Medical Group, the largest multi-specialty practice in Rhode Island. Brown University Health is an equal opportunity employer that values diversity of cultural background, race, gender, age, religion, identity, ability, and perspectives - we are actively committed to a diverse workforce that represents the patients and community that we serve. We are invested in creating a respectful, inclusive, and equitable environment that supports the holistic well-being of our employees and their families. Join us and help build a healthier future for our patients - and for yourself.

Company Location Belonging and Engagement Nursing Our Mission