IQVIA Business Intelligence Developer in Wayne, Pennsylvania
Job Profile Summary The Business Intelligence Developer is primarily responsible for development of analytical and financial business intelligence reporting for the Clinical Trial Payments organization. Primary duties will include delivering and improving our forecast and financial accrual reporting. Duties also include identifying areas of improvement and assisting with the development of new processes and analytics related to project delivery, quality measures, and associated reporting needs of clients and internal teams.
• Maintain Operational Requests & Enhancements
• Maintain User access for BI systems including MicroStrategy and SpotFire
• Contribute to architecture of BI databases
• Develop custom reports / build out reporting tools for the end users and other BI analysts
• Integrate new sources of data into the BI environment (Data Warehousing)
• Analyze/rebuild existing reports/processes for the long term
• Continue to develop and maintain next-generation forecasting
• Oversee the forecasting needs in SQL & Spotfire
• Deliver monthly forecasting report to external clients and make enhancements to the forecast model as needed
• Develop and implement continuous enhancements to the financial forecasting and accrual reporting as required
• Work with third parties to achieve business goals
• Analyze metrics and trends and make recommendations for process or systems improvements
• Design and develop measurements that demonstrate operational effectiveness and productivity
• Measure the return on investment of special projects and initiatives aimed at system and process enhancements
• Create ad hoc reports as needed
• Support the operations improvement initiatives as needed
• Other duties as assigned
MINIMUM REQUIRED EDUCATION AND EXPERIENCE
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Typically requires 2 - 3 years of prior relevant experience.
Requires intermediate level knowledge of principles, theories, and concepts of a job area, typically obtained through advanced education combined with experience.
Education Level Education Details Req Pref
Bachelor's Degree X
Additional Work Experience
Experience Details Req Pref
Experience in the pharmaceutical clinical trial, financial, or IT roles/industries X
Working knowledge of clinical trial process, ideally with specific knowledge on investigator contracts and essential site documents X
Experience in financial forecast and accrual reporting and analysis X
Experience with a business intelligence application such as MicroStrategy or Spotfire X
Experience supporting/developing in a MS SQL Server/Postgres SQL environment X
Experience working with database automation tools for MS SQL Server/Postgres SQL X
Skills and Abilities
Skill/Ability Description Proficiency
Demonstrates customer-oriented communication skills, responding to both internal and external clients promptly and within agreed upon timeframes
Requires strong attention to detail, excellent organizational, documentation and interpersonal skills
Willingness to work within a team-oriented environment as well as independently
Ability to handle multiple tasks to meet deadlines in a dynamic environment is essential
Strong PC skills (i.e. Microsoft Office) with an ability to understand, access and leverage technology alternatives
Advanced Excel skills required
Prior experience with MicroStrategy, SpotFire,SAP preferred
Prior experience with MS-SQL Server/Postgres SQL required.
• Proficiencies in MS SQL/Postgres SQL to include
• Designing database tables and structures.
• Creating views, functions and stored procedures.
• Writing optimized SQL queries for integration with other applications.
Experience working with one of the following database automation tools: SQL Server Integration Services, Talend for use with Postgres SQL.
Willingness to be flexible as the business requires
Standard ADA Settings
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions
Standard ADA Selection Office Environment
Physical Demand N/A Rarely Occasionally Frequently Constantly
Sit at a desk or table with some walking, standing, bending, stooping, or carrying of light objects. X
Use hands and fingers to handle and manipulate objects and/or operate equipment. X
The above information on this description has been designed to indicate the general nature and level of work performed. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, qualifications and working conditions required of employees assigned to this job. While this is intended to be an accurate reflection of the job, management reserves the right to revise the job at any time
At IQVIA, we believe in pushing the boundaries of human science and data science to make the biggest impact possible – to help our customers create a healthier world. The advanced analytics, technology solutions and contract research services we provide to the life sciences industry are made possible by our 70,000+ employees around the world who apply their insight, curiosity and intellectual courage every step of the way. Learn more at jobs.iqvia.com .
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other status protected by applicable law.
IQVIA, Inc. provides reasonable accommodations for applicants with disabilities. Applicants who require reasonable accommodation to submit an application for employment or otherwise participate in the application process should contact IQVIA’s Talent Acquisition team at email@example.com to arrange for such an accommodation.
IQVIA is a world leader in using data, technology, advanced analytics, and expertise to help customers drive healthcare – and human health – forward. Together with the companies we serve, we are enabling a more modern, more effective and more efficient healthcare system, and creating breakthrough solutions that transform business and patient outcomes.
To get there, it takes diverse skills and a curiosity to explore new possibilities. No matter your role, everyone at IQVIA, including our colleagues at Q² Solutions, contributes to our shared goal of improving human health. Thank you for your interest in growing your career with us.
EEO Minorities/Females/Protected Veterans/Disabled
- IQVIA Jobs