Advanced Business Intelligence Analyst

About the position

The position is responsible for the maintenance and support of company Enterprise Business Intelligence (BI) tools including Oracle Business Intelligence Enterprise Edition (OBIEE/OAS), Oracle Business Intelligence Applications (OBIA), Oracle Data Integrator (ODI), Incorta Analytics, and Tableau in a 24x7 production environment on On-Prem and Cloud based Infrastructure. The role serves as a liaison between the BI developers, business users, and Enterprise Infrastructure teams to develop and deploy BI solutions that meet business needs. The individual will be accountable for BI applications monitoring, performance tuning, capacity, and utilization, managing system stability, High Availability, as well as identifying, designing, and implementing solutions for identified improvements. The position also involves guiding best practices and approaches to design and implement effective analytics solutions, performing data analysis, producing data samples/prototypes, and producing ad-hoc reports. The candidate will obtain and analyze data from multiple sources, including Oracle and data warehouses, to enable agile data analysis and data preparation for front-end BI implementation.

Responsibilities

• Responsible for the maintenance and support of company Enterprise Business Intelligence (BI) tools.
• Serves as a liaison between the BI developers, business users, and Enterprise Infrastructure teams.
• Accountable for BI applications monitoring, performance tuning, capacity, and utilization.
• Guides best practices and approaches to design and implement effective analytics solutions.
• Performs post-project reviews with the project team from IM&T and IT.
• Performs data analysis, produces data samples/prototypes, and produces ad-hoc reports.
• Obtains and analyzes data by accessing multiple sources, including Oracle and data warehouses.
• Identifies and implements opportunities to utilize advanced data analytics.
• Develops a deep understanding of specific areas of the business and key metrics.
• Partners and collaborates with Business Analysts to provide input to project timelines, scope, and risks.
• Evaluates and plans activities to implement automation of manual data extracts.
• Utilizes LEAN and Kaizen concepts to identify and implement data-driven continuous improvement initiatives.
• Implements, maintains, and enhances ETL solutions fulfilling data quality, availability, and performance requirements.
• Develops methods for integrating different data sources.
• Analyzes and interprets all complex data on the target system.
• Creates and maintains technical documentation including specifications, data flows, and data dictionaries.
• Maintains and implements robust data governance methodologies.
• Performs tests and validates all data flows and prepares all ETL processes.
• Supports design and development of dimensional and normalized data models.
• Writes and codes logical and physical database descriptions.

Requirements

• Must have a Master's degree in Computer Science, Computer Information Systems, Business Analytics, or a related field.
• Must have 8 years of experience in positions performing business intelligence analysis.
• Must have 3 years of experience developing and implementing successful project plans.
• Utilizing knowledge of the various services offered by OCI including computing, storage, networking, database, analytics, and machine learning.
• Utilizing understanding of OCI's pricing models including pay-as-you-go, subscription, and reserved instances.
• Utilizing knowledge of cost optimization strategies and best practices for minimizing expenses.
• Utilizing knowledge of cloud cost management tools and platforms.
• Utilizing architected Oracle Cloud Data Lake solutions.
• Utilizing designed and implemented data processing pipelines using Oracle Cloud Data Flow.
• Developing ETL workflows with Oracle Data Integrator.
• Implementing data governance policies and establishing metadata management practices using Oracle Data Catalog.
• Utilizing knowledge of OCI Data Science, Python, and Spark.
• Utilizing knowledge of Oracle Cloud Infrastructure IAM policies.
• Installation and Configuration of Oracle Business Intelligence Applications on the Linux platform.
• Utilizing hands-on experience in upgrading Oracle Business Intelligence Applications.
• Utilizing experience in upgrade to latest Oracle Business Intelligence Application version OBIA 11.1.1.10.x.
• Utilizing knowledge in Enterprise Resource Planning application in Financial, Procurement & Spend, Project, and Supply Chain modules.
• Utilizing hands-on experience in Oracle Business Intelligence Object level and data level security implementation.
• Utilizing experience with SQL/PL SQL, with experience in performance tuning SQL queries.

Nice-to-haves

• Utilizing knowledge of creating forecast related reports by using Machine Learning algorithms in Oracle Analytics Server Data Visualization tool.

Benefits

• Position may be eligible to work remotely but is based out of and reports to Scientific Games offices in Alpharetta, GA.
• Must be available to travel to Alpharetta, GA regularly for meetings and reviews.