Senior Data Architect

Senior Data Architect

Columbus OH/Buffalo NY (Day 1 Onsite All 5 days Work from Office)

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 handson experience with Azure DevOps (ADO) and familiarity with version control concepts like cherrypicking and checking/merging code.
• Troubleshoot and debug complex issues in ADF/Synapse Pipelines SQL Agent Jobs SSIS packages and TSQL queries providing expertlevel 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 teamoriented 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..

dATA aRCHITECT