BI Reporting Analyst

Overview:
Seeking a BI Reporting Analyst to support the reporting efforts during the migration of our submission planning capability to Veeva.

This role is focused on assessing and rebuilding submission planning reports to ensure continued visibility of planning insights post-transition.

The contractor will work closely with GRACS OPS RIIM, submission planning stakeholders, Veeva SMEs, and IT to deliver accurate reports.

Requirements:

• Proven experience delivering reporting services on medium-to-large projects; comfortable working in fast-paced, dynamic environments.
• Extensive hands-on experience with Power BI: DAX, incremental refresh/refresh scheduling, and row-level security.
• Veeva Reporting experience is preferred
• Strong SQL skills for data extraction, transformation, reconciliation and troubleshooting.
• Familiarity with data hub concepts and architectures (data lakes, data marts, integration hubs) and how they affect reporting.
• Demonstrated experience in customer-facing reporting roles: eliciting reporting requirements, presenting results, and iterating based on stakeholder feedback.
• Excellent verbal and written communication skills; ability to work effectively with both IT and the business.

• Assist with the inventory and documentation of current submission planning reports (purpose, owners, inputs, outputs, business rules, and consumers) and impact from Veeva transition.
• Drive the redevelopment of stakeholder planning reports from Veeva equivalent data.
• Deliver curated datasets to support stakeholder driven planning reports, as needed.
• Triage and resolve ad-hoc reporting requests and defects during migration and stabilization.
• Develop and apply expert level knowledge of the DORA data hub and other sources of reporting data.
• Conduct thorough validation of recreated and existing reports against business requirements.