Data Engineer
Summary
Designs, optimizes, and maintains SQL Server databases and SSIS pipelines to ensure reliable data flows and high performance for business systems.
Responsibilities
- Work with technical and business teams to understand business requirements, functional, and technical specifications
- Design, code, and maintain new and existing complex SQL stored procedures and functions
- Performance tune existing stored procedures, tables, and indexes
- Collaborate with other engineers to troubleshoot, repair, and performance‑tune databases
- Review SQL code written by other developers to ensure compliance with coding standards and best practices, and to maximize performance
- Create SSIS packages for data transformation, cleansing, caching, aggregation, staging, and transfer
- Troubleshoot problems that may arise in database environments, including performance, replication, and operational issues
- Perform data analysis and data profiling tasks to provide support and recommendations for development and design decisions
- Analyze and define data flow requirements and prepare applicable system documentation and operation manuals as needed
- Support production data loads and ongoing refreshes of the database systems
- Define, prepare, execute, and implement data validation and unit testing methods to ensure data quality
- Maintain reusable development standards that help implement solutions and enhance existing systems to meet current and future needs
- Perform enhancements and bug fixes as required
- Perform any additional duties as assigned
Qualifications
- Bachelor's Degree in Computer Science, Information Systems, Computer Engineering, or a related field
- 3+ years’ experience working with relational databases in a production environment
- 3+ years’ experience with Microsoft SQL Server
- 2+ years’ experience developing SSIS packages
- 2+ years’ experience working in an Agile/Scrum environment
- 1+ year of C# scripting experience
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 a 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.
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.