Description

We have an immediate long-term opportunity with one of our prime clients for a position of Data Engineer to work on Remote basis.

MUST HAVES:-
SQL
Talend
Informatica
ETL
 
NICE TO HAVES (OR WHAT GETS THE WIN):
1.   Java and GO
2. API Development

PROJECT DETAILS (Size, Scale, Scope):

  • What is the scope of work that is being completed? Loyalty and Rewards Backlog and other projects.
  • What part of the project is this resource supporting? Non SOW team working through backlogs
    • Day to day responsibilities:

 

  • L&R program has major backlog - 4 major projects to tackle (likely happening consecutively)
    1. Rewards payout dashboard (dashboard built by Centene - power BI)
      1. Devs will be working 100% with the data and in the DB
      2. Strong SQL skills to ensure pulling in the correct data and queries built out to populate the data in the PowerBI dashboard
      3. Currently no visibility into the data on what is being paid out - this data pull and dashboard with give visibility
      4. Goal is to be able to identify the issues/what is not being paid out before it gets escalated from the members or health plan 
    2. Reward updates
      1. This is what they do on a regular basis
      2. One CE will get switched out and go to work with the Core team; and a Centene FTE will join this team to work through this
      3. Updating rewards in DB with requirements needed to generate the monetary reward balance
      4. Heavy SQL work - a lot is built out through to draw from since this is what the core team does consistently
      5. ETL background will be needed
      6. Talend is moving the data around in the background and over to the vendor
    3. Automate the reward redemption process (in Talend)
      1. Automating and manual ETL process they have in place
      2. This project still needs to be flushed out some (Centene will flush out, Devs will be given clear work when they get to this project)
      3. It is currently a manual process to trigger reward payout and they need to automate the process
      4. Need to know Talend for this project - it is built in Talend, need to schedule the jobs the right way so they are picked up and automatically processing
      5. There could be some API development needed here (but they do have this skill set internally - would be a nice to have for our Devs)
    4. 2025 rewards
      1. Similar to first project
  • This team is 100% focused on the data side - heavy work with SQL and Talend work
  • Are there deliverables and milestones the team is working towards?  If so, what? Updates and automation through backlog efforts.
    • Who are you working with to complete that work?
    • What other teams/managers are impacted by this project or initiative?

 
ADDITIONAL QUESTIONS:

  • Technical Environment: SQL Talend ETL
  • Team Size & Structure: FTE team and supplemental team for backlog
  • Soft Skills/Company Culture:
  • Education:
  • Certifications:
  • Level (junior/mid/senior –years of experience): 
  • Industry: Is specific industry experience required?
  • Selling Points for Candidates: Perks? What is exciting about positionCompany?

Education

Any Graduate