Business Intelligence Analyst
3 days ago
Pittsburgh
Job DescriptionSalary: $90,000 - $110,000 Fred Rogers Productions is seeking a Business Intelligence Analyst to help design, build, and maintain data systems that empower data-informed decisions.The ideal candidate will have strong analytical and technical skills, the ability to translate data into actionable insights, and an eagerness to learn about how data informs the work of a mission-driven media organization. This role will report to the Director of Business Intelligence and collaborate across departments Finance, Production, Fundraising, Marketing, Licensing, and Learning & Education to maintain existing business intelligence tools and assist in developing new reporting systems and visualizations that support strategic planning, performance analysis, and operational efficiency. Key Responsibilities: • Maintain, refresh, and enhance existing dashboards and reports., • Assist in analyzing viewership, audience engagement, and performance data across all media distribution platforms., • Assist in the design and implementation of new data pipelines, data warehousing, and business intelligence systems that improve data accuracy and accessibility., • Collaborate with internal stakeholders to define reporting needs and deliver timely, relevant analyses., • Support the development of tools to track and measure FRPs impact across marketing, licensing, and educational initiatives., • Work with the Director of Business Intelligence to automate and streamline recurring reports for Finance, Production, Licensing, and Marketing., • Assist in the modeling and analysis of financial, operational, and audience data to help identify trends, forecast outcomes, and inform strategy., • Participate in the ongoing evolution of FRPs Business Intelligence infrastructure and contribute to the creation of new KPIs and data visualizations that align with organizational goals., • Learn and apply data from multiple sourcesincluding QuickBooks, FileMaker, Google Analytics, The Insights Family, Luminate, and Tubularto support cross-departmental projects. Qualifications: • Kindness, thoughtfulness, and curiosity., • Bachelors degree in Business, Analytics, Computer Science, or a related field., • 35 years of experience in data analytics, business intelligence, or a related field., • Proficiency in Power BI, PowerQuery, Solver, Excel, and PowerPoint., • Experience with data modeling, data visualization, and data warehousing., • Strong analytical and problem-solving skills with the ability to interpret complex data and present insights clearly., • Excellent communication and collaboration skills, with the ability to work effectively across teams and departments., • Highly organized, self-motivated, and able to manage multiple priorities. Preferred Qualifications: • Familiarity with SQL, APIs, or data automation processes., • Experience with Google Analytics, The Insights Family, Luminate, Tubular, or YouTube Analytics platforms., • Interest in childrens media, education, or nonprofit work. About Fred Rogers Productions: Fred Rogers founded the company in 1971 as the non-profit producer of Mister Rogers Neighborhood for PBS. In the years that followed, it not only created hundreds of episodes of this much-loved program but also extended Freds values and approach to other efforts in promoting childrens social, emotional, and behavioral health and supporting parents, caregivers, teachers, and other professionals in their work with children. Fred Rogers Productions continues to build on Freds legacy in innovative ways through a wide variety of media and engage new generations of children and families with his timeless wisdom. The companys highly-rated, award-winning childrens series include Daniel Tigers Neighborhood, Donkey Hodie, Almas Way, Peg + Cat, Odd Squad, and Through the Woods. At Fred Rogers Productions, we believe kids come first, now and always. We connect with them through shows that are fun, relatable, and put their social and emotional learning front and center. Thats how weve earned the trust of parents, caregivers, and teachers. We bring our one-of-a-kind expertise in early childhood development to partnerships with talented creators, writers, illustrators, animators, and producers. Together, we create shows that foster a natural enthusiasm for learning and that make kids smile while they learn big life lessons. And we are always exploring how to make the most of new ways for kids to watch and play. For more information, visit or follow us on Twitter, Facebook, LinkedIn, and Instagram. EEO Statement: Fred Rogers Productions is an equal opportunity employer. All employment decisions shall be based on merit, qualifications, and competence. Employment practices shall not be influenced or affected by a persons race, color, genetics, religion, sex, national origin, age, sexual orientation, gender identity or expression, marital status, disability, military status, or any other characteristic protected by applicable law. This policy governs all aspects of employment, including, without limitation, recruiting, hiring, compensation, benefits, promotion, assignment, and dismissal. It is also our policy to provide an environment free of unlawful harassment of any kind, including, without limitation, sexual, racial, age-related, disability-related, or ethnic background-related. Non-Discrimination Statement: We embrace our differences and encourage employees to highlight differences in their work products and our workplace. We believe that everyone has the right to work in an empathetic environment that promotes equal employment opportunities. FRP strictly prohibits unlawful discrimination based on race, color, genetics, religion, sex, national origin, age, sexual orientation, gender identity or expression, marital status, disability, or military status in any of our operations. The job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee. Duties, responsibilities, and activities may be subject to change.