Junior Business and Technology Analyst – Data Engineer

Axos Bank
Job LocationUS
Job TagFull Time

Location: San Diego, CA (Onsite)

Description:

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 within each. We are seeking innovative and energetic individuals who are excited about expanding their skillsets 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 Engineer where roles and 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.

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
  • Document process steps of repetitive tasks performed
  • Perform any additional duties as assigned

Qualifications:

  • Bachelor’s Degree in Information Technology, Computer Science, Business Administration, Mathematics or a related discipline 
  • 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.  Excuses aren’t in your vocabulary because you always find alternative solutions when issues arise
  • Ethics: Highest level of professional integrity and honesty as well as personal credibility.  Your reputation for precedes you in this regard
  • Innovation: Dedication to maintaining cutting edge talent with the courage to implement new ideas, technology, and aggressively challenge the status quo.  You don’t accept responses to new ideas like “That’s the way it’s always been done” because you use facts, data, and people skills to implement meaningful change
  • 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 

Employer Insights:

  • Part of rotational JBATA (Junior business and technology analyst) cohort.
  • Applicants must have bachelor’s degree and soft skills.
  • No remote work allowed.

Leadership: Industry Professional Shares Tips and Tidbits

A strong advocate for gender equality in the tech industry, Kanksha Masrani co-leads the Women in STEM Recruiting Team at Procter & Gamble. She says that strong leadership is dependent on three things: your principles, leading yourself first, and asking for what you need.

Related Industries: Data
Woman gives a talk in a classroom.

How to Become a Strong Female Role Model

When Ashley Hurlburt started doing data entry for a massage therapist association, she realized it wasn’t so black and white.

Related Industries: Coding, Data
A portrait shows Ashley Hurlburt holding her daughter and smiling at the camera.

The 8 Must-Have Data Analyst Skills

In the field of data analytics, there are a number of skills and qualities that set great analysts apart from the competition. We have outlined the 8 must-have data analyst skills and habits that can help you become an in-demand and proficient data analyst.

Related Industries: Data
Paper with area to list skills.