Description

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

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.

Responsibilities

• Build Azure Data Factory pipelines for data movement and transformation.
• Develop SQL Server stored procedures and Data Vault architectures.
• Maintain existing data packages on local servers.
• Collaborate with business partners on system data mapping.
• Ensure compliance with HIPAA, PII, and CJIS standards.

Required Skills

• 5+ years of experience in data warehousing.
• Extensive experience with Azure Data Factory pipeline development.
• Proficiency in SQL 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.

Preferred Skills

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

Key Skills

Education

ANY GRADUATE