Data Warehouse Analyst

2 weeks ago

houston, United States Addison Group Full time

Looking for A Data Warehouse Analyst to design, develop, test, maintain, and support batch applications using Oracle PL/SQL for Retail Commissions and Amortization.


Essential Duties/Responsibilities:

  • • Develop 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 come into the downtown office Monday, Tuesday, and Thursday of every week

  • Data Warehouse Analyst

    2 weeks ago

    Houston, United States Addison Group Full time

    Looking for A Data Warehouse Analyst to design, develop, test, maintain, and support batch applications using Oracle PL/SQL for Retail Commissions and Amortization.Essential Duties/Responsibilities:• Develop Oracle PL/SQL applications.Create Oracle PL/SQL packages, stored procedures, and functions. Create database objects like tables, views, triggers,...

  • Data Warehouse Analyst

    2 weeks ago

    houston, United States Addison Group Full time

    Looking for A Data Warehouse Analyst to design, develop, test, maintain, and support batch applications using Oracle PL/SQL for Retail Commissions and Amortization.Essential Duties/Responsibilities:• Develop Oracle PL/SQL applications.Create Oracle PL/SQL packages, stored procedures, and functions. Create database objects like tables, views, triggers,...

  • Data Analyst

    4 days ago

    Houston, United States Emergent Professional Resources L.P. (EPR) Full time

    *No C2C or Sponsorship Available*Our Financial Services client is looking for a Data Analyst in Houston, TX. This opportunity is located near the Jersey Village area of Houston offering Hybrid Flexibility. You will support the development of Key Performance Indicators with the IT Department. You will also ensure data governance, accuracy, and consistency...

  • Data Analyst

    4 days ago

    Houston, United States Emergent Professional Resources L.P. (EPR) Full time

    *No C2C or Sponsorship Available*Our Financial Services client is looking for a Data Analyst in Houston, TX. This opportunity is located near the Jersey Village area of Houston offering Hybrid Flexibility. You will support the development of Key Performance Indicators with the IT Department. You will also ensure data governance, accuracy, and consistency...

  • Data Analyst

    4 weeks ago

    Houston, United States Brooksource Full time

    _*Data Analyst*__*Downtown Houston, TX – Hybrid (3 days/wk onsite)*__*3 month CTH (Guaranteed Conversion)*__*$90k Conversion Salary*_Our client's Data & Analytics organization is growing! This team specifically focuses on the Gas sector and is tasked with taking ad hoc requests for reporting on the business's needs whether it be dashboard creation related...

  • Data Analyst

    3 weeks ago

    houston, United States Insight Global Full time

    About the Role:Title: Data AnalystLocation: Houston, TX or Evansville, IN / 3 days onsiteDuration: 6 month contract (with the possibility of conversion after 3 months)Must Haves:3+ years of experience with a bachelor's degree from an accredited college or university in Data Science, Analytics, Mathematics, Statistics, Computer Science, or a related...

  • Data Analyst

    2 weeks ago

    Houston, United States Insight Global Full time

    About the Role:Title: Data AnalystLocation: Houston, TX or Evansville, IN / 3 days onsiteDuration: 6 month contract (with the possibility of conversion after 3 months)Must Haves:3+ years of experience with a bachelor's degree from an accredited college or university in Data Science, Analytics, Mathematics, Statistics, Computer Science, or a related...

  • Data Analyst

    3 weeks ago

    houston, United States Insight Global Full time

    About the Role:Title: Data AnalystLocation: Houston, TX or Evansville, IN / 3 days onsiteDuration: 6 month contract (with the possibility of conversion after 3 months)Must Haves:3+ years of experience with a bachelor's degree from an accredited college or university in Data Science, Analytics, Mathematics, Statistics, Computer Science, or a related...

  • Data Analyst

    3 weeks ago

    Houston, United States Insight Global Full time

    About the Role:Title: Data AnalystLocation: Houston, TX or Evansville, IN / 3 days onsiteDuration: 6 month contract (with the possibility of conversion after 3 months)Must Haves:3+ years of experience with a bachelor's degree from an accredited college or university in Data Science, Analytics, Mathematics, Statistics, Computer Science, or a related...

  • Data Analyst

    3 weeks ago

    Houston, United States Insight Global Full time

    Length: contract to PERM hireSchedule: Fully onsite Monday-Friday 77064Hours: 8-5, standardGreat team and company culture!Requirements:1-3+ years of experience as a Data AnalystExperience using Google Big Query – running reportsExperience with Tableau, Power BI, and SQLExperience with ETL processes, data warehousing, and database management...

  • Data Analyst

    3 weeks ago

    houston, United States Insight Global Full time

    Length: contract to PERM hireSchedule: Fully onsite Monday-Friday 77064Hours: 8-5, standardGreat team and company culture!Requirements:1-3+ years of experience as a Data AnalystExperience using Google Big Query – running reportsExperience with Tableau, Power BI, and SQLExperience with ETL processes, data warehousing, and database management...

  • Data Analyst

    3 weeks ago

    houston, United States Insight Global Full time

    Length: contract to PERM hireSchedule: Fully onsite Monday-Friday 77064Hours: 8-5, standardGreat team and company culture!Requirements:1-3+ years of experience as a Data AnalystExperience using Google Big Query – running reportsExperience with Tableau, Power BI, and SQLExperience with ETL processes, data warehousing, and database management...

  • Senior Data Analyst

    2 months ago

    Houston, United States Creative Financial Staffing Full time

    Senior Data Analyst About the Company and Opportunity: Our client is a leader in outpatient physical and occupational therapy clinics. This firm has been in business for over three decades and are in major growth mode Why work here: The value of inclusion and teamwork is celebrated. They're a service and care-focused business and believe that integrity is...

  • Commodities Data Analyst

    2 months ago

    houston, United States Cititec Talent Full time

    Data Analyst - Commodities - Houston - up to $150k + bonus & packageCititec Talent has partnered exclusively with a cutting-edge commodities trading firm seeking a Commodities Data Analyst. In this role, you'll work closely with traders and analysts to help to optimise their trading decisions and operations.This role is perfect for someone with a passion for...

  • Commodities Data Analyst

    1 month ago

    houston, United States Cititec Talent Full time

    Data Analyst - Commodities - Houston - up to $150k + bonus & packageCititec Talent has partnered exclusively with a cutting-edge commodities trading firm seeking a Commodities Data Analyst. In this role, you'll work closely with traders and analysts to help to optimise their trading decisions and operations.This role is perfect for someone with a passion for...

  • Commodities Data Analyst

    2 months ago

    Houston, United States Cititec Talent Full time

    Data Analyst - Commodities - Houston - up to $150k + bonus & packageCititec Talent has partnered exclusively with a cutting-edge commodities trading firm seeking a Commodities Data Analyst. In this role, you'll work closely with traders and analysts to help to optimise their trading decisions and operations.This role is perfect for someone with a passion for...

  • Data Analyst

    1 month ago

    Houston, United States Brooksource Full time

    Data AnalystBrooksourceFortune 500 Utility ClientDowntown Houston, TXOur client's data analysts will leverage their knowledge of systems, business processes, regulatory requirements and mathematical/statistical expertise to develop new datasets, provide oversight to processes and systems affecting data quality, and perform exploratory analysis to discover...

  • Data Analyst

    1 month ago

    houston, United States Brooksource Full time

    Data AnalystBrooksourceFortune 500 Utility ClientDowntown Houston, TXOur client's data analysts will leverage their knowledge of systems, business processes, regulatory requirements and mathematical/statistical expertise to develop new datasets, provide oversight to processes and systems affecting data quality, and perform exploratory analysis to discover...

  • Business Data Analyst

    7 days ago

    Houston, United States REDLEO SOFTWARE INC. Full time

    Business System AnalystData AnalystBusiness Data Analyst requiredLength: Long TermJob Title: Business/Data AnalystLocation: Houston, TXType: ONSITE onlyLocals can apply Key Responsibilities:Data Analysis and Insights: Leverage advanced data analysis techniques to extract meaningful insights from complex datasets.Business Process Improvement: Collaborate with...

  • Sr. Analyst/Business Analyst

    6 months ago

    Houston, United States Royal & Ross Full time

    This is a contract position. Hybrid schedule in office/remote Supply Chain: Warehouse & Inventory Business Analyst Senior level Expert in Oracle EBS Experience in Order Management, Warehouse, Inventory, Supply Chain