Finance Data Engineer
- Curate the data management infrastructure for the finance team to drive automation in data integration and management.
- Design, create and maintain data pipelines for reporting and planning purposes.
- Partner with IT department to build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, Python, PySpark, and AWS 'big data' technologies.
- Identify data sources for new projects.
- Act as a subject matter expert for Axiom data structures and system data processing.
- Act as a subject matter expert for financial data workflows, mapping and data translation.
- Drive automation through effective metadata management.
- Support Workday and Salesforce ETL integrations for Axiom.
- Support reporting and general analytics needs of the department.
- Utilize python and other programming language to expand the connection between Axiom and external servers such as Informatica and AWS cloud.
- Work closely with Product Owners of Deposits and Loans.
- Monitor schema changes for key source systems for deposits, loans, and general ledger.
- Recommend integration optimizations as identified.
- Streamline reporting using Axiom and other tools of opportunity.
- Work with ETL team and with business (data) analysts to refine their data requirements for various data and analytics initiatives.
- Propose appropriate (and innovative) data ingestion, preparation, integration, and operationalization techniques.
- Adheres to and complies with applicable, federal and state laws, regulations and guidance, including those related to anti-money laundering (i.e. Bank Secrecy Act, US PATRIOT Act, etc.).
- Adheres to Bank policies and procedures and completes required training.
- Identifies and reports suspicious activity.
- 1 - 3 years Corporate Finance or Accounting required.
- 1 - 3 years Database management, including data extraction required.
- Designs database, table structures and ETL definitions.
- Maintains visibility into database interfaces and monitors systems configuration to ensure and assist in the validation of data integrity.
- Writes and executes ETL code, primarily complex SQL stored procedures, but with a strong ability to leverage other technologies.
Recommended Jobs
Spa Attendant (Locker Room)
Job Description Job Description # Job Summary Primarily responsible for the smooth, efficient client journey; greeting, orientation to facilities, assigning lockers and guiding guests to th…
Mortgage Protection Life Insurance Agent - Work from Home
Location: [Remote/Work from Home] Job Type: [Full-Time/Part-Time/Uncapped Commission-Based] About Us: GIA Legacy Planning is a dynamic and client-focused insurance agency. We special…
Physical Therapist
Overview: Physical Therapist Job Type: Full-time Salary: $75,000-$100,000 / Year Job Location: Collegiate Village, Florida Up to $15,000 in sign-on bonuses available How We S…
Construction/Project Manager (FTL / S FL)
Are you an experienced Construction or Project Manager based in Florida, passionate about building a career in commercial development, construction, and real estate? We are seeking dedicated individua…
Bell Person Overnight
Job Description Job Description At Loews Hotels at Universal Orlando, our team members get to make a difference and have fun every day. Our world-class team brings to life the incredible, award-w…
Heavy Equipment Operator - Travel Required
Job Description Job Description POSITION: HEAVY EQUIPMENT OPERATOR Check out our YouTube Video! A Day in the Life of a Operator at COMANCO COMANCO has a great career opportunity and excell…
Franchise Business Partner (Southeast)
Job Description Job Description Description: At Dogtopia we are dedicated to offering exceptional care for dogs with over 250 locations in the United States and Canada. Our facilities provide …
U.S. Private Bank - Private Banker - Vice President
Job Description We are actively looking for exceptionally talented individuals who are collaborative, confident and motivated to provide a first-class experience to clients within J.P. Morgan’s U.…
Residential Service Plumber
Job Description Job Description Benefits: ~401(k) ~ Bonus based on performance ~ Company car ~ Company parties ~ Dental insurance ~ Employee discounts ~ Free uniforms ~ Health insu…