Data Engineer

Exact Sciences   •  

Madison, WI

Industry: Professional, Scientific & Technical Services

  •  

Less than 5 years

Posted 142 days ago

This job is no longer available.

Summary of Major Responsibilities

The Data Engineer is responsible for developing and automating data pipelines, cleaning and preparing data, and debugging data issues. They are responsible for monitoring production data sources, resolving issues, and improving system performance. Being knowledgeable of the data generated by business systems, they are a technical resource for analysts and other users of data.

Essential Duties and Responsibilities

  • Offer assistance and expertise in troubleshooting and resolving data issues
  • Serve as a primary point of contact for production support issue resolution
  • Develop and automate data pipelines
  • Clean and prep data
  • Debug data issues in dashboards, reports, data warehouses, operational data stores, and other disparate data sources
  • Improve monitoring, automated testing, and deployments
  • Be a resource for providing insight, recommendations, and assistance with technical and non-technical questions
  • Monitor and recommend enhancements to the technical architecture to keep pace with changing business demands and scale
  • Lead efforts to analyze, troubleshoot and tune solution performance or deployment issues when required
  • Act as a resource for staff by providing insight, recommendations, and assistance with technical and non-technical questions
  • Promote the role and capabilities of IT to enhance the professional development of all Exact Sciences staff through example, recommendation, and accommodation

Qualifications

Minimum Requirements

  • Bachelor’s degree in Computer Science, Information Systems or related field or equivalent professional experience
  • 2+ years of experience querying disparate data sources, including relational structures, OLTP systems, and dimensional data models
  • Experience working with SQL for data exploration, debugging, and performant data access
  • Experience designing and developing reports, dashboards, and visualizations, preferably including with Tableau
  • Ability to translate business requirements to technical specifications
  • Proven ability to work in a fast-paced, cross-functional team environment
  • Adaptable, open to change and able to work in ambiguous situations and respond to new information or unexpected circumstances
  • Excellent interpersonal and communication skills, ability to operate in a cross cultural and complex matrix environment, and ability to build consensus across functions

Desired Characteristics

  • Python
  • AWS
  • Microsoft EDW/BI/OLAP technologies: SQL Server, SSRS, SSIS
  • ETL
  • Developing dashboards and reports on data from sales, call center, and custom software applications
  • Tableau, ideally including performance optimization

Physical Requirements

  • Ability to work in an office setting, operate telephony devices, and a computer

2018-3074