Description

You will design and build data pipelines to support data vaults and data marts within an enterprise data warehouse environment.

Responsibilities

• Create Azure Data Factory pipelines and SQL Server stored procedures to manage data within Azure SQL Server databases.
• Develop and maintain data pipelines following established coding standards.
• Support and create packages on local servers as required.
• Collaborate with business partners to develop data mapping between systems.

Required Skills

• 10+ years of experience coding in SQL.
• 5+ years of experience in Azure Data Factory pipeline development for both Azure and local SQL Server environments.
• 2+ years of experience managing Data Vaults.
• Ability to complete required training on HIPAA and PII.
• Must pass CJIS background checks.
• Strong written and verbal communication skills.
• Ability to work onsite in Richmond/Chesterfield, VA, 3 days per week.
• Self-motivated and able to work independently with flexible hours.

Preferred Skills

• Experience working with Central Square Finance Enterprise ERP.
• Experience with Workday tools and implementation methodology.

Key Skills

Education

Any Graduate