Overview
Skills
Job Details
TASKS / PROJECT RESPONSIBILITIES
*Liaise with reporting team and clinical project teams, as needed, to gather clinical report and data listing needs and requests to ensure that all of the report/data requirements are clearly understood and meet the requestor's requirements.
*Participate in the requirement collection, design, development, unit testing, user acceptance testing and maintenance of clinical study reports, and data deliverables for multiple clinical studies (databases) according to the department SOPs.
*Develop reports and dashboards using Power BI Desktop, MS Fabric and PBI Service.
* Liaise with the Report Development and Validation team to ensure report deliverables are released in accordance with rules and regulations and in corporate compliance.
* Liaise with Clinical IT, IT to address and resolve technical issues.
EXPERIENCE (Required and/or preferred work experience)
Required:
*5+ years developing reports and Dashboards using Power BI Desktop, Power BI Service, Power Query, Power Query M, and DAX, SQL or equivalent BI technology
*Experience with data modeling, data transformation, and data visualization
*Knowledge of SQL and ability to write moderately complex queries
*5+ years liaising with customers and documenting report requirements
*Proven ability to produce complex clinical study reports using Power BI
*Adherence to department SOPs and a regulated environment
*Good organizational skills and ability to adapt to changing priorities a must.
*Good communication skills - the ability to enable both technical and non-technical
*Ability to work independently and in a team environment on assigned projects within department required
*Excellent problem-solving skills, a proactive approach, and a willingness to make decisions on a regular basis and communicate these clearly required
Preferred:
*3+ years in another major reporting tool (Tableau, Cognos, SQL Server Reporting Service, Oracle Reports, Spotfire, etc.)
*1+ years working knowledge of the Medidata Rave EDC system or other EDC system (InForm, Oracle Clinical).
* Knowledge of clinical research processes, clinical data processing practices, relational database fundamental preferred
EDUCATION (Required and/or preferred degrees or other educational qualifications)
Required: B.S Computer Science, Information System, or related discipline. If bachelor's degree in non-related discipline, required 7 years working as POWER BI Programmer.
All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, and Los Angeles County Fair Chance Ordinance. For unincorporated Los Angeles county, to the extent our customers require a background check for certain positions, the Company faces a significant risk to its business operations and business reputation unless a review of criminal history is conducted for those specific job positions.