Back to Job Search

Teradata Data Engineer

  • Location: Durham, North Carolina, 27707
  • Job Type:Contract

Posted about 1 month ago

Our Healthcare Insurance client is seeking a Teradata Data Engineer to join their team for a contract role. 

Our client has more than 5,000 employees and is the number 1 health insurer in the state of North Carolina serving more than 3.89 million customers.  Our client's goal is to provide innovative solutions that simplify the health care system, improve efficiency and outcomes, and help rein in costs

Position: Teradata Data Engineer
Location: Durham, NC (remote until summer 2021)
Term: 3 months 
Day-to-Day Responsibilities:

The Data Engineer will work closely with senior engineers, data scientists and other stakeholders to design and maintain moderate to advanced data models. The Data Engineer is responsible for developing and supporting advanced reports that provide accurate and timely data for internal and external clients. The Data Engineer will design and grow a data infrastructure that powers our ability to make timely and data-driven decisions.

  • Extract data from multiple sources, integrate disparate data into a common data model, and integrate data into a target database, application, or file using efficient programming processes
  • Document, and test moderate data systems that bring together data from disparate sources, making it available to data scientists, and other users using scripting and/or programming languages
  • Write and refine code to ensure performance and reliability of data extraction and processing
  • Participate in requirements gathering sessions with business and technical staff to distill technical requirement from business requests
  • Develop SQL queries to extract data for analysis and model construction
  • Own delivery of moderately sized data engineering projects
  • Define and implement integrated data models, allowing integration of data from multiple sources
  • Design and develop scalable, efficient data pipeline processes to handle data ingestion, cleansing, transformation, integration, and validation required to provide access to prepared data sets to analysts and data scientists
  • Ensure performance and reliability of data processes
  • Define and implement data stores based on system requirements and consumer requirements
  • Document and test data processes including performance of through data validation and verification
  • Collaborate with cross functional team to resolve data quality and operational issues and ensure timely delivery of products
  • Develop and implement scripts for database and data process maintenance, monitoring, and performance tuning
  • Analyze and evaluate databases in order to identify and recommend improvements and optimization
  • Design eye-catching visualizations to convey information to users

Is this a fit? (Requirements): 

  • Bachelors degree in Computer Science or related field or equivalent experience
  • Teradata and ETL
  • 3 years of SQL programming skills (Intermediate to Advance SQL programming skills)
  • Demonstrated experience working with large and complex data sets
  • Hadoop, Hive, Spark, Python

Hiring Preferences: 

  • Experience with query and process optimization
  • Experience working in AWS and/or using Linux based systems
  • Ability to translate task/business requirements into written technical requirements
  • Reliable task estimation skills
  • Excellent quantitative, problem solving and analytic skills
  • Ability to document data pipeline architecture and design
  • Ability to collaborate effectively with business stakeholders, performance consultants, data scientists, and other data engineers
  • Proficient in use of MS Office applications including expert level Excel programming
  • Ability to quickly become an expert in operational processes and data of lines of business
  • Ability to troubleshoot and document findings and recommendations
  • Ability to communicate risks, problems, and updates to leadership
  • Ability to keep up with a rapidly evolving technology space