Senior IT Business Systems Analyst - Computing Services

Carnegie Mellon University is a private, global research university that stands among the world’s most renowned educational institutions. With groundbreaking brain science, path-breaking performances, creative start-ups, big data, big ambitions, hands-on learning, and a whole lot of robots, CMU doesn’t imagine the future, we invent it. If you’re passionate about joining a community that challenges the curious to deliver work that matters, your journey starts here! 

We seek a Senior IT Business Systems Analyst focusing on PowerBI and Financial Systems.  This role will be integral to supporting the university’s data initiatives, with the mission of eliminating data silos and developing services that enable the strategic use of institutional data for informed decision-making and growth. We focus on dataset curation, data pipeline optimization, and dashboard development, championing data governance and quality. In this role, you will work closely with technology teams and campus partners to execute and deliver data-related projects, fostering an environment where university-wide cross-functional teams thrive through proactive engagement and collaboration.

The ideal candidate will have substantial expertise in Power BI reporting, including the ability to implement and manage Power BI solutions, experience working with Snowflake or other RDBMS systems, and a background in financial data. The Senior IT Business Systems Analyst will support and enhance existing Finance Data Products, collaborating with business partners, financial teams, and cross-functional teams to understand business processes and financial workflows. They will develop and optimize financial analytics and reporting solutions, implementing and managing Power BI solutions. Success in this position will hinge on the candidate's ability to collaborate effectively and communicate business and technology requirements that further the growth of our data community.

Your core responsibilities will include:

• Drive the implementation and effective use of The Financial Data Warehouse system (built on PowerBI and Snowflake), ensuring that it aligns with the financial goals and reporting requirements of the organization, and enhancing it for the future.

• Develop advanced Power BI dashboards and reports, optimizing for performance and usability. Leverage Power BI to visualize complex financial data and KPIs.

• Facilitate requirements capturing within the financial domain to develop a comprehensive business and financial requirements document.

• Lead all aspects of the creation of functional and technical specifications, changes to requirements, and assess the impact of changes based on business and financial requirements.

• Provide production support by supplying artifacts and the corresponding understanding (data model, data maps, knowledge base articles, etc.) and educating the support team when applicable.

• Develop a deep understanding of our financial data sources and structures; assist in integrating them into both Snowflake and Power BI.

• Act as a liaison for the financial domain between IT application teams, financial teams, and business units.

• Participate in and define test scenarios, plans, strategies, and creation of test scripts for financial systems and reporting solutions.

• Lead the process for identifying and gathering appropriate business and financial requirements to build robust solutions that address both financial analytics and reporting needs.

• Coordinate the response to audit-related requests and issues.

• Other duties as assigned.

Flexibility, excellence, and passion are vital qualities within Computing Services. Inclusion, collaboration, and cultural sensitivity are valued competencies at CMU. Therefore, we are in search of a team member who is able to effectively interact with a varied population of internal and external partners at a high level of integrity. We are looking for someone who shares our values and who will support the mission of the university through their work.

Inclusion and cultural sensitivity are valued competencies at CMU. Therefore, we are in search of a team member who can effectively interact with a varied population of diverse audiences. We are looking for someone who shares our values and who will support the mission of the university through their work.

This is a great opportunity for someone to work in a creative, dedicated, and driven team, in a collaborative environment committed to technical innovation, inclusion, and work-life balance.

You must demonstrate:

• Expertise in Power BI reporting, including report creation, data visualization, and performance optimization.

• Expertise in Power BI management including Apps management, live connections, and leveraging APIs.

• Business process analysis skills, particularly within the financial domain.

• Project management skills.

• Excellent customer service skills.

• Ability to prioritize work and handle multiple tasks simultaneously.

• Understanding of structured and unstructured data.

• Proficiency in SQL query language.

• Experience in DAX query language.

• Understanding of financial systems and processes, preferably Oracle Financials.

• Experience with DBT is a plus.

Qualifications:

• Bachelor’s degree in Finance, Business, Computer Science, or a related field, or an equivalent combination of education and/or experience.

• 8-10 years of experience in financial systems and gathering business and technical requirements, with a focus on financial analytics and reporting.

• Advanced experience in Power BI reporting and analytics is essential.

Requirements:

• Successful background check

Joining the CMU team opens the door to an array of exceptional benefits, available to all full-time Carnegie Mellon University employees. Experience the full spectrum of advantages, from comprehensive medical, prescription, dental, and vision insurance to enticing retirement savings programs. Unlock your potential with tuition benefits, and take well-deserved breaks with generous paid time off and holidays. Rest easy knowing you're covered by life and accidental death and disability insurance. For a comprehensive overview of the benefits awaiting you, explore: https://www.cmu.edu/jobs/benefits-at-a-glance.

At Carnegie Mellon, we value the whole package when extending offers of employment. Beyond just credentials, we consider the role & responsibilities, your invaluable work experience, and the knowledge gained through education and training. We acknowledge and appreciate your unique key skills and the diverse perspectives you bring. Our commitment to fostering an inclusive work environment means we also account for geographic differentials. Your journey with us is about more than just a job; it is about finding the perfect fit for your professional growth and personal aspirations.

Are you interested in this exciting opportunity?! Apply today!

Joining the CMU team opens the door to an array of exceptional benefits available to eligible employees.

Those employees who are benefits eligible have the opportunity to experience the full spectrum of advantages from comprehensive medical, prescription, dental, and vision insurance to an enticing retirement savings program offering a generous employer contribution. You can also unlock your potential with tuition benefits and take well-deserved breaks with ample paid time off and observed holidays. Finally, rest easy knowing you are covered by life and accidental death and disability insurance. 

Other perks include a free Pittsburgh Regional Transit bus pass, our Family Concierge Team to help navigate childcare needs, fitness center access, and so much more!

For a comprehensive overview of the benefits that may be awaiting you, explore our Benefits page.

At Carnegie Mellon, we value the whole package when extending offers of employment. Beyond just credentials, we consider the role and responsibilities, your invaluable work experience, and the knowledge gained through education and training. We acknowledge and appreciate your unique skills and the diverse perspective you bring. Your journey with us is about more than just a job; it’s about finding the perfect fit for your professional growth and personal aspirations.

Are you interested in an exciting opportunity with an exceptional organization?! Apply today!

Location

Job Function

Position Type

Full Time/Part time

Pay Basis

More Information: