"Senior Technical Developer, GFO GTS Business Intelligence"

"Assists with analyzing complex business problems to be solved with automated systems.As part of a software project implementation team, provides technical expertise in identifying, evaluating and developing systems and procedures that are cost effective and meet user needs. Configures system settings and options; plans and executes unit, integration and acceptance testing; and creates specifications for systems to meet business specifications. Designs details of automated systems. May provide consultation to users in the area of automated systems. May lead cross-functional linked teams to address business or systems issues.Job duties are varied and complex; independent judgment needed. May have project lead role. Prefer 5 years relevant experience and BA/BS degree.*This is a remote/office based position which may be performed anywhere in the United States except for within the state of Colorado.**Oracle is an Affirmative Action-Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability, protected veterans status, age, or any other characteristic protected by law.*Team IntroductionGlobal Finance Operations (GFO) provides services to support Oracles sales transactions from opportunity through invoice collection including sales compensation administration, across all lines of business and countries globally, while continuously improving the employee and customer experience.Our team, GFO Technical Solutions (GTS) provides expertise, guidance and flexible solutions to meet the changing needs of the organization and supports global projects and initiatives. The GTS-BI team designs, develops and maintains reporting and data analysis platform for the GFO organization, participates in strategic BI projects, which drive key corporate initiatives by providing timely and valuable insights into business operations, and we cooperate closely with Oracle IT organization to implement latest technologies to enhance and extend our BI solutions portfolio.Our team is global and we do have members in several countries United States, India, Romania, and Czech Republic.Role ResponsibilitiesThis role provides BI development support to the GFO organization by enabling advanced custom reporting and data analysis solutions that meet specific business needs. This includes working with the business to understand their requirements, working with our IT partners to understand existing systems and data sources, identifying and documenting solutions and development on data extraction, transformation, presentation and analysis in various tools and languages.This role participates on technical projects with focus on improvements, extensions, upgrades of our cloud-based platforms and tools and the implementation and integration of new technologies and tools as required.This role provides support to existing solutions by managing bug tickets, trouble-shooting and resolving system issues and managing enhancement tickets.Also, this role is expected to lead small and medium-sized projects from initial requirements through design, from development to deployment as well as to coordinate our teams efforts with business customers and Oracle IT teams to deliver expected results.Qualifications/Skills RequiredTechnical education (Bachelors/Masters in Computer Science) or equivalent experience4 years of experience with Relational Databases (Oracle), Data Warehouses (DW), BI middleware and BI presentation tools:* Knowledge of SQL/PLSQL, Relational Data Modeling, Dimensional Modeling and Star Schema designo Complex SQL analytical queries and queries optimizationo Complete Subject Area design based on business requirements and available data sources analysiso Advanced DW concepts like slowly moving dimension, performance optimization, Big Data, real time data, o Basic Oracle DB administration skills* Experience with Oracle Analytics Cloud and/or OBIEE 12o End-to-end development of reporting solutionso Extensive experience in design and development of Oracle BI Repository (RPD) solution, implementing well designed metadata layers, experience with advances techniques likemultiple source systems, data segmentation etc.o Analysis, Dashboards and Agents design and best practiceso Data Visualization projectso Authentication and Authorization Object level and Data level securityo Performance Tuning and Optimizationo Experience with BI Administration and CI/CD in context of BI tools* Data Extraction, Transformation & Load tools and methodologieso Knowledge of Oracle DB metadata (Data Dictionary) and access methods (OCI, JDBC, schemas, roles, )o Knowledge of ETL solutions preferably ODI 12 (Oracle Data Integrator) knowledge of its architecture (interfaces, scenarios, packages, agents, repository) and ability to design, implement and schedule data loadso Ability to write complex transformations in PL/SQL, Java, Optional technical skills:* Good knowledge of Cloud Concepts and Autonomous Data Warehouse (ADW) is an added advantage* Other Data Integration technologies like Oracle Golden Gate (GG), data streaming etc. are plus* Basic knowledge/awareness of other BI tools (MS Power BI, Tableu, Alteryx, ) is a plus* Experience with programing languages like Python or Java for data manipulation and analysis is an advantage* Experience with Oracle APEX for quick database driven applications development is a plus* Machine Learning, Data Mining techniques exposure is an advantageStrong personal, communication and project skills:* Dedication, teamwork, drive for results and commitment to quality are essential* A strong customer-oriented focus and experience in working directly with end users are required* Independent and responsible, capable of working efficiently and achieving results in a virtual and global team and escalating issues when appropriate* Good written, oral and interpersonal communication skills (English)* Ability to partner with the business team to understand their requirements, propose creative solutions and implement the solutions* Effective in building relationships with Corporate IT and other business partners* Demonstrated ability to analyze current processes and recommend process improvements* Strong planning, organization, problem-solving and analytical skills* Proficiency with agile development cycle methodologies and CI/CD technologies* Good project management skills with proven ability to complete projects and achieve results with desired quality and timelines* Willingness to invest extra effort during busy periods like quarter end or project deadlines**Job:** **Information Technology***Organization:** **Oracle***Title:** *Senior Technical Developer, GFO GTS Business Intelligence***Location:** *United States***Requisition ID:** *21000GBS*"