Data Engineer II

Exact Sciences   •  

Madison, WI

Industry: Professional, Scientific & Technical Services


5 - 7 years

Posted 41 days ago

This job is no longer available.

Summary of Major Responsibilities

The Data Engineer II provides technical expertise, enables data analysis, and is an expert of the data generated by business systems. They will contribute to meaningful, effective, and performant data visualizations and reports, and analyze, troubleshoot and tune performance.

Essential Duties and Responsibilities

  • Provide expertise in data management, analysis, and visualizations
  • Partner with analysts and other users of data
  • Develop and share knowledge of advanced reporting, analytics, and dashboarding tools, including Tableau
  • 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
  • Stay informed of technology industry trends and solutions with ability to analyze for possible application in our environment
  • Work with Information Technology management and staff to develop and maintain standards, processes, and documentation
  • Promote the role and capabilities of IT to enhance the professional development of all staff through example, recommendation, and accommodation
  • Work independently with little oversight and direction
  • Special projects as business needs require


Minimum Requirements

  • Bachelor’s degree in Computer Science, Information Systems or related field or equivalent professional experience
  • 5+ 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 Experience

  • 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.