Senior Data Architect

HAN
Buffalo, NY
Full-time

Role : Senior Data Architect

Location : Columbus, OH / Buffalo, NY (Day On-site All days' Work from Office)

Type of Hire - Contract / CH

Contract / CH

Duration : Long Term Contract

Position requirements

On-site (No Remote option)

Job Description

Relevant Experience : + 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..
  • 30+ days ago
Related jobs
Promoted
VirtualVocations
Buffalo, New York

A company is looking for a Senior Azure Data Architect/Engineer. ...

PricewaterhouseCoopers Advisory Services LLC
Buffalo, New York
Remote

As a Senior Manager, you'll work as part of a team of problem solvers, helping to solve complex business issues from strategy to execution. Leading SAP SuccessFactors data migration implementations including from SAP HCM to SAP SuccessFactors;. ...

Promoted
VirtualVocations
Buffalo, New York

A company is looking for a Senior Data Architect to design and implement enterprise-wide data strategies that align with business goals. ...

Net2Source
Buffalo, New York

Lead the design and implementation of robust data architectures to support business needs and data strategy. Collaborate with senior management to align data architecture goals with organizational strategies and priorities. Utilize extensive experience in Azure Synapse, Python, PySpark, and ADF to a...

Han IT Staffing
Buffalo, New York

Lead the design and implementation of robust data architectures to support business needs and data strategy. Collaborate with senior management to align data architecture goals with organizational strategies and priorities. Utilize extensive experience in Azure Synapse, Python, PySpark, and ADF to a...

Squarespace
New York, US

Squarespace is looking for a Senior Data Architect to join the Data Platform Group. Data Platform is focused on building interoperable software, datasets & processes to provide relevant data-driven insights to our internal & external customers. Architect, build & maintain efficient data models (Conc...

HAN
Buffalo, New York

Lead the design and implementation of robust data architectures to support business needs and data strategy. Collaborate with senior management to align data architecture goals with organizational strategies and priorities. Utilize extensive experience in Azure Synapse, Python, PySpark, and ADF to a...

Promoted
VirtualVocations
Buffalo, New York

A company is looking for a Lead Android Software Architect to guide the technical direction of a multimodal biometric system. ...

JMS Technical Solutions, Inc.
Buffalo, New York

Our partner in Buffalo is growing and adding a Project Architect to their team! Our partner is seeking an experienced Project Architect who is passionate about design and wants to be part of an exciting and supportive environment. Oversee all phases of architectural projects, from initial concept to...

Lyons Consulting Group
New York, US

Review business requirements documentation, technical design documentation and participate in peer reviews with project's technical architects. Salesforce Technical Architect- Salesforce Consumer goods cloud-. Participate in Design Authority meetings and provide recommendations to Salesforce's Well ...