Sr Data Architect @ NYC, NY - Onsite

Relevant Experience : 15+ Years

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.