Lorven Technologies
Senior Data Architect
Lorven Technologies, Columbus, Ohio, United States, 43224
Role: Senior Data Architect
Location: Columbus, OH/Buffalo, NY (Day 1 On-site - All 5 days' Work from Office)
We are looking for a solid Data Architect with excellent experience in Azure & SSIS.
- Architecture designing background.
Relevant Experience:
15+ 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..
Location: Columbus, OH/Buffalo, NY (Day 1 On-site - All 5 days' Work from Office)
We are looking for a solid Data Architect with excellent experience in Azure & SSIS.
- Architecture designing background.
Relevant Experience:
15+ 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..