Job Role :: Senior Data Architect – Columbus, OH/Buffalo, NY (Locals Preferred)

Relevant Experience: 12+ 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..
 
 
 

To unsubscribe from future emails or to update your email preferences click here

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Most Voted
Newest Oldest
Inline Feedbacks
View all comments