Senior Data Engineer (Fintech)

TL;DR

Senior Data Engineer (Fintech): Architecting and implementing resilient data ingestion pipelines and designing normalized database schemas optimized for transactional processing with an accent on seamless integration between vendor systems and internal applications, maintaining high availability and performance. Focus on Azure SQL performance tuning and OLTP optimization to guarantee sub-second response times for critical applications.

Location: Flexible hybrid work environment (onsite 2 days a week/3 days remote) at our Arlington, TX office. We are unable to provide any type of sponsorship for this position at this time.

Company

hirify.global is committed to AI-powered transformation, using advanced machine learning and automation to help reimagine customer interactions and modernize operations, positioning hirify.global as a leader in digital innovation within a dynamic industry.

What you will do

• Architect and build resilient pipelines to extract data from vendor APIs/SFTP and load it into Azure SQL with minimal latency.
• Design and maintain a normalized (3NF) database model optimized for OLTP and application integration.
• Create and optimize Views, Stored Procedures, and Table Functions that allow internal applications to safely read/write data without direct access to raw tables.
• Implement strategies to ensure the internal ODS matches the vendor “State of Truth,” handling record updates, deletions, and conflict resolution.
• Tune Azure SQL for application performance (index tuning, locking/blocking reduction, query plan analysis) to ensure sub-second response times for integrated apps.
• Build “self-healing” mechanisms to queue and retry requests when vendor systems fail, preventing downstream application crashes.

Requirements

• Expert-level proficiency in Azure SQL or SQL Server, including OLTP design, normalization (3NF), referential integrity, and constraints.
• Strong experience with Azure ecosystem for event-driven or micro-batch data movement.
• Deep understanding of SQL internals—locking, latches, execution plans, and isolation levels (e.g., Read Committed Snapshot).
• Experience consuming RESTful APIs, handling pagination, rate limiting, and JSON parsing.
• Working knowledge of security methodologies, policies, and best practices for financial data.
• Ability to troubleshoot and optimize high-volume transactional systems for performance and reliability.

Nice to have

• Experience building DR (Disaster Recovery) hot/warm sites for financial data.
• Familiarity with Change Data Capture (CDC) tools to minimize payload size.
• Experience with FIS or similar financial systems.

Culture & Benefits

• Generous benefits package available on day one to include: 401K matching, bonding leave for new parents (12 weeks, 100% paid), tuition assistance, training, GM employee auto discount, community service pay and nine company holidays.
• An environment that welcomes innovative ideas, fosters integrity, and creates a sense of community and belonging.
• Competitive pay and bonus eligibility.
• Flexible hybrid work environment, 2-days a week in office.