Database Architect

Database Architect (T-SQL, SQL Server and investment bank domain) (New York, NY)

Job Description:

We are seeking an experienced Database Architect with 12 15 years of hands-on expertise in ETL development, SQL Server, Python, and Linux. The ideal candidate will play a key leadership role in designing, developing, and optimizing data solutions while working closely with cross-functional teams across onshore and offshore environments. This individual must be self-driven, highly analytical, and capable of driving end-to-end technical solutions.

Responsibilities:

• 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.
• Work extensively in Unix/Linux environments, including shell scripting for automation and system tasks.
• Drive Python-based scripting, automation, and integration workflows.
• Collaborate with analysts, SMEs, and business partners to understand requirements and translate them into technical solutions.
• Act as a technical lead for onshore-offshore teams, ensuring smooth coordination and high-quality deliverables.
• Troubleshoot complex data and performance issues; identify root causes and implement effective solutions.
• Maintain and enhance technical documentation, coding standards, and design guidelines.
• Ensure adherence to organizational best practices, data governance, and compliance requirements.

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.
• Ability to work independently and collaboratively in fast-paced environments.
• 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.
• Prior experience working in engineering roles focused on database and data integration.
• Proven experience with onshore-offshore coordination.
• Experience in preparing and maintaining technical documentation.

Preferred, but not required:

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