ETL Developer/Data Analyst II

25 Mar 2024

Vacancy expired!

Overview: This position is responsible for providing advanced technical and operational business system support. Performs needs assessments to determine business requirements and implements functional specifications to assigned systems. Ensures that developed solutions support Bank objectives through reporting and analysis activities. May involve elements of system testing or development. May occasionally guide less experienced analysts in the work group.

Morristown, NJ or Remote with occasional travel to Morristown office. Responsibilities:
  • Design, Development and testing of various ETL jobs that feeds data into Axiom controller View.
  • Map new columns, and modify existing logic & build new logic/business rules in Axiom so as to
  • Streamline data flow, improve auditing and efficiency improvement of IT processes related to Regulatory (FRY-9C, FFIEC031) reports, CCAR Reports, Liquidity Reports etc.
  • Should be able to dig into data and suggest performance improvements (Eg: Indexes, table Partition)
  • Should be able to analyze both interface and data issues quickly in Production environment.
  • Collaborate with business to finalize and document requirements
  • Strong analytical and problem-solving/troubleshooting skills
  • Create custom reports in Axiom
  • Experience/knowledge in Finance and Accounting Domain is preferrable.
  • Knowledge of General Ledger is preferrable
Qualifications: Bachelor's Degree and 2 years of experience in Application software programming OR High School Diploma or GED and 6 years of experience in Application software programming

Preferred Area of Study: Computer Science

Technical Stack:
  • System Analyst
  • Data Analyst
  • MS Excel
  • MS SQL
  • ETL
  • SSIS/SSRS
  • JIRA
  • DevOps Azure

  • ID: #49536688
  • State: New Jersey Morristown 07960 Morristown USA
  • City: Morristown
  • Salary: USD TBD TBD
  • Job type: Permanent
  • Showed: 2023-03-25
  • Deadline: 2023-05-22
  • Category: Accounting/finance