JBATA- Data Engineer

Axos Bank; Coronado (CA); On-site; USD 25,000 - 41,000; Full time

Benefits offered by this job

Medical, Dental, Vision, and Life Ins.

Paid Sick Leave

3 weeks’ Vacation

Holidays (about 11 a year)

401(k) Employer Match Program

HSA or FSA account

Job summary

Axos Bank offers a full-time Data Engineer Rotational Program, based on-site at our San Diego HQ. You will rotate through data engineering areas to gain exposure to database development, data quality, and BI reporting while contributing to enterprise-level solutions.

The program emphasizes SQL development, software-driven solutions, and collaboration across Salesforce, Marketing Cloud, and omnichannel projects, with the aim of permanent placement in your chosen focus area.

Qualifications

• Bachelor's Degree in Information Technology, Computer Science, Business Administration, Mathematics or a related discipline
• Basic to intermediate knowledge in SQL server database development and testing
• Programming: Apex, Lightning Web Components
• Automation: SSIS and data integration
• Exposure to integrations with cloud and on-premise systems

Responsibilities

• Define, prepare, execute and implement data validation and testing for data quality
• Create SSIS packages for data transformation, cleansing, caching, staging, and transfer
• Analyze and define data flow requirements and prepare documentation
• Code, test and maintain SQL jobs, stored procedures and functions
• Tuning performance of procedures, tables, indexes
• Review SQL code for standards and performance
• Perform data analysis and profiling to support decisions
• Develop dashboards and BI solutions across Salesforce, Marketing Cloud, omnichannel
• Collaborate with IT and business units to plan launches and prepare documentation
• Understand bank databases and data sources for reliable reports

Skills

SQL server development

Leadership

Results oriented

Ethics

Innovation

Immersion

Education

Bachelor's Degree in Information Technology, Computer Science, Business Administration, Mathematics or related discipline

Tools

Apex

Lightning Web Components

SSIS

Cloud integrations

Job description

Salary & Bonus

Axos Bank Target Range: $30.00 /Hr. - $30.00 /Hr. Actual starting pay will vary based on factors including, but not limited to, geographic location, experience, skills, specialty, and education. Eligible for an Annual Discretionary Cash Bonus Target: 10% Eligible for an Annual Discretionary Restricted Stock Units Bonus Target: 10% These discretionary target bonuses may be awarded semi-annually based upon your achievement of performance goals and targets.

About This Job

This is an exciting opportunity to join a unique and immersive rotational program as a first step in your career in technology! This full-time rotational program is geared toward providing multi-software platform exposure that focuses on the expansion of knowledge and real-life application. We are seeking innovative and energetic individuals who are excited about expanding their skill sets and accelerating their career path with immediate exposure to software applications. For this position, you will be in the Data Engineer Rotational Program where you will be joining the Axos’ Centers of Excellence group. You will get to be a part of a team responsible for the implementation of cutting-edge software driven solutions. As you progress through the program, you will rotate into different complementary areas within Data Engineering where your responsibilities will change. The final goal of the program is permanent placement within your area of focus. For those looking to make an impact this is where it begins. In this role you will be focused on SQL related software or software built on direct interactions with SQL. Through the different rotations completed, you will gain the knowledge and skills database development, data quality, and business intelligence reporting to provide enterprise level solutions. This role is 100% on-site and located at our HQ in San Diego, CA.

Responsibilities

• Define, prepare, execute and implement data validation and unit and integration testing methods to ensure data quality
• Create SSIS packages for data transformation, cleansing, caching, aggregation, staging, and transfer
• Analyze and define data flow requirements and prepare applicable system documentation and operation manuals as needed
• Code, test and maintain new and existing SQL jobs, stored procedures and functions
• Performance tune existing stored procedures, tables and indexes
• Troubleshoot problems that may come up with database environments: performance issues, replication issues, or operational issues
• Review SQL code written by other developers to ensure compliance to coding standards and best practices as well as maximum performance
• Perform data analysis and data profiling tasks to provide support and recommendations for development and design decisions
• Develop solutions adhering to software development lifecycle (SDLC) on a cross-platform team involving Salesforce, Marketing Cloud, and omnichannel solutions
• Join client meetings to communicate status, give demos, provide timelines and offer insights
• Participate in daily meetings that go over testing, and code reviews
• Work with IT, Enterprise Data Management, Project Managers, Business Analysts, stakeholders across multiple business units to systematically plan the launch of new or enhanced dashboards, prepare launch collateral/documentation and work closely with users during through the different phases of a project
• Develop deep understanding of the Bank's databases, identify appropriate data sources, relationships and logic needed to produce consistently reliable reports
• Perform any additional duties as assigned

