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!
Other Engineering JobsElectronic 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...) Company: NET2SOURCE CONSULTING LIMITED 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 |