ETL Developer II (932831)
Advance America
Corporate
7h ago

ETL Developer II (932831)

Date : Jul 23, 2022

Location : Spartanburg, SC, US, 29306

  • job-location.job-location-inline display : inline;
  • Company : Purpose Financial

    Address : , , , United States -

    Purpose Financial, Inc. is an innovative consumer financial services company that offers a diverse suite of credit products, promoting financial inclusion and meeting consumers wherever they are.

    Through its brands, the company is committed to helping customers achieve their version of financial stability in the moment and in the future.

    Since 1997, Purpose Financial has been a pioneer in the consumer credit and financial services market offering money solutions in over 1,200 storefronts locations and online lending.

    Providing services in over 27 states, Purpose Financial employs over 3,700 team members.

    At Purpose Financial we are always on the lookout for motivated individuals who share in our values of mutual respect to join our team of outstanding professionals.

    We offer :

  • Competitive Wages
  • Life / Health Benefits
  • 401(k) Savings Plan
  • Educational Assistance
  • Paid Vacation / Holidays
  • Employee Discounts
  • Work-life Balance
  • Business Casual Environment
  • Paid Volunteer time off
  • Rewards and Recognition Program
  • To learn more about Purpose Financial visit Purpose Financial Website

    Position Summary

    This position reports to Manager, Data Integration and will be responsible for design, development, testing, documentation, and production support of ETL solutions.

    Support strategic direction of data program, including short & long-term planning and technical design. ETL Developer will provide technical expertise to capture and transform data from disparate sources such as RDMS, APIs, and data streamsto cloud AWS and Snowflake..

    This position will serve as a expert in the designing, coding, testing, supporting, and debugging of new & existing ETL code.

    The ETL Developer will partner with technical and business system analysts to implement solutions adhering to architectural standards, while ensuring scalability, quality, and resilience.

    Actively participate in refactoring efforts to make existing ETL processes more stable and performant. Strict adherence to development standards, time tracking and change management process.

    Partner with cross functional teams to understand business and analytical needs.

    Other duties as assigned.

    Job Responsibility

  • Technical design, development, testing, documentation and production support of integrated solutions for data integration methodologies using Matillion, HVR, AWS, and Snowflake (or similar technologies).
  • Participate in data quality architectural review sessions to ensure compliance with direction and standards. Continuously improve system, department, and adhere toindustry standards / best practices.
  • Work with other IT and business groups to understand functionality, scalability, performance, security, observability, and integration requirements fr.
  • Translate these requirements into functional, scalable, resilient, and reusable components with the respective development framework.

  • Analyze application, quality, and issues. Provide / recommend corrective actions. Propose continuous improvements regarding technologies and processes to increase organizational efficiency and application effectiveness and performance.
  • Work closely with users, business analysts, systems analysts, and application developers to define and resolve information requirements, data flow and data content / quality issues.
  • Collaborate with IT in planning, architecting, installing, and implementing systems in a Highly availability & Scalable environment.
  • Support same systems in a production environment with strict SLAs. Collaborate with project teams consisting of ETL developers, Data Engineers and BI Developers.

    Job Responsibilities Cont.

  • Collaborate with analysts and data engineers during data modeling, data mapping and system specification activities.
  • Perform impact analysis of the selected solution, define work packages for the project scope, identify development deliverables and tasks, assign appropriate resources and track / report progress on development deliverables.
  • Support existing data integration solutions as well as continually re-evaluate current processes and techniques for increased accuracy, efficiency, and maintainability.
  • Provide support for production ETL processes.

  • Review and accept completed product for team members.
  • Understand, adhere to and enforce all corporate policies including, but not limited to, Advance America’s Creed, Code of Ethics and Information Security Policies.
  • Education Required

    Bachelor Degree in Information Systems, Computer Science or other relevant field or sufficient experience in the same or related role or equivalent experience.

    Master’s degree in Computer Science, Information Systems or Business Administration or equivalent experience strongly preferred.

    Experience Required

    4+ years of RDBMS development and Datawarehouse methodologies

    4+ years implementation Experience in Informatica / Matillion ETL Tools or similar platform

    3+ years of experience in agile software development life cycle or maintenance projects

    2+ years working experience in financial or other relevant industry vertical experience

    1+ years of working experience in AWS and / or Implementing data solutions using Snowflake

    Knowledge Required

    Extensive knowledge of relational data models and design required. Extensive knowledge of cloud computing concepts and cloud native warehousing.

  • Excellent written and verbal communications skills as would be needed to communicate in person, by phone, and through email;
  • adaptability and flexibility to changing environment; and comfortable working in a dynamic, high volume, fast-paced environment.

    Ability to read, write, evaluate, and apply information. Ability to interact professionally and exhibit appropriate social skills.

    Ability to understand and ensure compliance with policies, procedures, and laws governing our industry / business and products.

    Ability to develop and maintain business relationships.

    Physical Requirements

  • Sitting for long periods of time; standing occasionally; walking; bending; squatting; kneeling; pushing / pulling; reaching;
  • twisting; frequent lifting of less than 10 lbs., occasional lifting of up to 20 lbs.; driving and having access during the workday to an insured and reliable transportation;
  • typing; data entry; grasping; transferring items between hands and / or to another person or receptacle; use of office equipment to include computers;
  • ability to travel to, be physically present at, and complete the physical requirements of the position at any assigned location.

    Competencies

    Customer Advocacy Data Warehouse KnowledgeInclusivenessIntegrity / ComplianceInterpersonal SkillsResilienceResults / AccountabilityTechnical Proficiency / Leadership

    Other

    Must be eligible to work in the USA and able to pass a background check.

    All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or disability.

    Requisition ID : 36585

    Nearest Major Market : Spartanburg

    Nearest Secondary Market : South Carolina

    Apply now

    Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form