Oracle Sr Data Warehouse Engineer in Lehi, Utah
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.
Sr Data Warehouse Engineer
Focused on new infrastructure to scale Oracle Data Cloud, metadata attribution and granular margin database.
As a member of Financial Business Infrastructure team in the Oracle Data Cloud business operations division, one of the fastest growing and most strategic businesses at Oracle, you will be responsible for processes and analyses for a highly complex and granular financial data set. Your main responsibilities will be to work with a team of Finance & Operations experts to process, maintain and improve our financial metadata, architect and own a business-wide infrastructure to track and understand data margins across the Data Cloud business, integrate disparate data sets from legacy financial systems of previously acquired companies, improve existing business processes, and automate financial operations. In this position, you will play a key role in creating the underlying components of our company-wide Business Intelligence efforts, operational automation, and business strategy.
Combining PLSQL coding, basic scripting skills and financial data structure design with finance operations, you will work closely with many functions within the Oracle Data Cloud, including sales teams, operational execution teams, and technical teams, and will play a key role in helping Oracle Data Cloud operate more efficiently and effectively. This function is equal parts business automation and financial analysis.
How you’ll be successful at ODC.
Day-to-day you will:
Architect, Build, Manage and streamline business intelligence data warehouses and financial metadata capture systems.
Build and refine data flow and ETL processes
Performing data cleansing and enhancing data quality
Define technical requirements to enhance upstream processes that are relevant to the datawarehouse
Conversion of current T-SQL scripts to oracle PL/SQL
Design and implement an efficient database schema that performs well on ADW
Troubleshoot performance issues related to code and implement design recommendations
Design and implement the conversion from SQL server to ADW , OAC and ODI on the OCI framework
Design and architect the analytical Datawarehouse on ADW to support the reporting and data visualization on OAC as well as the ETL processes on the ODI toolsets
Coordinate with business analysts and internal customers to develop business requirement and specification documents
Strong commitment to sound development practices, including test and deploy with version control (GIT)
Produce and maintain strong documentation
Support the financial month-end close process where needed.
What you bring to the table.
Here’s a summary of the skills you’ll need for this position:
Experience in a business intelligence role with data warehouse design and dimensional modelling
Strong database understanding is a must with knowledge of SQL, PL/SQL , Oracle database design and datawarehouse modeling principles
Strong understanding of Alteryx or ODI or similar Enterprise class ETL tools like informatica or DataStage
Experience with OCI, ADW, OAC and ODI is highly desirable for this position. however, experience in equivalent technologies with the ability to pick up the desired skills through training is also acceptable
Experience of consulting or interviewing with customers (either internal or external) to uncover business and system requirements
Proven track record of being able to compile complex analyses relating to financial metrics
Capacity to multi-task and prioritize effectively, working extremely well under pressure
Demonstrated ability to self-motivate, establish strong working relationships, utilize resources within cross-functional matrixed teams, and be flexible within a fast-paced and changing environment job
Strong stakeholder management
Track record of developing, owning, and continuously improving complex business processes
Detail oriented with the ability to maintain big picture perspective
Bachelor's Degree in related subject
US based position
Job: *Information Technology
Title: Sr Data Warehouse Engineer
Location: United States
Requisition ID: 210007T6