Aliso Viejo, California
US$90000.00 - US$110000.00 per annum
19 days ago
BUSINESS INTELLIGENCE (BI) SPECIALIST
Are you interested in working in a Business Intelligence roll within the medical device industry Morson International currently has an exciting opportunity for a BI Specialist to join an industry award winning Medical device organization with amazing new offices in Aliso Viejo, CA
Job Description The IT Applications BI Specialist is responsible for complex data reporting and integration report and dashboard creation as well as providing support for both on-site and remote business users. Performs technical analysis and software configuration tasks required to fulfil business requirements.
Develop OBIEE Publisher reports and dashboards to meet end user requirements.
Analyze user requirements & business impact and document & design appropriate solutions.
Develop and test all deliverables and provide required validation documentation.
Proactively conduct ongoing data quality checks.
Refactor existing reports and dashboards to improve maintainability and usability.
Analyze system performance and work with the OBIEE system administration staff to resolve any issues.
Proactively collaborate and work with members of various business departments to ensure that the data meets their reporting requirements.
Responsible for day-to-day user support and troubleshoot issues in a timely manner.
Enforce and maintain application security in accordance with company policies and procedures.
Participate in departmental meetings and assigned projects or tasks by IT management.
Performs other duties and responsibilities as assigned.
Bachelor's Degree in computer science, Information Systems Management, Business or Engineering.
A minimum of three (3) years' experience with complex data reporting and integration.
Three (3) years' experience with Oracle and/or Microsoft SQL database development and support.
Three (3) years' experience with OBIEE utilizing Answers, Dashboards and Delivers.
Three (3) years' experience developing and maintaining ETL data integrations.
Strong report development experience including BI Publisher reports development.
Extensive experience in developing and testing drill across and drill-down configurations.
Maintaining documentation throughout the application life cycle.
Troubleshooting BI user issues and provide solutions in a timely manner.
Strong testing and validation experience.
Ability to collect and document reporting requirements for the following business functional areas: Sales, Supply Chain, Finance, Accounting.
Ability to work with the extended and remote TAH OBIEE and Hyperion team members in New Jersey.
Ability to communicate with both technical and non-technical teams to maintain transparency on work efforts and to ensure design and implementation is understood by all team participants.
Strong SQL query skills and experience with business report writing tools such as SQL Server Reporting Services (SSRS).
Strong analytical and problem-solving skills and the ability to find creative solutions to technical challenges by utilizing available toolsets.
Flexible in managing competing priorities and objectives.
Strong written/verbal communication and interpersonal skills.
Detail oriented and organized.