Data Warehouse Architect

Design and implement data pipelines and storage solutions within Azure and local SQL Server environments.

Responsibilities

• Build Azure Data Factory pipelines and SQL Server stored procedures to manage data movement and transformation.
• Develop data pipelines that support Data Vault architectures and data marts.
• Code all data processes in accordance with established organizational standards.
• Support and maintain existing data packages on local servers.
• Collaborate with business partners to develop data mapping between systems.

Required Skills

• 5+ years of experience in data warehousing or related roles.
• Extensive experience with Azure Data Factory pipeline development.
• Proficiency in SQL language and SQL Server stored procedure development.
• Proven experience managing and implementing Data Vault architectures.
• Knowledge of HIPAA and PII compliance requirements.
• Experience working with ERP systems.
• Ability to pass CJIS background checks.
• Strong written and verbal communication skills.

Preferred Skills

• Experience with Central Square Finance Enterprise ERP.
• Familiarity with Workday tools and implementation methodologies.