StPaulRecruiter Since 2001
the smart solution for St. Paul jobs

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

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Other Engineering Jobs

Electronic Security Technician
Description: Do you want to be a part of a fun, growing company that offers a company paid vehicle, fuel card, iPhone, iPad, and a sign-on bonus of 2000 - 4000, depending on experience General Security Services (more...)
Company: General Security Services Corporation
Location: Minneapolis
Posted on: 04/12/2021

E&C Engineer - IV
Description: Position: E C Engineer - IVLocation: Minneapolis, MNDuration: 12 Months br Description/Comment: ul li Responsible for the design, modeling, development and testing of a machine, structure or system. (more...)
Location: Minneapolis
Posted on: 04/12/2021

91C Utilities Equipment Repairer - Mechanic and Maintenance
Description: If you're interested in a maintenance career, join the Army National Guard as a Utilities Equipment Repairer and help keep operations running smoothly on and off the battlefield. Your primary responsibility (more...)
Company: Army National Guard
Location: Arlington
Posted on: 04/12/2021

Packaging Engineer II
Description: Job Summary: The primary purpose of this job is to perform work which involves conventional engineering practice, but may include a variety of complex features. Ensures Integer's internal and external (more...)
Company: Integer Holdings Corporation
Location: Chaska
Posted on: 04/12/2021

Design Engineer
Description: Description:Growing, fast paced, and highly technical environment. Help the advancement and support of new and innovative products and technologyDesign reliability and performanceSolidworks - create drawings, (more...)
Company: Aerotek
Location: Minneapolis
Posted on: 04/12/2021

Field Technician
Description: Join the Heroes at TAK Communications 3,000 Sign-On Bonus for Experienced Technicians How do you become our customer's hero, every day ul li Dazzle customers with a smile, energetic personality (more...)
Company: TAK Communications
Location: Elk River
Posted on: 04/12/2021

Service Technician, Appliance Repair
Description: Req/Job ID: 999974BREmploying Entity: Transform SR LLCEmployment Category: Regular, Full-timeJob Function: Repair/InstallationStore ID: 28027: IH-Minneapolis MNA sign on bonus may apply to qualified candidates (more...)
Company: Sears Home Services
Location: Belle Plaine
Posted on: 04/12/2021

Quality Engineer
Description: KEY ACCOUNTABILITIES: 1.Support the Spectrum Plastics Group, MN SPG, MN safety program and its goal of zero accidents.2.Ensure operational processes and quality requirements meet customer expectations (more...)
Company: Spectrum Plastics Group
Location: Minneapolis
Posted on: 04/12/2021

Quality Engineer
Description: ul li Job Tag: li Posted: April 06,2021 br SkyWater is partnering with a client north of Minneapolis to find their next Quality Engineer This person will be responsible
Company: SkyWater Search Partners
Location: Minneapolis
Posted on: 04/12/2021

12Y Geospatial Engineer
Description: You can play an important part in disaster relief missions as a Geospatial Engineer for the Army National Guard. In this role, you will extract and supply geographic data that supports military operations (more...)
Company: Army National Guard
Location: Rosemount
Posted on: 04/12/2021

Log In or Create An Account

Get the latest Minnesota jobs by following @recnetMN on Twitter!

St. Paul RSS job feeds