ETL CONSULTANT
Cary, NC Services
Job Type
Full-time
Description

Who We Are:

FRG | The Financial Risk Group is a risk management consulting firm based in Cary, NC.   We are dedicated to providing premier risk management advisory and implementation services to clients around the world. Essentially, we help clients maximize the effectiveness and the value of their investments in risk management technology, methodology, and processes.   


In your role as an ETL Consultant, at a minimum you will:

  • Write and support complex and original software code in support of FRG’s product offerings
  • Perform unit tests on all processes
  • Provide resolution to all data issues
  • Validate all requirements
  • Prepare all ETL processes according to business requirements
  • Incorporate all business requirements into all design specifications
  • Resolve data questions
  • Participate in all aspects of product development including design, development, debugging, implementation, documentation, and support
  • Assist in maintaining the functional operation of assigned production systems
  • Communicate status with project managers
  • Learn to estimate task effort and time frames
  • Troubleshoot and solve complex technical problems
  • Develop and maintain client relationships
  • Communicate effectively with clients to explain difficult business and technical concepts
  • Perform other tasks as assigned


Requirements

Minimum Essentials:

  • MS degree in the areas of Computer Science, Economics, Mathematics, Engineering, Sciences, or Finance, AND 1-3 years of relevant experience. OR, a BS degree plus a minimum 3 years relevant experience
  • SAS software experience
  • SAS DI studio experience
  • Pentaho experience
  • SQL experience
  • UNIX skills
  • Data management techniques
  • Data quality techniques
  • Data analytics reporting
  • Experience with data structures and design
  • Ability to manage multiple concurrent assignments to meet deadlines
  • Strong written communication, oral communication and presentation skills
  • Demonstrated trouble shoot and technical problem solving
  • Demonstrated software skills using software listed above
  • Intermediate understanding of risk management concepts
  • Excellent organizational skills

  

Company Benefits: 

· FRG Group Health Plan effective on your start date

· Company-paid long-term disability coverage

· 401k Plan eligible on the 1st of the month following 1 year anniversary

· 401k -100% immediate vesting & Co. Match of 6% on base salary

· FRG 401k offers both a pretax and Roth option for employee deferrals

· Profit-Sharing - you are eligible to participate in company profit sharing, up to 4% of your base salary

· Bonus program as part of the overall compensation program

· FRG practices a hybrid work model

· Minimum 3 weeks of vacation time per year prorated in the year of hire and the ability to roll over up to 1 week of time annually; *vacation time is adjusted based on your position level

· 2 weeks of paid holidays per year 

· 2 weeks of paid emergency/sick days per year

· Direct deposit monthly paycheck and any expense reimbursements

· FRG pays for approved training, materials, and certification tests with manager approval

· Employee Referral program bonus

· FRG season tickets: Carolina Hurricanes, Durham Bulls, Coastal Credit Union Music Park, NC Courage Soccer/NCFC


Salary Description
Salary Exempt + Bonus