Senior Business Intelligence Analyst – IT Department

Overview

Pharmaceutical Research and Manufacturers of America (PhRMA) is seeking a positive and engaging Senior Business Intelligence Analyst (Director) for the IT Department to define, develop, and implement data driven solutions in support of operational objectives and efficiency improvements. This role requires technical skills, analytical aptitude, reporting capabilities, attention to detail, intellectual curiosity, and the ability to communicate effectively.

The Senior Business Intelligence Analyst will:

• Create and maintain models, reports, and dashboards based on a requirements analysis process and through design sessions with stakeholders.
• Identify opportunities to improve existing reporting and data processing workflows and design and develop solutions.
• Act as a data steward, compiling and maintaining data sources, cataloguing, and ensuring data quality.
• Advocate for the use of Power BI and Fabric as BI tools, providing guidance to users. 
• Collaboration: Work with cross-functional teams to understand their data needs and assist them in making data-driven decisions.
• Create visual representations of data findings through charts, graphs, and dashboards to communicate insights effectively to stakeholders.
• Convey analytical results and support decision-making processes within the organization.
• Data Analysis: Utilize statistical tools and techniques to explore and analyze data, identifying patterns, trends, and relationships.
• Perform other duties as assigned.

Professional Experience / Requirements

• Bachelor’s degree in a related field.
• 6+ years of experience with Power BI/Fabric.
• Solid experience in every aspect of Power BI.
• Hands-on experience writing DAX and M queries and creating measures to simplify the use of existing models.
• Ability to “tell a story” through report design, visual elements, and data.
• Deep understanding of ETL best practices from multiple data stores, including Synapse, SQL, Dataverse, and open APIs, and experience in creating new data models that are clear and reusable.
• Experience managing SQL databases in Azure. 
• Knowledge of corporate accounting principles and experience in reporting on accounting data. 
• Experience developing and supporting applications built in Power Apps.

Key Success Factors
 PhRMA seeks a proactive, confident and action-oriented individual passionate about data analysis and visualization. The preferred candidate will be an organized, detail-oriented, self-starter and able to communicate effectively with technical and non-technical colleagues. The Senior Business Intelligence Analyst is a problem solver and enjoys assisting others. They will understand the big picture, consume and rationalize details, think critically, and reason analytically to deliver customer-centric solutions. Key success factors for this role include a strong sense of teamwork and collaborative focus.

Demonstrated consensus building, decision-making, and interpersonal skills are essential.  Accordingly, the successful candidate should be adaptable, able to reprioritize and shift gears quickly, comfortable in a high-pressure environment and be politically savvy, diplomatic, responsive, and mature.  

Potential Salary

$110,500-151,900 per annum. Salary is commensurate with experience and other compensable factors. 

Who we are  
 The Pharmaceutical Research and Manufacturers of America (PhRMA) represents the country’s leading innovative biopharmaceutical research companies, which are laser focused on developing innovative medicines that transform lives and create a healthier world. Together, we are fighting for solutions to ensure patients can access and afford medicines that prevent, treat and cure disease. Over the last decade, PhRMA member companies have invested more than $800 billion in the search for new treatments and cures, and they support nearly five million jobs in the United States.  

Connect with PhRMA
For information on how innovative medicines save lives, please visit:
www.PhRMA.org
www.Innovation.org
www.MAT.org
www.Facebook.com/PhRMA
www.Twitter.com/PhRMA    

What we offer
  In addition to a highly competitive salary and bonus program, various opportunities for reward and recognition and a platform of extensive benefits, PhRMA is committed to the development and overall wellbeing of our team members.  We offer traditional (medical, dental, vision, flexible spending, life, AD&D, LTD, STD, LTC) and enhanced benefits such as parental leave, a well-being program, on-site fitness facility, back-up care, an employee assistance program, and pre-tax commuting benefits.  We also offer a robust 401k plan with employer contributions upon the first day of hire and immediate vesting, a generous paid time off plan, -ten paid holidays (plus inauguration day), half day Fridays preceding holidays, half day Fridays in the summer months and a paid winter break. As an organization, we work together in the office on Mondays through Thursdays and remotely on Fridays. We also work remotely in August.

We are committed to the growth and development of our team members and offer many learning opportunities including an integrated onboarding program, best-in-class leadership programming, tuition reimbursement, industry on-site and off-site training, and other management/professional development programs.  Corporate social responsibility is also important to us at PhRMA. Our team members participate in community service activities, fundraising drives and charitable athletic events.  

We are committed to supporting our family of professionals at PhRMA and strive to create programs that help our team members manage the challenges of balancing a fast-paced career with their own personal goals.

Equal Opportunity Employer 

PhRMA provides equal employment opportunities to all applicants without regard to race, color, religion, national origin, sex, age, marital status, personal appearance, sexual orientation, gender identity or expression, family responsibilities, genetic information, disability, matriculation, political affiliation or veteran status in accordance with applicable federal, state and local laws governing nondiscrimination in employment. 

The job description contains an overview of the activities and duties for this role. Responsibilities may change and new ones may be assigned at any time.