Title: Data warehouse Architect

Work Arrangement: Onsite

Job Description:

We are looking to fill a Long-term Contract role as Datewarehouse Architect in Columbus, Ohio

Mode of Interview: In person

Candidates must create and modify pipelines with a cloud-based Enterprise Resource Planning (ERP) system. The candidate will need experience with Azure Data Factory (ADF) and SQL Server (SSIS) pipelines to manage these pipelines. Candidates will be creating data pipelines that support data marts and will be expected to code processes according to our standards. Candidates will be well-versed in current methodologies for synchronizing data mart datasets from source systems via file-based extracts. Working with the business partners to develop data mapping from one system to another is desirable but not strictly required.

Applicants must have a minimum of 5 years of relevant experience with the following:

• Candidate will need to be experienced with Azure Data Factory Pipeline development for both Azure and local SQL Server environments.
• Candidate will need to be experienced with SSIS development for both Azure and local SQL Server environments.
• Candidate will be expected to complete training on HIPAA and PII successfully
• Candidate should have excellent communication skills (written and verbal)
• Candidate will have experience authoring Workday reports and outbound integrations
• Candidate should be comfortable mentoring other personnel regarding Workday technologies.

Preferred:

• Ideally, candidate would have experience working with Workday Studio
• Candidate will ideally have experience with Azure file storage data sources (data lake, blob, Hadoop)