Business Intelligence Architect (Remote)

SUMMARY
The Enterprise Data & Analytics 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 and schemes and utilizing Snowflake, Power BI, dbt Labs and overall data engineering skills.

RESPONSIBILITIES

• Create a culture of data ownership and stewardship
• Improve 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

MINIMUM QUALIFICATIONS

• Bachelor's degree in Finance, Information Systems, Computer Science, Economics or equivalent technical field
• 8+ years of relevant work experience utilizing SQL and Power BI
• 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 including composite models, familiarity with Power Query, DAX calculations, drilldown features, and service/workspace security
• Advanced relational modeling skills with experience using star schema's and bridge tables
• Prior work experience within financial system reporting other cloud platform
• Strong communication and organizational skills
• Strong self-management skills

PREFERRED QUALIFICATIONS

• 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

CULTURE AND VALUES

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

WORKING AT ANSYS

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.

At Ansys, we know that changing the world takes vision, skill, and each other. We fuel new ideas, build relationships, and help each other realize our greatest potential. We are ONE Ansys. We operate on three key components: our commitments to stakeholders, our values that guide how we work together, and our actions to deliver results. As ONE Ansys, we are powering innovation that drives human advancement

Our Commitments:

• Amaze with innovative products and solutions
• Make our customers incredibly successful
• Act with integrity
• Ensure employees thrive and shareholders prosper

Our Values:

• Adaptability: Be open, welcome what's next
• Courage: Be courageous, move forward passionately
• Generosity: Be generous, share, listen, serve
• Authenticity: Be you, make us stronger

Our Actions:

• We commit to audacious goals
• We work seamlessly as a team
• We demonstrate mastery
• We deliver outstanding results

VALUES IN ACTION

Ansys is committed to powering the people who power human advancement. We believe in creating and nurturing a workplace that supports and welcomes people of all backgrounds; encouraging them to bring their talents and experience to a workplace where they are valued and can thrive.

Our culture is grounded in our four core values of adaptability, courage, generosity, and authenticity. Through our behaviors and actions, these values foster higher team performance and greater innovation for our customers.

We're proud to offer programs, available to all employees, to further impact innovation and business outcomes, such as employee networks and learning communities that inform solutions for our globally minded customer base.

WELCOME WHAT'S NEXT IN YOUR CAREER AT ANSYS

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 working with 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. 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 a lower cost. Ready to feel inspired? Check out some of our recent customer stories, here and here.

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.

CREATING A PLACE WE'RE PROUD TO BE
Ansys is an S&P 500 company and a member of the NASDAQ-100. We are proud to have been recognized for the following more recent awards, although our list goes on: Newsweek's Most Loved Workplace globally and in the U.S., Gold Stevie Award Winner, America's Most Responsible Companies, Fast Company World Changing Ideas, Great Place to Work Certified (China, Greece, France, India, Japan, Korea, Spain, Sweden, Taiwan, and U.K.).

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