Clinical Trials Data and Technology Analyst

Lifespan; 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. You will work with cross-functional teams to enhance BI, data visualization, and cloud-based data architectures, including Snowflake integration and API usage.

Under the Clinical Trials Data and Technology Manager, you will query and extract data, develop reports, provide user training, and lead data mart and

Qualifications

• Experience integrating data from diverse sources and systems.
• Analytical skills to assess data quality and support data-driven decisions.
• Strong collaboration with clinicians, researchers, and staff.
• Ability to work autonomously and across projects.
• Proficiency with Power BI, Jasper Studio, R, and Python/PySpark.
• Experience with Fabric unified analytics and Lakehouse architectures.

Responsibilities

• Engage with customers and teams to align application setup with goals.
• Design data structures and craft custom reports for insights.
• Provide training and user support for staff on applications.
• Stay updated on new features to drive improvements.
• Coordinate with vendors and data teams for integration and governance.
• Develop data pipelines and analytics to support BI and reporting.
• Support data migration and flow initiatives across systems.
• Build data transformations and new file formats as needed.
• Optimize cloud storage and data retrieval using Snowflake and APIs.
• Oversee eRegulatory systems to ensure data integrity and compliance.

Skills

Data integration

Data analysis

Power BI

Python

PySpark

SQL

API usage

Team collaboration

Tools

Jasper Studio

R

Snowflake

Fabric

Dataflow v2

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