Java Full stack Lead/Architect

Net2Source (N2S); New York (NY); On-site; USD 120,000 - 150,000; Full time

Job summary

A leading global workforce solutions company is looking for a Senior Data Architect to lead the design and implementation of data architectures. This role requires extensive experience in Azure Synapse, Python, and data optimization techniques. The ideal candidate will ensure high performance in SQL Server environments and will have strong communication and leadership skills. This position is onsite in New York City and is for locals only.

Qualifications

• Proven leadership and mentoring skills for junior team members.
• Strong communication skills for effective stakeholder engagement.
• Ability to work independently and in a collaborative environment.

Responsibilities

• Design and implement robust data architectures to support business needs.
• Utilize Azure technologies to architect scalable data solutions.
• Oversee SQL Server environments for high performance.
• Write and optimize complex SQL queries and stored procedures.
• Develop documentation for data architecture and processes.

Skills

Lead the design and implementation of robust data architectures

Azure Synapse

Python

PySpark

ADF

SSIS

SQL Server

SQL optimization

Azure DevOps

Communication skills

Job description

Overview

Position: Senior Data Architect — Contract

Location: NYC, NY (Onsite) - Locals Only

Company: Net2Source (N2S). We are a global workforce solutions company offering consulting across industries and are hiring for the Senior Data Architect role as part of client engagements.

Responsibilities & Required Skills

Required Skills:

• Lead the design and implementation of robust data architectures to support business needs and data strategy.
• Utilize extensive experience in Azure Synapse, Python, PySpark, and ADF to architect scalable and efficient data solutions.
• Oversee and optimize SSIS, SSRS, and SQL Server environments, ensuring high performance and reliability.
• Write/review complex SQL queries, stored procedures, and functions, with a strong focus on best practices and optimization.
• Lead the design, build, and deployment of SSIS packages, ensuring they meet business and technical requirements.
• Optimize performance using MSBI toolsets, including SQL Server, SSIS, and SSRS, to enhance data processing and reporting capabilities.
• Apply hands-on experience with Azure DevOps (ADO) and familiarity with version control concepts like cherry-picking and checking/merging code.
• Troubleshoot and debug complex issues in ADF/Synapse Pipelines, SQL Agent Jobs, SSIS packages, and T-SQL queries, providing expert-level support and guidance.
• Report weekly and monthly metrics to track project progress and performance, ensuring alignment with business objectives.
• Proven leadership and mentoring skills, with the ability to guide and develop junior team members.
• Strong communication skills for effective stakeholder engagement and collaboration with senior management.
• Collaborate with senior management to align data architecture goals with organizational strategies and priorities.
• Ability to work independently and in a team-oriented, collaborative environment.
• Develop comprehensive documentation for data architecture, processes, and solutions, ensuring clarity and consistency.
• Propose and implement solutions for various complex use cases, leveraging technical expertise and industry best practices.

Note: This description reflects the responsibilities and required skills for the Senior Data Architect role as presented.

About Net2Source & Equal Opportunity

Net2Source is an equal opportunity employer, dedicated to fostering a workplace where diverse talents and perspectives are valued. Employment decisions are based on merit, without regard to age, gender, ethnicity, disability, or other protected characteristics.