Randstad Data Architect (ETL) in Greenville, North Carolina
Data Architect (ETL)
date posted:Wednesday, January 2, 2019
industry:Professional, Scientific, and Technical Services
Data Architect (ETL)
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 firstname.lastname@example.org. As a qualified applicant I will respond to you same business day.
location: Greenville, North Carolina
job type: Permanent
work hours: 8 to 5
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
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
SQL Server development - T-SQL / Stored Procedures
Microsoft SSIS or Informatica Power Center ETL programming
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
Familiarity with the data vault methodology
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.