Clinical Trials Data and Technology Analyst

Rhode Island Hospital; United States; Remote; USD 78,000 - 129,000; Full time

Job summary

Brown University Health seeks a Clinical Trials Data and Technology Analyst to advance data-driven applications (OnCore, eReg, OnCore/Epic interface) and optimize data pipelines and cloud data architecture including Snowflake and API usage.

The role collaborates with cross-functional teams, provides training, designs data structures, and develops reports to support BI and informatics across the Clinical Trials program.

Qualifications

• Experience integrating data from diverse sources and systems with complex databases.
• Strong analytical skills to assess data quality and completeness for decision-making.
• Ability to work with medical professionals, researchers, and staff and translate needs into data solutions.
• Able to work autonomously and collaboratively across multiple projects.
• Proficiency with Power BI, Jasper Studio, R, Python, PySpark; familiarity with Fabric Lakehouse/Dataflow v2.

Responsibilities

• Engages with customers, technical teams, and leadership to align setup with objectives.
• Designs data structures and schemas; crafts custom reports for insights.
• Provides training and user support for staff on BI tools and data platforms.
• Keeps up with features and tech advances to drive improvements.
• Manages data pipelines, cloud storage, Snowflake, and API integrations.

Skills

Analytical thinking

Collaboration

Autonomy

Communication

Tools

Power BI

Jasper Studio

R

Python

PySpark

Snowflake

APIs

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:

BASIC KNOWLEDGE: 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.Technical Proficiency: Previous exposure to analysis reporting tools such as Power BI, Jasper Studio, R, and Python and PySpark is preferred.Organizational Expertise: 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