Senior Analyst

Carnegie Museums - Advancement & Community Engagement, 4400 Forbes Avenue, Pittsburgh, Pennsylvania, United States of America Req #741
Tuesday, February 1, 2022
There's no cultural organization in the world quite like Carnegie Museums of Pittsburgh. With a legacy of discovery and outreach dating back to 1895, today we are a family of four diverse, dynamic museums; Carnegie Museum of Art, Carnegie Museum of Natural History, Carnegie Science Center, and The Andy Warhol Museum. We're committed to being inclusive, both onsite and online, and to exploring with our audiences the big ideas and issues of our time. Carnegie Museums of Pittsburgh is interested in candidates who, through their experience and collaborations, will contribute to diversity and excellence of the Carnegie Museums community.

The CMP COVID-19 Employee Vaccine Policy requires that all employees provide proof of COVID vaccination or if not fully vaccinated, must provide proof of negative COVID-19 testing on a weekly basis.

The Senior Analyst (Power BI) builds scalable data models, cleans and transforms data, and deploys data visualizations, reports, and dashboards that provide key insights to the organization for fundraising success. The Senior Analyst is a data storyteller that conducts descriptive, exploratory, and predictive data analyses.

EDUCATION AND EXPERIENCE:

  • Bachelor’s degree in a quantitative field of study, such as Data Science, Analytics, Mathematics, Statistics, Research, Computer Science, Information Systems, Engineering, Economics
  • 3 years of experience developing Microsoft Power BI dashboards and data models, utilizing DAX, Power Query, Pipelines, Paginated Reports, and/or DAX Studio required
  • Microsoft Certified Data Analyst (Exam-DA 100) certification a plus
  • 1 year of experience with SQL preferred.

KNOWLEDGE, SKILLS, ABILITIES: 

  • Strong analytical skills.
  • Microsoft Power BI Dashboards: design and implementation.
  • SQL experience preferred.
  • Understanding of ETL/Data Warehousing preferred.
  • Proficiency in a statistical programming language (R/Python) a plus.
  • Experience with Raiser’s Edge or Crystal Reports a plus.
  • Comfortable working independently and in a team environment to execute assigned deliverables in a prompt and efficient manner.
  • Excellent communication skills; diplomacy and persuasive abilities.
  • Excellent written and verbal communication skills.

 PHYSICAL REQUIREMENTS:

Work is primarily sedentary in nature; no special demands are required.

PRINCIPAL ACCOUNTABILITIES:

  • Extracts, transforms, loads, validates, models, analyzes, reports, and visualizes data.
  • Conducts descriptive, exploratory, and predictive data analyses.
  • Creates Power BI deployment models and dashboards, connecting data from SQL Server databases.
  • Conducts load testing on Power BI dashboards. Troubleshooting performance bottlenecks.
  • Establishes KPIs to measure the effectiveness of the museum’s fundraising operations
  • Evaluates historical fundraising performance and forecast future performance.
  • Develops and directs the implementation of strategies to substantially improve data processing efficiencies.
  • In partnership with leadership, identifies what ifs and improvement opportunities and subsequently perform analysis to quantify and validate.
  • Other duties as assigned.
The following PA Act 153 clearances, or proof of application of clearances, are required beginning employment and as a condition of continued employment: Pennsylvania Child Abuse History Clearance Pennsylvania State Police Criminal Record Check FBI Fingerprint Criminal Background Check Obtaining the required clearances is completed as part of the new hire process.

Carnegie Museums is an Equal Opportunity-Affirmative Action Employer – Minorities / Females / Veterans / Individuals with Disabilities / Sexual Orientation / Gender Identity

The above job description reflects the essential functions and qualifications for the position identified, and shall not be construed as a detailed description of all the work requirements that may be inherent in the position. The job description does not constitute an employment contract and does not alter the at-will relationship between CMP and the employee.   

*GUIDANCE ON ESSENTIAL FUNCTIONS:   The Americans with Disabilities Act (“ADA”) requires employers to consider and accommodate qualified individuals with disabilities.  An individual is qualified if he or she can perform the essential functions of a job with or without reasonable accommodation. An essential job function is any task that is a fundamental part of the job.  When considering essentiality, one must focus upon whether the function is essential to this particular job and not to the department as a whole. Some additional guidance on essential functions follows below.  Please note that the following guidelines are non-exhaustive.  If you have any questions or need additional guidance, please contact Human Resources. A. Is the function required to be performed on a regular basis? If the function is rarely performed, it may not be essential. B. Is the function highly specialized? Is the incumbent hired for his/her expertise or ability to perform the function?  The need for special expertise is an indication of an essential function. C. Does the position exist, at least in part, to perform the function?  If so, the function is more likely to be essential. D. How much time is spent performing the function and how often?  Note that even functions performed 10% of the time could be essential if they are required on a regular basis. E. Would elimination of the function fundamentally alter the job?  If so, the function is more likely to be essential. F. What are the consequences of not requiring the incumbent to perform the function? If they are significant, the function is more likely to be essential.  G. Are there a limited number of employees among whom the performance of the function could be distributed if the incumbent could not perform it?  If so, it is more likely to be essential.

Other details

  • Pay Type Salary
This posting is inactive.
Location on Google Maps
  • Carnegie Museums - Advancement & Community Engagement, 4400 Forbes Avenue, Pittsburgh, Pennsylvania, United States of America