Sr Data Warehouse Engineer

Company: Oracle
Location: Saint Paul
Posted on: April 8, 2021

Job Description:

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* **Organization:** **Oracle* **Title:** *Sr Data Warehouse Engineer* **Location:** *United States* **Requisition ID:** *210007T6*

Keywords: Oracle, St. Paul , Sr Data Warehouse Engineer, Engineering , Saint Paul, Minnesota