Senior Software Engineer (SQL, AWS, & Java)
Posted 1
view
Summary
Senior engineer on IntraFi's Application Development team who designs, administers, and maintains production SQL Server databases, Talend ETL loads, and SSRS/Power BI reporting for its bank deposit-allocation services, while also developing applications in Java, C#/.NET, or Python on AWS. Hybrid role: two days per week in Arlington, VA (three days for the first 90 days).
At IntraFi, we do more than innovate—we empower. Our services help banks provide vital financial access to small businesses, companies, and consumers across the country. With a network of more than 3,000 financial institutions, we help support the institutions that drive our economy, enabling them to fund affordable housing, family farms, and businesses of all sizes. The ability to lend locally strengthens our financial system, and our team plays a direct role in making that possible. It is this greater purpose that brings people to IntraFi and keeps them here.
As the nation’s largest deposit allocation service provider and the inventor of reciprocal deposits, IntraFi has spent over two decades creating dynamic solutions that help financial institutions grow, manage liquidity, and serve their communities. Our impact extends across institutions of all sizes—from community banks to large financial organizations—which enables us to achieve aggressive business growth objectives while helping strengthen the broader financial system. Consistently recognized by American Banker, Washington Post, and Fortune as one of the best places to work, we offer a collaborative, flexible environment where innovation thrives. Join us and be part of a team making a meaningful impact on the industry, on financial institutions, and on the future of financial services.
Your Role
-
You will be a key member of our Application Development Team, solving complex and unique business challenges with forward-looking architectures in a collaborative Agile environment. You will be working on a team of engineers with a broad range of skills to develop new products, modernize existing systems, and support our customers using new and traditional technologies, such as MS SQL, SQL Server, AWS/cloud and programming languages such as Java, C#/.NET or Python.
Your Responsibilities
- Design, develop, and maintain software systems using programming languages such as Java, C#/.NET, Python, or similar technologies.
- Lead the SQL installation, configuration, design, and testing of production-focused databases, supporting all data-related activities. Identify user requirements, set up database structures, test, and coordinate modifications to these systems.
- Lead migration of reports from SSRS to PowerBI or similar SAAS platform.
- Create and maintain data loads from external clients via Talend (ETL) and manipulate data via a strong knowledge of ETL and SQL stored procedures.
- Perform complex "ad hoc" queries, data assembly, and reporting functions for delivery to internal and external teams.
- Implement database performance monitoring, mapping of conceptual designs, refining logical designs, data modeling, maintaining data standards and protection (encryption), writing database documentation (standards, procedures, definitions), defining access control and permissions, managing backup and recovery paths, and participating in capacity planning.
- Provide ongoing maintenance of all organizational production and administrative data sources to ensure data integrity and database security. Troubleshoot database errors, indexing, speed, or other concerns. Coordinate with the Technology and Lead Developer to ensure all data storage and retrieval capabilities are properly supported and maintained within our IT infrastructure.
- Produce and maintain database documentation (e.g., data dictionary, Entity Relationship Diagrams) as required for proper system maintenance and system enhancements.
- Lead the discovery, mock-up, creation, testing, scheduling, and ongoing revision of SQL/SSRS-based business reports.
- Maintain multiple SQL server instances including SQL and OS versions, compatibility, and upgrades, working with external vendors to ensure functionality, etc.
- Coordinate closely with team members, product owners, and scrum masters to ensure user-story alignment and development per business requirements.
- Continue to develop personal field of knowledge in database and related technologies by attending conferences, prototyping new technologies, and exploring new areas of interest.
- Work across departments to design and deliver solutions from inception to production.
- Build subject-matter expertise of our core back-end financial processes.
- Provide support and troubleshooting capabilities to our production systems, as needed, to remediate unexpected issues and outages.
- Develop and evangelize best practices in line with current trends and technologies, with consideration for our existing policies and procedures.
- Leverage Atlassian tool suite, including JIRA and Confluence, to track activities and progress.
- Champion new technology and innovation, while keeping existing systems up-to-date and secure.
Required Experience, Skills, and Qualifications
- Experience with artificial intelligence (AI) tools to optimize workflows, problem-solving, and productivity.
- Bachelor’s or Master’s degree in computer science or relevant field.
- 5 plus years of experience, strong proficiency, and hands-on expertise in PL/SQL, including stored procedures, views, and functions.
- 3 plus years of experience, strong proficiency, and hands-on expertise with AWS, and related technologies.
- Experience with software development lifecycle (SDLC) from conception through end of life.
- Knowledge of value code quality and best practices.
- Experience with version control system (e.g., Git).
- Experience with an issue/problem-tracking system (e.g., Jira).
- High motivation to deliver a quality product on time, every time.
- Ability to work in a fast-paced environment and handle rapidly changing work requirements and priorities.
- Ability to consistently use team project and collaboration software tools including Jira, MS Teams, etc.
- Strong organizational skills.
- Ability to work independently against project milestones to achieve objectives with minimal supervision.
- Excellent problem-solving skills and the ability to multitask within tight deadlines.
- Drive to investigate new technologies and the ability to articulate concepts and designs.
- Excellent written, verbal, and visual communication skills to explain complex topics concisely to both technical and nontechnical audiences.
- Excellent mathematical skills.
- Comprehensive knowledge of database administration and development.
- Comprehensive knowledge of data analysis, modeling, and database design techniques.
- Skill in performing complex and specialized database functions.
- Comprehensive knowledge of structured query language (SQL), SSRS, ETL, and report-writing.
- Strong experience with reporting tools (SQL, SSRS, BI, etc.).
- Comfort with both on-prem and cloud-based SQL deployments.
- Comprehensive knowledge in stored procedures; SQL scripts, database security, backups, and recovery.
- Comprehensive experience using SQL Server Management Studio and related SQL tools (RedGate, etc.).
- Experience with Coldfusion, .Net or java technologies for application development.
- Cloud technologies experience is must – AWS, Azure or similar.
- Experience with EFT technologies
- Skill in evaluating changes in the production environment and anticipating resources needed to meet those changes.
- Experience with high availability, fault tolerance, and disaster recovery.
- Experience with Agile Development tools, such as Jira, Bitbucket, and Confluence.
- Experience developing software applications using programming languages such as Java, C#/.NET, or Python is a plus.
Preferred Qualifications
- Experience in financial applications.
- Knowledge of accounting.
- Certifications in Java, C#/.NET, Python etc.
- Knowledge of CI/CD tools, such as Jenkins, SonarQube, and Junit.
- Experience with Cloud formation (yaml) and similar languages.
This position is a hybrid role where the employee must work two full days per week in our office in Arlington, Virginia. For the first 90 days, the employee must work three full days per week in the office.
Employee Benefits:
401(k)
401(k) matching
Dental insurance
Employee assistance program
Employee discount
Flexible schedule
Flexible spending account
Health insurance
Health savings account
Life insurance
Opportunities for advancement
Paid time off
Parental leave
Professional development assistance
Referral program
Vision insurance
IntraFi LLC is an Equal Opportunity Employer and does not discriminate on the basis of race, color, national origin, sex, religion, age, veteran status, disability, or sexual orientation in employment of the provision of services.
IntraFi’s job application process may include online videoconference interviews, in-person interviews, presentations, and computer-based assessments. If you require reasonable accommodation to complete any part of the application process, please contact hr@intrafi.com.
Skills
As published by lever · 9 questions · 2 written answers
Basics
Resume/CV, Full name, Email, Phone, Current location, Current company, LinkedIn URL, Twitter URL, GitHub URL, Portfolio URL, Other website
Short answers (2)
- If offered this position, what date would you like to begin?
- What is your desired compensation? (Please respond with a number)
Pick from a list (5)
- Are you at least 17 years old?
- Do you currently reside within DC, Maryland, or Northern Virginia?
- Will you now or in the future require IntraFi to sponsor an immigration case in order to employ you (for example, H-1B or other employment-based immigration case)? This is also called “sponsorship".
- Do you have 5+ years of Post-Degree, hands-on experience and strong proficiency with Java-related technologies, AWS, and related technologies?
- I certify that I have read and understand the applicant instructions included with this application and that the answers given by me to the foregoing questions and statements made by me are complete and true to the best of my knowledge and belief. I understand that any false information, omissions or misrepresentations of facts called for in this application, whether on this document or not, may result in rejection of my application or discharge at any time during my employment. I understand that this application form is intended for use in evaluating my qualifications for employment and that this application is not an offer of employment. I further understand that if hired, my employment will be considered "at-will" and that my employment may be terminated for any reason, with or without cause or notice, at any time by me or the Company and that this application is not intended to constitute a contract of continued employment.
Written answers (2)
- Please provide your full current mailing address.
- How many years of SQL experience do you have? Describe your experience with relationship databases (e.g., MySQL, PostgreSQL, SQL Server).
