"Senior Data Analyst - Computing Services"

Senior Data Analyst - Computing Services

Company:
Carnegie Mellon University

Job Location:
Pittsburgh, 15213

Category:
Software Engineer/Programmer

Type:
Full-Time

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!

The Computing Services central IT division provides services that have a strategic impact on university goals. We make service decisions based on interaction and valuable input from colleagues engaged in the education, research, and administration efforts of the university. We seek a Senior Data Analyst focusing on Power BI and cross-functional systems. This role will be integral to supporting the university's data initiatives, with the mission of eliminating data silos and developing data products that enable the strategic use of institutional data for informed decision-making and growth. We focus on dataset curation, data pipeline optimization, and system integrations, championing data governance and quality. In this role, you will work closely with technology teams and campus partners to execute and deliver data products, 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, experience working with Snowflake or other RDBMS systems, and a background in cross-functional data. The Senior Data Analyst will support and enhance data products, collaborating with business partners, cross-functional teams, and departments to understand business processes and workflows. They will develop and optimize analytics and reporting solutions, implement and manage Power BI solutions, and support the implementation of integrations. 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:

• Partner with multi-functional teams to document and design data products to meet enterprise decision-making needs. Create and manage data products (inclusive but not limited to data sets, semantic models, and dashboards) in accordance with specifications and CMU's data guidelines and strategy.
• Support the usage of enterprise data technologies (ie, Snowflake, Power BI, DBT). Provide technical and programming support to business partners in the construction, implementation, and delivery of data products.
• Facilitate requirements capturing within various domains to develop comprehensive business and requirements documents.
• Lead all aspects of the creation of functional and technical specifications, changes to requirements, and assess the impact of changes based on business requirements.
• Develop a deep understanding of our data sources and structures; assist in integrating them into Snowflake, Power BI, AI agents and with internal and external systems.
• Participate in and define test scenarios, plans, strategies, and the creation of test scripts for data products.
• Lead the process for identifying and gathering appropriate business requirements to build robust data product solutions that address analytics and reporting needs.
• Other duties as assigned.

Ideal candidates will demonstrate:

• Business process analysis skills, particularly within cross-functional domains.
• 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.
• Experience in Data Modeling.
• Understanding of various systems and processes, preferably Workday, Oracle Financials, and other higher education systems.
• Experience with DBT is a plus.
• Experience with data pipeline optimization.

Adaptability, excellence, and passion are vital qualities within Carnegie Mellon University. We are in search of a team member who can 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.

Qualifications:

• Bachelor's Degree required.
• 5-8 years of relevant work experience required.
• A combination of education and relevant experience from which comparable knowledge is demonstrated may be considered.

Requirements:

• Successful background check

Additional Information:

• Work Posture: This position operates on a hybrid schedule, with an on-campus/in office presence 3 days a week.
• Sponsorship: Applicants for this position must be currently legally authorized to work for CMU in the United States. CMU will not sponsor or take over sponsorship of an employment visa for this opportunity. Carnegie Mellon is not a qualifying employer for the STEM OPT benefit: only the 12-month OPT may be used to work at Carnegie Mellon

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

Benefits eligible employees enjoy a wide array of benefits including comprehensive medical, prescription, dental, and vision insurance as well as a generous retirement savings program with employer contributions. Unlock your potential with tuition benefits, take well-deserved breaks with ample paid time off and observed holidays, and rest easy with life and accidental death and disability insurance.

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

For a comprehensive overview of the benefits available, explore our Benefits page.

At Carnegie Mellon, we value the whole package when extending offers of employment. Beyond credentials, we evaluate the role and responsibilities, your valuable work experience, and the knowledge gained through education and training. We appreciate your unique skills and the 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
Pittsburgh, PA

Job Function
Data Analysis

Position Type
Staff - Regular

Full Time/Part time
Full time

Pay Basis
Salary