Power BI Developer

Planet Pharma; California; Sur place; USD 65 000 - 76 000; Plein temps

Résumé du poste

Planet Pharma in California seeks an experienced BI Programmer to design, develop and maintain clinical reports and dashboards using Power BI and related tools.

You will collaborate with reporting and clinical teams to gather requirements, ensure accuracy, and deliver compliant data deliverables across multiple studies. Strong SQL, data modeling, and communication skills are essential in a regulated environment.

Qualifications

• 5+ years developing reports and dashboards with BI tools.
• Experience with data modeling, transformation and visualization.
• Knowledge of SQL and writing moderately complex queries.
• 5+ years liaising with customers and documenting report requirements.
• Experience producing complex clinical study reports using Power BI.
• Adherence to SOPs and regulated environments.
• Strong organizational and communication skills.

Responsabilités

• Liaise with reporting and clinical teams to gather report/data needs and ensure clarity.
• Participate in requirement collection, design, development, testing and maintenance of clinical reports and data deliverables.
• Develop reports and dashboards using Power BI Desktop, MS Fabric and PBI Service.
• Liaise with the Report Development and Validation team to release deliverables per regulations.
• Liaise with Clinical IT/IT to address and resolve technical issues.

Connaissances

Power BI expertise

Data modeling

Data transformation

Data visualization

Customer liaison

Independent work

Teamwork

Problem solving

Formation

Bachelor's degree in CS/IS or related

7 years Power BI experience alternative

Outils

Power BI Desktop

Power BI Service

Power Query

Power Query M

DAX

SQL

Description du poste

• 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 requestors 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.

Target PR Range: 65-76

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 requestors 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.

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 bachelors degree in non-related discipline, required 7 years working as POWER BI Programmer.
• CO/NYC candidates might not be considered