Financial Data Analyst - Finance Division

Carnegie Mellon University; Pittsburgh (Allegheny County); On-site; USD 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a Financial Data Analyst to enhance data analytics capabilities. This role involves executing projects that improve financial data collection, analysis, and visualization. Collaborating with multi-functional teams, you'll create dashboards and ensure data quality, leveraging tools like Tableau and SQL. The position offers a hybrid work environment, allowing for flexibility while fostering collaboration. Join a vibrant community dedicated to innovation and excellence, where your contributions will directly impact decision-making and operational success.

Benefits

Comprehensive Medical Insurance

Dental Insurance

Vision Insurance

Retirement Savings Program

Tuition Benefits

Paid Time Off

Holidays

Fitness Center Access

Free Pittsburgh Regional Transit Pass

Family Concierge Team

Qualifications

• 5-8 years of relevant work experience in higher education or industry.
• Experience with data visualization and dashboard design preferred.

Responsibilities

• Partner with teams to document and design data sets and dashboards.
• Ensure data accuracy and manage data sets in accordance with guidelines.

Skills

Data Visualization

SQL

Data Analysis

ETL

Data Quality

Education

Bachelor's Degree

Tools

Tableau

PowerBI

Informatica

Snowflake

Job description

Carnegie Mellon University is seeking a driven and motivated Financial Data Analyst to join our vibrant and growing data analytics community. In this position, you'll be responsible for executing a variety of projects aimed at enhancing our ability to collect, analyze, and visualize financial data and build data narratives to inform business and operational decisions. Your responsibilities will include financial data quality review, data organization and reporting, financial forecasting, development of financial data models and visualization.

Reporting directly to the Associate Vice President for University Budget and Financial Planning, you will work closely with leaders of the Finance Division and will have a dotted reporting line to the Assistant Vice Provost for Institutional Research and Analysis. In this reporting environment, you will have access to professional resources both inside the Finance Division and Institutional Research and Analysis.

A member of the data analytics collaborative of the University, you will also have opportunities to work across functional areas to develop data analytics products to connect finance data with data assets from other areas to enhance our ability to understand university operations in a more connected and holistic fashion. You will work closely with the Data Analytics Collaborative to implement the University's Data and Analytics Strategies. This role is a preferred hybrid role with two days in the office a week required to ensure valuable face time with the team.

Core responsibilities include:

• Partner with multi-functional teams to document and design data sets and dashboards to meet enterprise decision-making needs, primarily but not exclusively in Finance areas
• Create and manage data sets and dashboards in accordance with specifications and CMU's data guidelines and strategy
• Ensure data is accurate, consistent, valid, and reliable for consumption through the use of Data Quality and Data Sharing tools (Informatica, Snowflake)
• Work with Finance, Institutional Effectiveness and Planning, and Enterprise Information Systems colleagues to leverage data on the enterprise data sharing platform, reducing data silos and increasing cross-department data sharing
• Communicate new or emerging enterprise data elements to Data Governance for analysis and inclusion in CMU's data dictionary
• Develop data analysis and visualization by leveraging enterprise dashboard tools (Tableau, PowerBI)
• Provide technical and programming support to business partners related to the construction, implementation, delivery, and/or other related activities to data sets and dashboards as needed.
• Collaborate with and provide feedback to other data professionals through critical initiatives for the continuous improvement of the data-driven culture at CMU
• Respond to and resolves customer support requests

Flexibility, excellence, and passion are vital qualities within the Finance Division. Inclusion, collaboration, and cultural sensitivity are valued competencies at CMU. Your abilities to manage multiple projects in a fast-paced environment, to collaborate effectively with colleagues across functional areas, and to use advanced data analysis tools to develop data visualization and dashboards are highly valued.

Qualifications:

• Bachelor's degree required
• 5-8 years of relevant work experience in higher education and/or the industry required
• 2-3 years of Data Visualization and Dashboard/Report Design experience strongly preferred (i.e. Tableau, PowerBI, or other data visualization platforms)
• One or two years of Data Analytics experience with hands-on experience with SQL, ETL or ELT, and data quality, prep and cleansing preferred
• Knowledge of Data Analytic and Visualization concepts, standard processes, and development methodology
• Knowledge of relational databases and data models
• A combination of education and relevant experience from which comparable knowledge is demonstrated may be considered.
  

Requirements:

• Successful background check

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 insuranceto 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 beawaiting 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

Pittsburgh, PA

Job Function

Financial Planning, Analysis, Accounting and Reporting

Position Type

Staff - Regular

Full Time/Part time

Full time

Pay Basis

Salary

More Information:

• Please visit "Why Carnegie Mellon" to learn more about becoming part of an institution inspiring innovations that change the world.

• Click here to view a listing of employee benefits

• Carnegie Mellon University is an Equal Opportunity Employer/Disability/Veteran.

• Statement of Assurance