Senior Software Engineer (SQL, AWS, & Java)
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).
- Compensation
- $150K–$170K / yr
- Location
- Arlington, VA
- Work setup
- Hybrid
- Seniority
- Senior
- Employment
- Not specified
- Experience
- Not specified
- Category
- Software engineering
- Posted
Skills
Must have
- Bachelor's or Master's degree in computer science or relevant field
- 5+ years of experience and strong proficiency in PL/SQL, including stored procedures, views, and functions
- 3+ years of experience and strong proficiency with AWS and related technologies
- Experience with software development lifecycle (SDLC) from conception through end of life
- Experience with a version control system (e.g., Git)
- Experience with an issue/problem-tracking system (e.g., Jira)
- Comprehensive knowledge of database administration and development
- Comprehensive knowledge of data analysis, modeling, and database design techniques
- Comprehensive knowledge of 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 of 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 a must — AWS, Azure or similar
- Experience with EFT technologies
- Experience with high availability, fault tolerance, and disaster recovery
- Experience with Agile development tools, such as Jira, Bitbucket, and Confluence
- Experience with artificial intelligence (AI) tools to optimize workflows, problem-solving, and productivity
Nice to have
- Experience developing software applications using Java, C#/.NET, or Python
- 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 CloudFormation (yaml) and similar languages
Full description
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.