Developer Transparency BI BO

REMOTE OPPORTUNITY!!!!!!!!

Client: Technology GCC for Global Biotech Company

We are seeking an experienced BI Developer to support the development and maintenance of Aggregate Spend Reporting solutions. This role requires strong expertise in Oracle SQL for data extraction and reporting, as well as significant experience with SAP Business Objects for developing reports. Power BI experience is preferred. The position ensures compliance with global transparency regulations such as the Sunshine Act and EFPIA. Knowledge of materialized views for performance optimization and efficient data management is also required. Responsibilities: • Write and optimize SQL queries to extract data from multiple sources for aggregate spend reporting. • Utilize materialized views for efficient data aggregation and reporting, improving performance for large datasets. • Develop and maintain BI reports using SAP Business Objects to provide actionable insights into healthcare spend data. • Leverage Power BI to create and deliver interactive, visual reports and dashboards (preferred experience). • Integrate Veeva Network data into aggregate spend reporting, ensuring consistency and accuracy with other data sources. • Collaborate with stakeholders to gather reporting requirements and deliver BI solutions that meet compliance and transparency standards. • Ensure the accuracy, integrity, and consistency of aggregate spend reports through data validation and reconciliation. • Optimize BI reports for performance, particularly when handling large datasets. • Troubleshoot and resolve issues related to SQL queries, materialized views, BI reports, and data discrepancies. • Ensure compliance with regulations such as the Sunshine Act, EFPIA, and other global standards for aggregate spend reporting. • Provide ongoing maintenance and support for BI reports, dashboards, materialized views, and data integrations.

• 4+ years of experience in Oracle SQL development, including experience writing complex queries, optimizing performance, and working with materialized views. • Extensive experience with SAP Business Objects for creating and managing BI reports. • Experience with Power BI (preferred) for creating interactive reports and visualizations. • Familiarity with Veeva Network data and its integration into aggregate spend reporting solutions. • Experience with data extraction, transformation, and loading (ETL) processes for BI reporting. • Knowledge of aggregate spend reporting and healthcare transparency regulations (e.g., Sunshine Act, EFPIA). • Strong problem-solving skills with the ability to troubleshoot and optimize SQL queries, materialized views, and BI reports.