Business Intelligence Architect - Remote

Location: Canonsburg, PA (15317)
Company: ANSYS
Industry: IT
Job Type: Full Time
Posted: 3 days ago
Ansys is the global leader in engineering simulation. We empower the world's most innovative companies to deliver transformational products to their customers. By offering the best and broadest portfolio of engineering simulation software solutions, we help our customers solve the most complex design challenges and engineer products limited only by imagination. Whether you are a software developer, product engineer, sales team member, or part of our corporate team, at Ansys we know that by embracing what makes us each unique, we become collectively better.

The Finance organization is looking for a Business Intelligence Architect to play a pivotal role in the expansion of business capability by providing curated datasets and technical solutions to Finance business executives.Furthermore, the individual will be utilizing the latest cloud solutions to deliver standardized, ubiquitous models across the organization. Ultimately spending their time crafting value by creating data models, schemas, and analytical services utilizing SQL, Power BI, and overall data engineering skills.

  • Create a culture of finance data ownership and stewardship
  • Improve finance data quality and hierarchical structures
  • Develop new data pipelines using SQL and data warehousing skills
  • Recognize and streamline manual processes by applying modern data models in cloud-based solutions
  • Formulate relational models to support the growing requirements of the business
  • Connects finance master data to other Ansys-wide data models and initiatives
  • Implement MVP principles to refine and design solutions in an agile fashion
  • Establish robust and dynamic security (RLS/OLS) on Power BI datasets in line with business requirements
  • Enhance existing ETL efforts to increase analytical capability and data frequency
  • Promote self-service data analysis
  • 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, Computer Science, Economics or equivalent technical field
  • 8+ 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
  • 8+ 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 includingcomposite models, familiarity with Power Query, DAX calculations, drilldown features, and service/workspace security
  • Advanced relational modeling skills with experience using star schemas and bridge tables
  • Prior work experience with a financial services cloud platform
  • Strong communication and organizational skills
  • Strong self-management skills

  • Advanced SQL skills utilizing CTEs and window functions in analytical workflows
  • Prior work experience deploying version-controlled data pipelines
  • 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
  • Deployed Power BI writeback solutions - PowerApps, PowerOn, Azure Functions

At Ansys, our diverse, collaborative teams give us the strength and insight to solve the world's most challenging engineering problems. Our ONE Ansys culture has at its core:
  • 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 leaders across the globe. Collectively we strive to change the world with innovative technology and transformational solutions. With a 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. 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." And it's about the melding of disciplined intellect with strategic direction and results that have, can and do impact real people in real ways. All this is 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, empowering our customers to 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 member of the NASDAQ-100. We are proud to have been recognized for the following awards: Bay Area Best Places to Work, a Pillar World Awards Gold Winner, Fast Company Best Places to Work for Innovators, a Gold Stevie Award for Great Employers, the FORTUNE Future 50, a DCA Silver Winner, an R&D100 Finalist, a 20% by 2020 Women on Boards winner, a 2020 Pittsburgh Tech 50 - finalist, and America's Most Responsible Companies.

For more information, please visit us at

We are committed to creating a culture of inclusion and belonging where everyone thrives as ONE Ansys team.

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

Web Reference : AJF/335135575-202
Posted Date : Sat, 25 Jun 2022

Please note, to apply for this position you will complete an application form on another website provided by or on behalf of ANSYS. Any external website and application process is not under the control or responsibility of IT JobServe

Search for more IT Jobs