What are the responsibilities and job description for the Senior Data Warehouse Analyst position at Resolute Consulting Group?
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
Duties / Responsibilities :
Develop Oracle PL / SQL applications.
- Batch Application Life Cycle using Oracle PL / SQL for Retail Commissions and Amortization.
- 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 analyst to understand the existing calculations process for each workstream and build, test, and UAT.
- 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.
- 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.
- Work with ControlM / Redwood group on re-run / re-start instructions.
- Be willing to perform these off hours during weekdays and weekends.
- Fulfill ad-hoc requests for data pull, table updates or minor enhancements.
- Develop strong working relationships 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 update clearly either verbally or through email.
- Follow issues or delays that would impact deadlines as early in the process as possible.
Requirements
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
Bachelor's Degree or relative working experience