ETL Developer in Durham, NC at DISYS

Date Posted: 2/5/2018

Job Snapshot

  • Employee Type:
    Full-Time
  • Location:
    Durham, NC
  • Job Type:
    Other
  • Experience:
    Not Specified
  • Date Posted:
    2/5/2018

Job Description


BHJOB8895_107536  Title: ETL Developer
Location: Durham, NC
Term: direct hire:
Salary: $83k to $93k, DOE

**This is a direct hire opportunity, please no third party candidates.**

DISYS is seeking an ETL Developer with strong SQL skills to support our client’s research informatics team.
The ideal candidate will have a passion for data science and exposure or experience with Big Data, preferably Hadoop.  Skills in Python, R, SAS, Tableau and other analysis tools are also a plus.

This is a direct hire opportunity with a solid organization known for their employees’ longevity and stellar benefits, including holidays, retirement, and health.

This position will be responsible for implementing ETL design and development on clinical research software programs.  The ETL Developer will work closely with members of the analytics group and team members to understand all project requirements that encompass the ETL realm, as well as contribute to solution development. 
 
Responsibilities

  • Design and document ETL process for new DW subject areas
  • Create data extraction, cleansing and load programs to move data into and out of the Data Warehouse
  • Work with Agile team members to document and execute test plans for data loading and data validation scripts. Support the code promotion process through development and production as required. 
  • Develop, implement and maintain schedule/dependency logic for automated ETL processing.  Develop monitoring, logging, and error notification processes to ensure data is updated as expected and processing metrics reported. 
  • Participate in the creation and maintenance of standards for coding, documentation, error handling, error notification, logging, etc. 
  • Accountable for conforming to established architectural, developmental, and operational standards and practices including creation of ETL metadata.
  • Work with other team members in establishing and sharing design and development techniques of the ETL process.
  • Work heavily in SQL.
  • Work with analytics and big data tools including Python, R, SAS, Tableau and Hadoop.
  • Evaluate and recommend database development tools
  • Assist in application and database performance tuning
  • Participate in system architecture design
  • Implement integration and interface tools between transactional and data warehousing systems
  • Work with Quality Assurance to assist with unit and integrated testing.
  • Share trouble-shooting and maintenance duties 

Experience

  • Excellent analytical skills required. 
  • Previous experience with data warehousing systems design and development a plus. 
  • Previous experience with data modeling required.  
  • In depth knowledge and experience with ETL development and applying sound ETL techniques and modular system design skills are essential. 
  • 5 years’ experience in SQL, database programming and utilities 
  • Experience with analytical tools including Python, R, SAS, Tableau, etc.
  • Exposure or experience with Big Data, preferably Hadoop.
  • Experience with developing sound technical documentation is required. 
  • Ability to identify and resolve data quality issues within the ETL realm. 
  • Understanding of and experience with basic DBA skills such as, physical modeling, table partitioning and indexing is required.
  • Knowledge and experience in relational and dimensional database design techniques.
  • Experience developing applications in Windows and UNIX operating environments.

Preferred Tools

  • Oracle
  • PL/SQL, Perl, UNIX 
  • SSIS experience 
  • Experience within the Health Care realm 

Digital Intelligence Systems, LLC. is an Equal Opportunity Employer, M/F/D/V. We do not discriminate against any employee or applicant because they inquired about, discussed, or disclosed compensation. Email recruitinghelp @ disys.com to contact us if you are an individual with a disability and require accommodation in the application process.