No longer accepting applications
Datawarehouse Analyst III
ExperisHouston, Texas, US17 days ago
Job type
- Full-time
Job descriptionDevelop Oracle PL / SQL applications. Create Oracle PL / SQL packages, stored procedures, and functions. Create database objects like tables, views, triggers, types, synonyms based on requirements. Create new applications or enhance existing applications to produce commissions reports. Work with Manager / IT Lead to understand requirements, create technical design, analyze source tables and relationships, adhere to consistent coding / SVN standards, and provide daily status updates. Work with the Commissions analyst to understand the existing calculations process for each workstream and build, test, and UAT according to their expectations. Use Oracle Analytical functions, MERGE statements, WITH clause, Partitioning, Job logging, File handling, External tables, and Exception handling in the Oracle PL / SQL code. Optimize code by following performance tuning techniques and coding standards established within the team. Create and test Unix scripts to transfer reports from Unix server to Windows share using sFTP server Perform Unit testing and end to end System testing of the Oracle PL / SQL application. Prior to UAT submission test and compare the reports to Production calc. reports and identify and fix discrepancies. Use analytics skills to troubleshoot and resolve problems quickly Use SVN to maintain all database object scripts / source code. Follow versioning standards established by the team. Have code reviewed with IT lead prior to moving the code to QA environment Create ControlM / Redwood job documents, create Change requests, and work with ControlM / Redwood to get them created and scheduled. Use ServiceNow ticketing system for opening, handling, and closing tickets and change requests. Follow SOX procedures for code deployment. Perform production support. Monitor batch processes daily / weekly / monthly and resolve job failures as soon as possible to meet established SLAs. Work with ControlM / Redwood group on re-run / re-start instructions. Be willing to perform this off hours during weekdays and weekends. Fulfill ad-hoc requests for data pull, table updates or minor enhancements. Work effectively in a team environment. Develop strong working relationship with team members, Manager, Commissions team analysts, DBA team, Project Manager, and other IT groups. Independently work on tasks without the need for step by step Supervision Communicate progress or issues clearly either verbally or through email. Escalate issues or delays that would impact deadline as early in the process as possible. Must be local to Houston or TX and be willing to be in the office Monday, Tuesday, and Thursday of every week 15+ years of experience in Software development 12+ years of strong development experience using Oracle PL / SQL including experience using features like Analytical functions, merge statements, WITH clause, oracle partitioning, job logging, exception handling, performance tuning 12+ years of experience in Oracle 12c or 19c 5+ years of experience in a Data Warehouse environment Strong Analytical skills Troubleshooting skills Strong Team Player
Job Title : Datawarehouse Analyst III
- Must be local to Houston or TX and be willing to be in the office Monday, Tuesday, and Thursday of every week
Design, develop, test, maintain, and support batch applications using Oracle PL / SQL for Retail Commissions and Amortization.
Essential Duties / Responsibilities :
Education :
Bachelor’s degree in computer science, software engineering or relevant business discipline from an accredited four-year college or university.
Experience :
Additional skills : Flexibility, Dedication, Consistency, Integrity, and Enthusiasm a must.
Create a job alert for this search
Analyst Iii • Houston, Texas, US
Related jobs
You will be a key influencer within the NRG Data & AI team driving ideation through to delivery and implementation of solutions.
You will be expected to work closely with business stakeholders ensur...Show moreLast updated: 30+ days ago
Datawarehouse Analyst III- Oracle PL / SQL Location : Houston, TX - (Onsite Monday, Tuesday, and Thursday of every week) Long Term Description : Design, develop, test, maintain, and support batch ap...Show moreLast updated: 30+ days ago
It's fun to work in a company where people truly BELIEVE in what they're doing!.We're committed to bringing passion and customer focus to the business.
The Credit Analyst III provides analytical and...Show moreLast updated: 11 days ago
SAP idoc experience (preferred).Nominations and accrual VBDs (preferred).The Commercial Logistics Business Improvement (BI) team manages system interfaces, data integrity, data analytics and optimi...Show moreLast updated: 2 days ago
Calpine Corporation is America's largest generator of electricity from natural gas and geothermal resources with operations in competitive power markets.
Its fleet of 77 power plants in operation re...Show moreLast updated: 17 days ago Design and develop complex algorithms using PL / SQL ensuring data integrity and security.Perform in-depth data analysis and resolve data-related issues efficiently.
Research and document data process...Show moreLast updated: 22 hours ago 
It's fun to work in a company where people truly BELIEVE in what they're doing!.We're committed to bringing passion and customer focus to the business.
The Credit Analyst III provides analytical and...Show moreLast updated: 3 days ago
Position : Business Analyst III- Commercial Logistics, BI Analyst.Position Type : W2 Contract - No Benefits.Position Location : Houston, TX.
Job Posting Title : Business Analyst III.P66 Job Title : Comme...Show moreLast updated: 1 day ago
A company is looking for a Data Analyst III to lead complex data conversion projects in the insurance technology space.Key Responsibilities Lead full-cycle data conversion projects as a technical...Show moreLast updated: 7 days ago
Our client is seeking a Financial Analyst III to join their team.As a Financial Analyst III, you will be part of the finance department supporting various teams.
The ideal candidate will have strong...Show moreLast updated: 3 days ago
Williams is committed to creating a diverse and inclusive environment and is proud to be an equal opportunity employer.All qualified applicants will receive consideration for employment without reg...Show moreLast updated: 30+ days ago
This opportunity is Hybrid / Onsite and may be based at any of the following Shift4 locations : Silver Spring, MD / Tampa, FL / Center Valley, PA / Las Vegas, NV (Remote may be possible in certain s...Show moreLast updated: 30+ days ago
Under the direction of the Staff Services Manager I the Crime Analyst (CA) III in the Record Challenge Section within Record Quality Services Program works independently, or with other staff, handl...Show moreLast updated: 30+ days ago
Treasury Analyst III Job Summary.The Treasury Analyst III is responsible for cash operations, forecasting, and financial analysis to support treasury activities.
This role involves working with inte...Show moreLast updated: 30+ days ago
Offered Position : Business Analyst III.Support senior management by managing metrics reporting and performing data mining and big data analysis to provide strategic advice on business forecast mode...Show moreLast updated: 27 days ago
We are seeking a Financial Analyst III for a senior-level, full-time opportunity that can become temp-to-hire for the right individual.
This position is ideal for a sharp, motivated candidate who th...Show moreLast updated: 6 days ago
Automation QA w / Kafka Testing (Must).Need QA options with highlighted skills : .API Testing using RestAssured / Selenium.
UI / API's test data and results.PostgreSQL DB - convert it into the dashboard - ...Show moreLast updated: 17 hours ago
Our client is seeking an Accounts Payable to work within their facilities located in Houston, TX for a 12-month contract.
Assist with invoice processing & support as needed.Process TeamConnect eInvo...Show moreLast updated: 30+ days ago
IT Business Analyst III
Omni InclusiveHouston, TX, USFull-time
Remote - Datawarehouse Analyst III- Oracle PL / SQL
Intone NetworksRemote, Work from Home, United States of AmericaRemote
Part-time
Credit Analyst III
Simmons bankHouston, TXFull-time
Houston - Business Analyst III
LanceSoftHouston, TX, USTemporary
Risk Analyst III
CalpineHouston, TX, USFull-time
- New!
DATA WAREHOUSE ANALYST III
ExperisHouston, Texas, USFull-time
Credit Analyst III
Simmons BankHouston, TX, USFull-time
Business Analyst III- Commercial Logistics, BI Analyst- 7672
Interactive CAD Services, Inc.Houston, TX, USFull-time
Data Analyst III
VirtualVocationsHouston, Texas, United StatesFull-time
Financial Analyst III - Hybrid
Manpower FinanceHouston, TX, USFull-time
Credit Analyst III, Sr
Williams CompaniesHouston, TX, USFull-time
Technical Business Analyst III
Shift4USFull-time
CRIME ANALYST III
Department of JusticeSacramento County, USFull-time +2
Treasury Analyst III
Core ResourcesHouston, TX, United StatesFull-time
Business Analyst III - AMZ9084990
Amazon.com Services LLC - A57Houston, Texas, USAFull-time
- Promoted
Financial Analyst III
Ambassador Personnel, Inc. [Bainbridge, GA]Houston, TX, USFull-time
- New!
Business Analyst III - UALJP00013939
Saxon GlobalHouston, TX, USFull-time
US|Financial Analyst III
AirswiftHouston, TX, United StatesTemporary