Senior Business Intelligence/Analytics Developer
Location: Canonsburg, PA
The Business Intelligence and Analytics developer will be a member of the Data Management team and participate in the delivery of information and analytics solutions and platforms to key business stakeholders. The developer will provide expertise, development skills, best-practices, education, and end-user training to ANSYS staff.
RESPONSIBILITIESAnalyze and translate business reporting and analytic requirements to model the physical data into reporting, dashboard, and visualization tools, import database objects and establish relationships between data elements, and define the connections to data environments.Analyze and translate business requirements into business reports and dashboards based off the reporting layer model by creating filters, joins, key definitions, and renaming source data columns and tables.Develop the presentation, metadata layer, and access controls to enable business users to develop and use reports. Provide expertise to the business with reporting, analytics and dashboards and provide insights into data that will drive business growth and performance.Collaborate with business end users to educate and help them create their own self-service reports.Develop dashboards and reports as needed, using knowledge of dashboard and data visualization best practices. Document standard business intelligence and analytic processes, metadata, and data definitions for end users as well as Level 1 and 2 technical staff who can assist in analyzing and solving common user issues.Work closely with other Ansys departments, ensuring their data, reporting and analytics needs are met either by producing top quality reports, dashboards, and insights, or by training and providing them with what they need to produce self-service reports and dashboards.Work in a collaborative environment, work creatively and leverage innovation processes and techniques to deliver new insights.
MINIMUM QUALIFICATIONSBachelor's degree in computer science, engineering, Business, Information Systems, or a related technical field is required.4 years’ experience in dashboard and visualization development on database data.Ability to quantify and effectively identify user requirements for analytics and dashboardsExcellent interpersonal, communications, public speaking, and presentation skillsSenior level experience in data visualization tools (PowerBI (preferred), Tableau)Experienced in use of Oracle PL/SQL and Microsoft T-SQL to access database data.Experience working with cloud-based data repositories.Experience working with dimensional data in a Data Warehouse environment and an operational reporting environment.Experience in Excel using pivot tables, charts, functions, and other advanced spreadsheet techniques.
Learn more and apply below.