Data Warehouse Architect 4

InterSources, Inc.

• $100K — $130K *
Chesterfield, VA 23832In-Person
Information Technology
5 - 7 years of experience
Reposted Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • 5+ years of experience with Azure Data Factory Pipeline development in both Azure and local SQL Server environments.
  • 2+ years of experience with SSIS development for Azure and local SQL Server.
  • Experience with Azure file storage data sources (data lake, blob, hadoop) preferred.
  • Excellent written and verbal communication skills.
  • Self-motivated, independent, and flexible with work hours.
  • Dependable high-speed internet connection for occasional remote work.
  • Ability to pass CJIS background checks.

Responsibilities

  • Create and modify data pipelines using a cloud-based ERP system.
  • Develop and manage Azure Data Factory and SSIS pipelines.
  • Code processes according to company standards for data marts.
  • Synchronize data mart datasets from source systems via file-based extracts.
  • Collaborate with business partners on data mapping from system to system.

Benefits

  • Hybrid work environment with a requirement to work onsite 3 days a week.
  • Opportunity to work with a certified diverse supplier and an award-winning global software consultancy.
  • Employee-first approach that values diversity and inclusion.
  • Commitment to employee training and development opportunities.
  • Potential for reasonable accommodations in the workplace.
Full Job Description
Job Title : Data Warehouse Architect Location: Chesterfield, VA, Hybrid

Rate : Best competitive rate

*Local Richmond area candidates or those willing to relocate to the Richmond area during this engagement due to onsite work requirement *ONSITE interviews only *Candidates must be willing and able to work onsite 3 days/week, NO Exceptions

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

Skill

Required / Desired

Amount

of Experience

Candidate will need to be experienced with Azure Data Factory Pipeline development for both Azure and local Sql Server environments.Required5YearsCandidate will need to be experienced with SSIS development for both Azure and local Sql Server environments.Required2YearsCandidate will ideally have experience with Azure file storage data sources (data lake, blob, hadoop)Highly desired1YearsCandidate will be expected to successfully complete training on HIP nd PIIRequired

Candidate should have excellent communication skills (written and verbal)Required

Candidate will need to be self motivated, independent, and willing to work flexible hours.Required

Candidate will be expected to work from home on occasion and therefore required to have a dependable high speed internet connection.Required

Candidate will be expected to pass CJIS background checks.Required

Candidate will have experience authoring Workday reports and outbound integrationsNice to have

Candidate should be comfortable mentoring other personnel regarding Workday technologies.Nice to have

Ideally, candidate would have experience working with Workday StudioNice to have
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at InterSources, Inc.

More Information Technology Jobs

Find similar Data Warehouse Architect 4 jobs:

NationwideChesterfield, VA