Clinical Trials Data and Technology Analyst

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.

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.

Other information:

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.

Brown University Health is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race color religion sex national origin age ethnicity sexual orientation ancestry genetics gender identity or expression disability protected veteran or marital status. Brown University Health is a VEVRAA Federal Contractor.

Location: Rhode Island Hospital USA:RI:Providence

Work Type: Full Time

Shift: Shift 1

Union: Non-Union