Practice made perfect

Join Our Talent Network

Senior Data Engineer in Knoxville, Tennessee, US at TeamHealth

Date Posted: 1/6/2020

Job Snapshot

Job Description

JOB DESCRIPTION OVERVIEW:

The Sr Data Engineer is responsible for the development and implementation of technical solutions. This role leverages technical expertise in database applications, ETL processes, and automation in support of internal and external customers data exchange and integration needs.

The Sr Data Engineer will use smart technology to empower TeamHealth stakeholders enterprise-wide to make the best decisions based on timely, accurate and actionable information. Must enjoy working with SQL and Big Data Technologies. The Sr Data Engineer will have the chance to work with the best data and massively parallel processing databases to speed analyses, with broad exposure to the workings of TeamHealth and critical thinking to tackle complex challenges. When other teams need to know about providers, productivity, performance, or other data insights, they count on our Data & Analytics team.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

  • Develop ETL processes for data warehousing, data integration and data analytics
  • Designing and developing enterprise-wide ETL solutions for BI reporting
  • Reviewing and analyzing data from multiple internal and external sources
  • Identify opportunities for efficiencies and innovative approaches to completing scope of work
  • Defining relevant ETL standards, processes, and best practices
  • Designing, developing and maintaining ETL solutions
  • Participate in team problem solving efforts and offer ideas to solve client issues
  • Effectively communicate with business and technology partners, peers and stakeholders
  • Ability to deliver results under demanding timelines to real-world business problems
  • Ability to work independently and multi-task effectively

 

 

Job Requirements

Required qualifications to be successful in this role:

  • 6+ years as an ETL/SQL developer with strong analytical skills
  • Strong SQL skills with ability to write complex queries, CTEs (Common Table Expressions), stored procedures and functions
  • Deep understanding of database concepts
  • Knowledge in data warehouse and data modelling concepts
  • Strong experience with ETL development, preferably SSIS (Sql server integration services)
  • Ability to create transformations and mappings with minimal supervision
  • Experience in scheduling SSIS batch jobs using SQL server Agent
  • Experience with integration services catalog and package configuration
  • Ability to troubleshoot issues in ETL jobs and reports
  • Ability to handle unstructured datasets
  • Strong experience in data cleansing ETL performance tuning
  • Experience with automation and deployment of ETLs
  • Knowledge in using SDKs and APIs in Script tasks
  • Knowledge in SQL performance tuning
  • Adept in metadata management and data lineage
  • Good understanding of the SDLC processes and practices
  • Good verbal and written communication skills
  • Ability to work in a dynamic environment
  • Data governance/standards for heterogeneous data sources integration/conversion

Good to have:

  • Knowledge in designing data warehouse and ETL frameworks
  • Experience in upgrade management in SQL server
  • Experience in reporting tools like MicroStrategy and/or Tableau

Skills:

  • ETL
  • SSIS

PHYSICAL / ENVIRONMENTAL DEMANDS:

  • Job performed in a well-lighted, modern office setting;
  • Occasional lifting/carrying (10 pounds or less);
  • Occasional standing/bending/stooping/reaching;
  • Moderate stress;
  • Prolonged sitting; and
  • Prolonged work at a computer/PC.

DISCLAIMER:

Cooperative, positive, courteous and professional behavior and conduct is an essential function of every position. All employees must be able to work with others beyond giving and receiving instructions. This includes getting along with co-workers, peers and management without exhibiting behavior extremes. Job functions may require personal leadership skills such as conflict resolution, negotiating, instructing, persuading, speaking with others as well as responding appropriately to job performance feedback from the supervisor. Additionally, the information contained in this job description has been designated to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this position.

 

#ZR