Senior SQL Database Developer

At IntraFi, we prosper by working hard in an open and creative environment. Our employees enjoy the flexibility of a hybrid work environment (flexible telework / remote schedule) along with robust benefits and career growth opportunities. Our efforts to create and maintain a culture that values our people have led us to be designated among the top fintech companies to work for by American Banker. IntraFi has also been recognized as one of the best places to work by the Washington Post's Top Workplaces and the Washington Business Journal's Best Places to Work. Our company is also recognized among Fortune's lists of Best Workplaces-Small & Medium Businesses and Best Workplaces in Financial Services and Insurance.

Headquartered in Arlington, Virginia, IntraFi - the nation's largest deposit allocation service provider and the inventor of reciprocal deposits - provides dynamic, all-weather balance sheet and liquidity management solutions to help financial institutions grow franchise value. The company, chosen by thousands of banks since its founding over two decades ago, has assembled the largest bank network of its kind. Its solutions help institutions to acquire high-value, local relationships; purchase funding; and reduce collateralization costs.

What is the 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 related technologies.

Responsibilities

• 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.

Requisite Experience, Skills, and Qualifications

Preferred Qualifications

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.