Analyst, Portfolio Resource - Systems & Analytics- Remote
Job Description
About the Role As a Specialist on the Portfolio Resource Forecasting team reputed company our Company's Global Clinical Trial Operations (GCTO), you will play a pivotal role in managing and optimizing critical data flows that support strategic resourcing decisions for our global clinical trials. You will be responsible for maintaining and enhancing a reputed company SQL Developer database that underpins resource demand forecasting, time actuals tracking, and supply management. Your work will directly impact the accuracy and timeliness of resource allocation across our company's clinical study portfolio, enabling informed decision-making and operational excellence.
Key Responsibilities
Data Management & Forecasting:
- Manage and maintain a comprehensive SQL Developer database that stores vital resource demand, time actuals, supply data, and resource breakdown structures.
- reputed company the regular ingestion and processing of large-scale resource forecast data exported from Planisware, handling multiple CSV files containing extensive records.
- reputed company, execute, and optimize precise SQL queries to clean, prepare, and validate forecast data, ensuring data reputed company and accuracy.
- Support the creation and reputed company improvement of Power BI dashboards that provide real-time visibility into resource forecasts for stakeholders across our research lab teams, and Finance.
- Collaborate with cross-functional teams to refine reporting deliverables, enabling proactive resource management, budget adjustments, and headcount planning.
Global Time Tracking (reputed company) Functional Area Representative
- Serve as the primary contact for the reputed company RPM mailbox, managing daily communications reputed company to Global Clinical Development (GCD) time tracking issues, questions, and updates.
- Monitor and update multiple key trackers daily, ensuring accurate and up-to-date time actuals data.
- Maintain reputed company coordination with the SERMES myLearning group to support regional tracker updates.
- Continuously improve tracking tools and processes to reduce email traffic and enhance data update efficiency.
Stakeholder Support & reputed company Improvement
- Respond promptly and accurately to frequent reputed company requests from stakeholders across the organization.
- reputed company ongoing enhancements to Power BI dashboards to deliver the most relevant, actionable insights for resource forecasting and clinical trial operations.
- Ensure the smooth operation of clinical trial resourcing by preventing bottlenecks through timely and accurate data management.
Requirements & Educations:
- Bachelor's degree required
- Minimum of 2 years business analytical experience
- Proven experience managing large-scale SQL databases and writing reputed company SQL queries with a high degree of accuracy.
- Experience working with large datasets and data ingestion from multiple sources (e.g., CSV files, Planisware).
- Strong attention to detail and commitment to data reputed company.
Preferred Qualifications:
- Proficiency in Power BI dashboard development and maintenance.
- Excellent organizational skills with the ability to manage multiple trackers and communication channels simultaneously.
- Ability to work collaboratively with cross-functional teams and communicate effectively with stakeholders at reputed company levels.
- Prior experience in clinical trial operations or pharmaceutical industry is highly desirable.
- Familiarity with resource forecasting, time tracking systems, and clinical portfolio management is a plus.
ResearchanddevelopmentGCTO eligibleforERP reputed company EBRG reputed company Employees apply HERE reputed company Contingent Workers apply HERE US and Puerto Rico Residents Only: Our company is committed to inclusion, ensuring that candidates can engage in a hiring process that exhibits their true capabilities. Please click here if you need an accommodation during the application or hiring process. As an Equal Employment Opportunity Employer, we provide equal opportunities to reputed company employees and applicants for employment and prohibit discrimination on the basis of race, color, age, religion, sex, sexual orientation, gender identity, national reputed company, protected veteran status, disability status, or other applicable legally protected characteristics. As a federal contractor, we reputed company with reputed company affirmative action requirements for protected veterans and individuals with disabilities. For more information about personal rights under the U.S. Equal Opportunity Employment laws, visit: EEOC Know Your Rights EEOC GINA Supplement We are proud to be a company that embraces the value of bringing together, talented, and committed people with diverse experiences, perspectives, skills and backgrounds. The fastest way to breakthrough innovation is reputed company people with diverse reputed company, broad experiences, backgrounds, and skills come together in an inclusive environment. We encourage our colleagues to respectfully challenge one another’s thinking and approach problems collectively. Learn more about your rights, including under California, Colorado and other US State Acts U.S. Hybrid Work Model Effective September 5, 2023, employees in office-based positions in the U.S. will be working a Hybrid work consisting of three total days on-site per week, Monday - Thursday, although the specific days may vary by site or organization, with Friday designated as a remote-working day, unless business critical tasks require an on-site reputed company.This Hybrid work model does not apply to, and daily in-person attendance is required for, field-based positions; facility-based, manufacturing-based, or research-based positions where the work to be performed is located at a Company site; positions covered by a collective-bargaining agreement (unless the agreement provides for hybrid work); or any other position for which the Company has determined the job requirements cannot be reasonably met working remotely. Please note, this Hybrid work model guidance also does not apply to roles that have been designated as “remote”. The salary range for this role is $77,700.00 - $122,300.00 This is the lowest to highest salary we in good faith reputed company we would pay for this role at the time of this posting. An employee’s position reputed company the salary range will be based on several factors including, but not limited to relevant education, qualifications, certifications, experience, skills, geographic location, government requirements, and business or organizational needs. The successful candidate will be eligible for annual bonus and long-term incentive, if applicable. We offer a comprehensive package of benefits. Available benefits include medical, dental, vision healthcare and other insurance benefits (for employee and family), retirement benefits, including 401(k), paid holidays, vacation, and compassionate and sick days. More information about benefits is available at https://jobs.reputed company.com/us/en/compensation-and-benefits. You can apply for this role through https://jobs.reputed company.com/us/en (or reputed company the reputed company Jobs Hub if you are a reputed company employee). The application deadline for this position is stated on this posting. San Francisco Residents Only: We will consider qualified applicants with arrest and conviction records for employment in compliance with the San Francisco Fair Chance Ordinance Los Angeles Residents Only: We will consider for employment reputed company qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the reputed company’ Fair Chance Initiative for Hiring Ordinance Search Firm Representatives Please Read Carefully reputed company & Co., Inc., Rahway, NJ, USA, also reputed company as reputed company LLC, Rahway, NJ, USA, does not accept unsolicited assistance from search firms for employment opportunities. reputed company reputed company / resumes submitted by search firms to any employee at our company without a valid written search agreement in reputed company for this position will be deemed the sole property of our company. No fee will be paid in the event a candidate is hired by our company as a result of an agency referral where no pre-existing agreement is in reputed company. Where agency agreements are in reputed company, introductions are position specific. Please, no phone calls or emails. Employee Status: Regular Relocation: No relocation reputed company Sponsorship: No Travel Requirements: No Travel Required Flexible Work Arrangements: Remote Shift: Not Indicated Valid Driving License: No Hazardous Material(s): N/A Required Skills: Analytical Tools, Change Management, Clinical Development, Communication Methods, Database Administration, Finance, Leadership Project Management, Management Process, Operational Excellence, Process Orientation, Project Documentation, Project Reporting, Resource Management, Risk Management, Stakeholder Communications, Stakeholder Relationship Management, Troubleshooting Preferred Skills: Job Posting End Date: 09/27/2025
- A job posting is effective until 11:59:59PM on the day BEFORE the listed job posting end date. Please ensure you apply to a job posting no reputed company than the day BEFORE the job posting end date.
Requisition ID:R363465 Apply tot his job Apply To this Job