Clinical Trials Data and Technology Analyst
About The Position
The Clinical Trials Data and Technology Analyst develops and advances data-driven applications, including OnCore, eReg, the OnCore/Epic interface, Fabric, and Snowflake. The role focuses on optimizing data engineering, streamlining data pipelines, improving application management, and supporting business intelligence and data visualization. Under the direction of the Clinical Trials Data and Technology Manager, the analyst queries and extracts data, deploys business-intelligence pipelines, and manages cloud-based data architecture, including Snowflake integration and API use. The analyst works with customers, technical teams, leadership, and cross-functional partners to align application configuration and reporting with organizational needs. The role includes application training and support, documentation and change control, vendor liaison responsibilities, data migration and integration, eRegulatory system management, and support for the REDCap ecosystem within Clinical Trial Management. The analyst also serves as technical lead for development and management of the datamart and informatics structure supporting the organization’s reporting program. Brown University Health employees are expected to model the organization’s values of Compassion, Accountability, Respect, and Excellence, and demonstrate the core Success Factors: Instill Trust and Value Differences, Patient and Community Focus, and Collaborate.
Requirements
- Experience integrating data from diverse sources and systems and manipulating complex databases.
- Analytical skills to assess data completeness, quality, and acceptability.
- Interpersonal skills to collaborate with medical professionals, research staff, and trainees and develop understanding of research studies.
- Ability to work autonomously and collaboratively and adapt to different project requirements.
- Strong organizational skills to manage a dynamic portfolio of requests and projects.
- Proficiency with Fabric’s unified analytics platform for managing, storing, and analyzing data in Lakehouse architectures, including Dataflow version 2 for advanced ETL operations.
Nice To Haves
- Previous exposure to reporting and analysis tools such as Power BI, Jasper Studio, R, Python, and PySpark.
Responsibilities
- Consults with customers, technical teams, and leadership to align application setup with strategic objectives.
- Designs data structures and schemas for data collection and creates custom reports.
- Provides technical training and user assistance to staff using applications.
- Keeps current with application features and technological advancements to support continuous improvement.
- Maintains application documentation and change-control procedures.
- Acts as a liaison between the organization and external vendors, including Advarra and other software providers.
- Collaborates on data pipelines, data analysis, data visualization, and metric reporting.
- Identifies requirements, prioritizes enhancements, and develops reports aligned with organizational reporting needs.
- Participates in data migration and data-flow initiatives to support integration across systems.
- Develops programs using relevant programming languages to transform and manipulate data, reformat information, and create files.
- Manages and optimizes cloud-based data storage and retrieval using technologies such as Snowflake and APIs.
- Oversees eRegulatory systems to support compliance and data integrity.
- Supports the REDCap ecosystem within Clinical Trial Management.
- Leads the technical development and management of the datamart and informatics structure that supports the organization’s reporting program.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