Qualifications

• Bachelor's Degree in Information Technology, Computer Science, Business Administration, Mathematics or a related discipline
• Basic to intermediate knowledge in SQL server database development and testing
• Programmatic components: Apex, Lightning Web Components
• Automation components: Flows, Assignment Rules
• Basic to intermediate knowledge in SSIS packages
• Exposure to Integrations with other cloud and on premise based system
• Customer Obsession: "Good enough" isn't good enough for you. You're obsessed with perfecting the customer experience
• Leadership: A confident person with the ability to connect and inspire others to achieve success, whether or not they directly report to you
• Results Oriented: A driver who possess the ability to take actions and implement effective solutions in a timely manner.
• Ethics: Highest level of professional integrity and honesty as well as personal credibility.
• Innovation: Dedication to maintaining cutting edge talent with the courage to implement new ideas, technology, and aggressively challenge the status quo
• Immersion: A propensity to rapidly master the understanding and application of new technology
• Excellent verbal and written communication skills, including ability to simplify complex concepts for technical and non-technical audience

Axos Employee Benefits May Include

• Medical, Dental, Vision, and Life Insurance
• Paid Sick Leave
• 3 weeks’ Vacation
• and Holidays (about 11 a year)
• HSA or FSA account and other voluntary benefits
• 401(k) Retirement Saving Plan with Employer Match Program and 529 Savings Plan
• Employee Mortgage Loan Program and free access to an Axos Bank Account with Self-Directed Trading

About Axos

Born digital-first, Axos delivers financial tools and services that allow individuals, small businesses, and companies to access and manage their money how, when, and where they want. We’re a diverse team of dynamic, insightful, and independent innovators who are excited to provide technology-driven solutions that offer unbeatable value to our customers. Axos Financial is our holding company and is publicly traded on the New York Stock Exchange under the symbol "AX" (NYSE: AX). Learn more about working at Axos

Pre-Employment Background Check and Drug Test

All offers are contingent upon the candidate successfully passing a credit check, criminal background check, and pre-employment drug screening, which includes screening for marijuana. Axos Bank is a federally regulated banking institution. At the federal level, marijuana is an illegal schedule 1 drug; therefore, we will not employ any person who tests positive for marijuana, regardless of state legalization.

Equal Employment Opportunity

Axos is an Equal Opportunity employer. We are committed to providing equal employment opportunities to all employees and applicants without regard to race, religious creed, color, sex (including pregnancy, breast feeding and related medical conditions), gender, gender identity, gender expression, sexual orientation, national origin, ancestry, citizenship status, military and veteran status, marital status, age, protected medical condition, genetic information, physical disability, mental disability, or any other protected status in accordance with all applicable federal, state, and local laws.

Job Functions and Work Environment

While performing the duties of this position, the employee is required to sit for extended periods of time. Manual dexterity and coordination are required while operating standard office equipment such as computer keyboard and mouse, calculator, telephone, copiers, etc. The work environment characteristics described here are representative of those an employee may encounter while performing the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position.

E-Verify and Right to Work Notices

Axos participates in the U.S. Department of Homeland Security E-Verify program in all facilities located in the United States. The E-Verify program is an internet-based employment eligibility verification system operated by the U.S. Citizenship and Immigration Services. IER Right to Work Poster (English/Spanish) E-Verify Participation Poster (English/Spanish)

We’re a team of relentless innovators that are challenging the status quo through smart, pro-consumer financial products and services. We got our start in 2000, as an online bank – when the idea of banking online was almost unthinkable. Since then, we’ve evolved to add commercial banking, commercial lending, investment, clearing, and fiduciary services to our toolbox. As modern life continues to present new challenges for clients, we step up and find creative ways to solve them.