Business Intelligence Architect

RESPONSIBILITIES

• Create a culture of data ownership and stewardship
• Improve data quality and hierarchical data structures
• Develop new data transformation pipelines using SQL, dbt and jinja in a consistent data modeling architecture
• Recognize and streamline manual processes by applying BI approaches using cloud-based technology
• Design relational models in Power BI reports to support the growing requirements of the business
• Connect domain 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 ELT efforts to increase analytical capability and business features
• Promote self-service data analytics
• 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 Information Systems, Computer Science, Finance, Economics or equivalent technical field
• Strong communication skills to gather, translate and organize business requirements
• 6+ years of relevant work experience leveraging SQL in complex analytical workflows or a DBMS to create DML and DDL scripts
• 3+ years of experience with Snowflake or another cloud-based data warehouse
• 3+ years supporting a business facing domain with consistent reporting deliverables
• 6+ years of relevant work experience with the Microsoft Office Suite including advanced excel knowledge and SharePoint Online exposure
• Advanced relational modeling skills with experience building data marts, star schemas and bridge tables
• Advanced SQL skills utilizing CTEs and window functions in analytical workflows
• Experience with dbt cloud or similar SDLC processes for data
• Familiarity with an ERP data stack (Oracle, SAP)
• Familiarity with an enterprise CRM data stack (Salesforce, Dynamics)
• 6+ years experience with Power BI covering composite models, Power Query transformations, DAX calculations, drilldown features, and service security
• Strong self-management skills

PREFERRED QUALIFICATIONS

• Prior work experience deploying version-controlled data pipelines (Git) with CI/CD workflows
• 2+ years experience with DataVault architecture
• Knowledge of various cloud data lake architectures (AWS S3, Azure ADLSG2, Google Coud Storage)
• 2+ years experience delivering data features or preprocessed datasets for AI/ML workflows
• Experience optimizing BI reports for server-side execution
• Prior work experience composing conceptual and logical data models with graphical tools
• Intimate knowledge of the DAX language for Power BI including a deep understanding of filter context
• Experience deploying custom BI analytical applications - PowerApps, PowerOn, Streamlit, Azure Functions, Shiny apps

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