Senior Database Developer / Technical Lead
Location: New York City 520 Madison Avenue 3days/week onsite
Role Overview
We are seeking an experienced Senior Database Developer / Technical Lead 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.
Key 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.
Required Skills & Experience
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.
Nice-to-Have Skills
Familiarity with AWS services and cloud technologies (e.g., EC2, RDS, Lambda, S3).
Exposure to modern data pipelines, orchestration tools, or CI/CD practices.
Personal Attributes
Self-motivated and proactive.
Strong sense of ownership and accountability.
Ability to multitask and manage priorities effectively.
Excellent interpersonal and leadership skills.
Good behavior.