• Senior Data Engineer (SQL/Informatica)

    System One (Birmingham, AL)


    Position Title: Senior Data Engineer (SQL/Informatica)

     

    Position Location: Open to all locations including the listed satellite locations - no preference of order

     

    Pittsburgh PA - Two PNC Plaza

     

    620 Liberty Ave

     

    Pittsburgh, PA 15222

     

    Cleveland OH - Strongsville Technology Center

     

    8100 Mohawk Dr.

     

    Strongsville, OH 44136

    Birmingham AL - Birmingham - Brock - most preferred

    701 32nd St. South

     

    Birmingham, AL 35233

     

    North Texas Market TX - Dallas Innovation Center - Luna Rd

     

    11511 Luna Rd

     

    Farmers Branch, TX 75234

     

    Chicago IL - Corridors III Office

     

    2650 Warrenville Rd Ste 500

     

    Downers Grove, IL 60515

     

    Miamisburg OH - Miamisburg Campus Bldg 1

     

    3232 Newmark Dr.

     

    Miamisburg, OH 45342-5421

    Jacksonville FL - Jacksonville Building

    5011 Gate Parkway, Bldg 200/Ste. 300

     

    Jacksonville, FL 32256

     

    Ability to work remote: Hybrid - 3 days in office, 2 Remote

     

    Intended length of Assignment: 12/31/2025 - due to budget but manager will be extending resource immediately with an intent to be 6mon-1 year contract with extension again beyond that.

     

    Impact/Function this role has within the bank/LOB: A combination of mitigating risk, cost reduction, and increasing revenue - to help provide data to make sound decisions for the organization, products projects, etc.

     

    Industry background: technology background required, banking is a nice to have

    Roles and Responsibilities:

    + Work with different departments within our LOB in order to work on data requests.

    + Will need to be able to meet with LOB to go over requirements and gather any additional information needed to complete data request

    + Use SQL to gather all of the necessary data needed in order to meet the request

    + Create documentation related to request, including SQL, and work with ETL team in order for ETL to be able to create the scheduled job using Informatica.

    + Will need to also work with testers in order to ensure they understand the requirements and be able to perform the appropriate testing.

    + Once testing is complete the Data Engineer will need to work with our Run the Bank group in order to prepare for deployment and validation of the deployment.

    Must Have Technical Skills:

    + Strong SQL skills

    Flex Skills/Nice to Have:

    + Experience with Oracle

    + Experience with Home Lending or Lending in general

    + Strong Excel skills

    + Experience with Informatica

    + Azure DevOps

    + JIRA

    Education:

    Preferred bachelor's degree or relevant work experience

    Screening Questions:

    + For SQL written, were these basic SQL queries or complex? Did you have to worry about how efficient they were? Can you provide more detail on types of queries that were written.

    + What issues have you encountered in your previous job experience related to data and how were they resolved?

    + What has been your most difficult project that you have worked on in the past?

     

    Role Differentiator: An opportunity to work with both SQL and the Database, potential opportunity for growth

     

    Interview Process: 1 step ITV with HM and lead developer

    Skills:

    + Strong SQL skills

     

    Share your resume with [email protected]. Also connect me at LinkedIn : (16) Ariz J. Khan | LinkedIn (https://www.linkedin.com/in/ariz-j-khan-17401599/)

     

    Ref: #404-IT Pittsburgh

     

    System One, and its subsidiaries including Joulé, ALTA IT Services, CM Access, TPGS, and MOUNTAIN, LTD., are leaders in delivering workforce solutions and integrated services across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible full-time employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

     

    System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.