Database Architect (Fintech)

TL;DR

Database Architect (Fintech): Leading the design, development, and optimization of database systems and ETL processes with an accent on scalability, performance, and data governance. Focus on driving end-to-end technical solutions, troubleshooting complex data issues, and ensuring adherence to best practices across onshore-offshore teams.

Location: Must be based in New York, NY

Salary: $150k - $170k/year

Company

hirify.global is a global consulting firm that combines creativity and innovative technology to deliver industry-leading digital solutions for financial services and technology firms.

What you will do

• Lead and deliver end-to-end ETL development using SQL Server, Python, and Linux-based components.
• Architect, design, and optimize database systems ensuring scalability, performance, and reliability.
• Develop T-SQL queries, stored procedures, functions, and database structures following best practices.
• Drive Python-based scripting, automation, and integration workflows.
• Act as a technical lead for onshore-offshore teams.
• Troubleshoot complex data and performance issues and implement effective solutions.

Requirements

• 12–15 years of experience in ETL development with a strong focus on SQL Server, Python, and Linux.
• Deep expertise in Microsoft SQL Server (MSSQL), including T-SQL, stored procedures, data modeling & architecture patterns, performance tuning, and optimization.
• Strong understanding of Unix/Linux environments and shell scripting.
• Hands-on experience with Python for scripting, automation, and data integration tasks.
• Strong analytical and problem-solving skills with a proven ability to resolve complex technical issues.
• Excellent verbal and written communication skills for engaging with technical and non-technical stakeholders.

Nice to have

• Familiarity with AWS services and cloud technologies (e.g., EC2, RDS, Lambda, S3).
• Exposure to modern data pipelines, orchestration tools, or CI/CD practices.

Culture & Benefits

• Multinational organization with 60 offices in 20 countries.
• 10 days of paid annual leave (plus sick leave and national holidays).
• Comprehensive insurance plan including medical, dental, vision, life insurance, and long-/short-term disability.
• Extensive training opportunities and access to Udemy for Business.
• Coaching opportunities with experienced colleagues.