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