Embry-Riddle Aeronautical University is currently looking for an experienced Business Intelligence (BI) Systems Analyst to join the IT Team. Reporting to the Director of Business Intelligence, the BI Systems Analyst focuses on interfacing with key business stakeholders to deliver on the overall business intelligence strategy and identify requirements in relation to data integration, validation, and reconciliation considerations. This role involves developing elegant reporting solutions to help stakeholders fully understand their data, derive valuable insights and drive business change. Incumbent is responsible for the design, development and programing of systems to consolidate and analyze data from multiple internal and external sources. Much of this work will be using the Oracle Business Intelligence platform.
Responsibilities include the following:
Provide support for Oracle Business Intelligence and other business intelligence technologies supporting the University’s administrative and academic communities. Work closely with a wide network of customers and vendors to provide superior customer service. Collaborate with business users to understand requirements for data, reports, analyses, metadata, training, service levels, data quality, and performance. Translate these requirements into actionable data models and presentations using the appropriate technologies.
Perform troubleshooting to assist customers with any application systems problem solving activities. Implement processes for maintaining a stable environment. Analyze and identify software support solutions addressing service requests.
Communicate issues, critical problems and situations to appropriate managers, both customer and IT. Identify and resolve data, reporting and other application systems problems. Communicate solutions to customers in an effective and efficient manner. Ensure effective inter and intra team communications.
Participate and influence short/long term technology plans. Keep abreast of technology trends, especially those trends relating to the educational environment. Manage projects as necessary to keep applications up to date for the business users.
Minimum of 3 years developing BI applications, preferably Oracle Business Intelligence Systems (OBIEE)
Knowledge of data visualization tools (OBIEE, Oracle Data Visualizer, OAC)
Familiarity with data warehouse design, dimensional modeling and implementation
Fluency with concepts like star schema, fact, dimension
Proficiency with reports, dashboards and other analytical tool design/creation/maintenance
Experience with ETL design, development and processing
Strong analytical skills
Excellent verbal and written communication skills
Strong interpersonal skills
Proficient with SQL,PL/SQL
Debugging and trouble-shooting expertise
Good time management abilities
Experience designing conceptual, logical, and physical data models
Ability to support IT Core Values by focusing on improvements, believing in our team and partners throughout the university, learning from mistakes, being accountable for actions and showing determination, focus and tenacity
Oracle Business Intelligence (OBIEE)
Oracle Analytics Cloud (OAC)
Oracle SQL, PL/SQL
Dimensional Data Modeling
Data Warehouse Extract, Transact Load (ETL)
Academic/Higher Education Experience
Visualization expertise (preferably with wide range of toolsets)
Awareness of machine learning technologies and methodologies