Data Warehouse Architect 4 (Hybrid)

Serigor - Chesterfield, VA

Full-time

Remote - Chesterfield, VA

Professional, Scientific, and Technical Services

About the position

The Data Warehouse Architect 4 (Hybrid) role involves designing and implementing data pipelines using Azure Data Factory and SQL Server. The candidate will be responsible for creating and managing data vaults and data marts, ensuring adherence to coding standards, and collaborating with business partners for data mapping. This position requires a strong background in data architecture and pipeline development, with a focus on Azure technologies.

Responsibilities

• Create Azure Data Factory Pipelines and SQL Server stored procedures to manage data in Azure SQL Server databases.
• Develop data pipelines that support data vaults and data marts according to established standards.
• Collaborate with business partners to develop data mapping from one system to another.
• Support the creation or maintenance of packages on local servers as needed.

Requirements

• 5 years of experience with Azure Data Factory Pipeline development for both Azure and local SQL Server environments.
• 2 years of experience managing data vaults.
• 10 years of experience coding in SQL language.
• Successful completion of training on HIPAA and PII is required.
• Excellent written and verbal communication skills are essential.
• Self-motivated and independent with a willingness to work flexible hours.
• Dependable high-speed internet connection for remote work is required.
• Ability to pass CJIS background checks.

Nice-to-haves

• Experience working with the Central Square Finance Enterprise ERP is highly desired.
• Experience with Workday tools and implementation methodology is highly desired.