Randstad Data Architect (ETL) in Greenville, North Carolina

Data Architect (ETL)

job details:

  • location:Greenville, NC

  • date posted:Wednesday, January 2, 2019

  • job type:Permanent

  • industry:Professional, Scientific, and Technical Services

  • reference:662905

job description

Data Architect (ETL)

job summary:

Direct Hire with good compensation and benefits, including relocation package. This is a highly visible position where you will play a major role in the oversight of the Data Architecture for a leading healthcare organization.

The Data Architect is responsible for designing and implementing the data architecture for THE next generation Data Ecosystem. Specifically, this includes being responsible for developing normalized, dimensional, and hybrid data models to support reporting, analytics, and API's used by other internal and external applications.

Please forward your resume directly to jimi.silverlain@randstadusa.com. As a qualified applicant I will respond to you same business day.

location: Greenville, North Carolina

job type: Permanent

work hours: 8 to 5

education: Bachelors

responsibilities:

You will serve as the primary data modeler and provide oversight of the following areas:

  • Data Ingestion - moving source system data to a unified data lake

  • Data Modeling - determining field-level data usage

  • Data Wrangling - identifying queries/algorithms to efficiently transform data from source system formats to a unified RDBMS schema

  • Data Quality - ensuring complete and uninterrupted data mappings from source to canonical form

qualifications:

REQUIREMENTS

  • Bachelors degree and experience in the Healthcare/Health, Financial, Banking, or Insurance domains with good understanding of HIPAA data Privacy and Security requirements is preferred

  • One or more of the following certification highly preferred: Epic Clarity, Microsoft Data Management and Analytics, BI Development, Database Development, or Informatica

  • 7+ years experience in an ETL administration or ETL / Application Development environment

  • Proficient in both SSIS or Informatica ETL tools

PREFERRED REQUIREMENTS

  • SQL Server development - T-SQL / Stored Procedures

  • Microsoft SSIS or Informatica Power Center ETL programming

  • SME

  • Hands on experience with ANY of the following the Epic Clarity supplied cubes, Excel spreadsheets, OR Business Objects universes

  • Informatica Power Center

  • Informatica Analyst and or IDQ

  • Oracle SQL, PL/SQL

  • Data modeling

  • ER/Studio

  • Familiarity with the data vault methodology

skills:

  • Experience working with project teams to design and implement new solution, and working in team-oriented, collaborative environment

  • Able to hit the ground running without supervision

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.