Senior Financial Analyst

ANSYS

Date: 09/03/2020

Location: Pittsburgh

The chosen candidate will play a pivotal role in the creation and development of various dashboards and reports needed to enhance business capability.  Furthermore, the individual will work with other departments both within and outside of FP&A to enhance manual processes into automated solutions using SQL, Power BI, and overall data mining skills.

 

RESPONSIBILITIES

  • Develop reports and dashboards using Power BI to support the requirements of the business
  • Work with users to gather requirements and focus on MVP principles to refine and design
  • Optimize the balance between schema on read vs write using SQL and data warehousing skills
  • Implement and deliver standard and ad hoc reporting, factoring in data source frequency
  • Help us build a world-class BI organization by developing, standardizing, maintaining and driving continuous improvement of Business Intelligence processes
  •  

    MINIMUM QUALIFICATIONS

  • Bachelor's degree in Finance, Information Systems, or Computer Science
  • Intermediate-Advanced knowledge of Power BI includingcomposite models, familiarity with Power Query, DAX calculations, drilldown features, and the service
  • Basic SQL skills using join and filter clauses. Differentiating between inner vs. left vs. right join
  • 3-5 years of relevant work experience with the Microsoft Office Suite including advanced excel knowledge to support various business functions
  • Strong communication skills
  • Excellent organizational skills

  • Apply below.