Share this Job

Manager, Business Intelligence FP&A - Remote

Apply now »

Date: Jun 18, 2021

Location: Canonsburg, PA, US, 15317 Miami, FL, US, 33126-9998 Jersey City, NJ, US, 07302 Charlotte, NC, US, 28217 Baltimore, MD, US, 21229-9998 Atlanta, GA, US, 30304-9998 Evanston, IL, US, 60201 Dallas, TX, US, 75260 Austin, TX, US, 78746

Company: Ansys

Ansys is the global leader in engineering simulation, helping the world's most innovative companies deliver radically better products to their customers. By offering the best and broadest portfolio of engineering simulation software, Ansys helps companies solve the most complex design challenges and engineer products limited only by imagination.


The Business Intelligence Team within the FP&A organization is looking for a BI Manager to join their newly created Power BI Reporting Team. The chosen candidate will play a pivotal role in the expansion of business capability in the channel sales space. Furthermore, the individual will also 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 engineering skills.



  • Develop new data pipelines using SQL and data warehousing skills to support the channel space
  • Recognize and streamline manual processes by applying modern cloud-based ELT/ETL solutions
  • Formulate relational models and reports using Power BI to support the growing requirements of the business
  • Implement MVP principles to refine and design solutions in an agile fashion
  • Enhance existing ETL efforts to increase analytical capability and data frequency
  • Help us build a world-class BI organization by developing, standardizing, maintaining and driving continuous improvement of Business Intelligence processes


  • Bachelor's degree in Finance, Information Systems, or Computer Science
  • 3-5 years of relevant work experience utilizing SQL in a DBMS to create DML and DDL scripts
  • Familiarity with Snowflake or another cloud-based data warehouse
  • 3-5 years of relevant work experience with the Microsoft Office Suite including advanced excel knowledge and SharePoint Online exposure
  • Familiarity with an enterprise ERP data stack (Oracle, SAP)
  • Intermediate-Advanced knowledge of Power BI including composite models, familiarity with Power Query, DAX calculations, drilldown features, and service/workspace security
  • Strong communication and organizational skills
  • Strong self-management skills



  • Knowledge of indirect and channel sales business models in a SaaS setting
  • Advanced SQL skills utilizing CTEs and window functions in analytical workflows
  • Prior work experience deploying version-controlled data pipelines
  • Prior work experience with Salesforce SOQL or another cloud CRM platform
  • Experience using cloud orchestration tools with CI/CD, DBT is a plus
  • Intimate knowledge of the DAX language for Power BI including a deep understanding of filter context
  • Advanced relational modeling skills with experience using star schema’s and bridge tables


Culture and values are incredibly important to Ansys. They inform us of who we are, of how we act. Values aren't posters hanging on a wall or about trite or glib slogans. They aren't about rules and regulations. They can't just be handed down the organization. They are shared beliefs – guideposts that we all follow when we're facing a challenge or a decision. Our values tell us how we live our lives; how we approach our jobs. Our values are crucial for fostering a culture of winning for our company:

  • Customer focus
  • Results and Accountability
  • Innovation
  • Transparency and Integrity
  • Mastery
  • Inclusiveness
  • Sense of urgency
  • Collaboration and Teamwork

At Ansys, you will find yourself among the sharpest minds and most visionary of leaders, collectively aiming to change the world with innovative technology and remarkable solutions.  With the prestigious reputation in servicing well-known, world-class companies, standards at Ansys are high, met by those willing to rise to the occasion and meet those challenges head-on.  Because at Ansys, it’s about the learning, the discovery and the collaboration.  It’s about the “what’s next” as much as the “mission accomplished”.  It’s about the melding of disciplined intellect with strategic direction and results that have, can and will impact real people in real ways, forged within a working environment built on respect, autonomy and ethics.
At Ansys, you will find yourself among those eager to drive the world towards the next best thing with hands planted firmly on the wheel.
Our team is passionate about pushing the limits of world-class simulation technology so our customers can turn their design concepts into successful, innovative products faster and at lower cost.  As a measure of our success in attaining these goals, Ansys has been recognized as one of the world's most innovative companies by prestigious publications such as Bloomberg Businessweek and FORTUNE magazines.
Ansys is an S&P 500 company and a component of the NASDAQ-100.
For more information, please visit us at www.ansys.com
Ansys is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other protected characteristics.
Ansys does not accept unsolicited referrals for vacancies, and any unsolicited referral will become the property of Ansys.  Upon hire, no fee will be owed to the agency, person, or entity.

Nearest Major Market: Pittsburgh