Company:
Han IT Staffing
Location: Columbus
Closing Date: 19/10/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Title: Senior Data Architect
Location: Columbus, OH/Buffalo, NY – Day 1 Onsite
Duration: Long Term Contract
Job Description:
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
Location: Columbus, OH/Buffalo, NY – Day 1 Onsite
Duration: Long Term Contract
Job Description:
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
Share this job