Data Warehouse Architect

The Data Warehouse Architect 2 is responsible for managing data mapping between legacy systems and new systems, ensuring seamless data migration and integration. This role requires a high level of attention to detail and the ability to manage complex tasks. The ideal candidate will be proficient in Azure Data Factory Pipelines and SQL Server (specifically stored procedures or SSIS packages) and may also be required to support or create packages on local servers.

• Data Mapping:
  Work closely with business partners to develop data mapping strategies from legacy systems to new systems.
• Data Integration:
  Ensure smooth integration and migration of data across various platforms.
• Pipeline Development:
  Utilize Azure Data Factory Pipelines to create, maintain, and optimize data flows.
• SQL Server & SSIS Support:
  Develop and manage SQL Server stored procedures and SSIS packages to handle data processes.
• Package Management:
  Assist in creating or supporting packages on local servers as needed.
• Collaboration:
  
  Communicate effectively with stakeholders to ensure alignment and proper execution of data migration tasks.
• Quality Assurance:
  Maintain a focus on quality, ensuring that all data mappings are accurate and complete.

• Azure Data Factory:
  Expertise in building, managing, and optimizing data pipelines.
• Data Mapping:
  Experience with managing and creating data mapping between systems.
• SQL Server:
  Proficient in writing and optimizing stored procedures and SSIS packages.

• Experience:
  
  Proven experience working with Azure Data Factory and SQL Server.
• Attention to Detail:
  Strong focus on accuracy and thoroughness in managing data migration tasks.
• Problem-Solving
  
  Skills:
  
  Ability to troubleshoot issues and provide solutions for complex data integration challenges.
• Communication
  
  Skills:
  
  Strong ability to communicate technical concepts to both technical and non-technical stakeholders.