Senior Data Engineer, Enterprise Finance Technology

$140,000 - $160,000 yearly
  • The Resume Review - Recruiting Department
  • Charlotte, NC, USA
  • Jan 13, 2022
Full time Information Technology

Job Description

Job description
• Believes diversity makes us stronger so we can reflect, connect and meet the diverse needs of our clients and employees around the world
• Is committed to building a workplace where every employee is welcomed and given the support and resources to perform their jobs successfully
• Wants to be a great place for people to work and strives to create an environment where all employees have the opportunity to achieve their goals
• Provides continuous training and development opportunities to help employees achieve their career goals, whatever their background or experience
• Is committed to advancing our tools, technology, and ways of working to better serve our clients and their evolving business needs
• Believes in responsible growth and is dedicated to supporting our communities by connecting them to the lending, investing and giving them what they need to remain vibrant and vital
Job Description:
Broker dealers play an important role in global markets as market makers and traders by executing large multi-billion dollar trade volumes across a diverse and complex portfolio of products. Large regulatory fines as well as reputational risk could ensue if the Bank fails to follow few required rules like daily cash reserve deposits with FED, maintain net capital levels, report trading activities etc.
Broker Dealer Regulatory Reporting Technology Function (BDFRR) was set up to eliminate operational risk in the reporting process by replacing legacy systems and processes with efficient automated technology stack. BDFRR Platform has footprint across DB, ETL, IIS, Pega, Linux, Python and Axiom Infrastructure components.
Axiom V10 Upgrade is a global initiative project across ASIA, EMEA & US regions. Axiom is used as a regulatory reporting tool by the business teams for timely submission of reports to the regulating bodies.
The candidate will work on data sourcing from several ADS systems and implementing the calculations in Axiom for regulatory reporting purposes. The role involves complex problem solving in the areas of data warehousing including data transformations, user defined functions creation, data engineering, regression and user training. So, we are looking to hire senior developer for axiom development that can effectively lead the design and development of the solutions and closely work with all the stakeholders and global team members for the timely delivery.
Responsibilities include:
  • Extensively work with Data from sourcing, transformation, lineage to reporting. Collaborate with other team developers for reviews to build high-quality reusable code (user defined functions).
  • Troubleshooting and Performance tuning of the application for SLA enhancements.
  • Document, Design, Develop, test and validate the solution for automating regulatory report generation process for Broker Dealer business.
  • Design and Develop SQL for database interaction to read/write data.
  • Active contribution to application lifecycle including maintenance, release management, critical bug fixing and ensure error free delivery of the software solution.
  • Partner well with the Scrum Master, Project Manager, and other agile team members.
  • Hands-on experience in regulatory reporting tools like Axiom.
  • Hands-on experience in data warehousing tools with efficient data transformation and processing skills.
  • Hands-on experience in database development with efficient SQL, performance tuning and debugging skills.
  • Good understanding of Job Schedulers, Data Loaders, Scripting.
  • Good understanding of performance tuning and debugging/Problem-solving skills.
  • Self-starter, team player, good communications
  • Domain knowledge in Investment Banking/ Regulatory Reporting.
  • Axiom V9 or V10 tool
  • Data warehousing such as Informatica Power Center ETL Tool
  • RDBMS like Oracle, SQL Server or PL/SQL programming
  • Data exchange formats such as XML, JSON and FIX protocol.
  • Job schedulers like Autosys
  • Build automation tools like Jenkins, Ansible and source control systems like GIT, Perforce
  • Agile methodologies
  • Optional :
    • Python, C# or Java
    • Pega
    • Shell Scripting in Unix/Linux
    • Investment Banking/ Regulatory Reporting Domain knowledge