Come join Workfront, one of the hottest companies in cloud computing as recognized by Forbes magazine!  Located in the heart of Silicon Slopes, Workfront is the leader in enterprise work and project management.  Meeting our mission to become the authoritative source for work, hundreds of thousands of enterprise users leverage Workfront’s SaaS solution to make their work faster and more efficient taking projects to a higher level.

As part of the Analytics/BI team, the Data Engineer helps leaders and analysts throughout the organization get the data they need to further accelerate our growth. The team helps the business define analytics needs and translates that into actionable data models that are both robust and easy for business users to understand. This position will work closely with business groups to understand and solve problems and questions that will help them understand our business and contribute to a data driven culture. Our data engineers build clean and easy to understand data models that the rest of the business can use to provide insights.

Job Responsibilities

  • Work with business stakeholders to understand analytics needs and architect solid data models which will provide the insights they need
  • Improve overall robustness and efficiency of existing data marts
  • Design and build robust data models in Redshift which combine multiple data sources
  • Build data models that are easy to use and understand by business stakeholders
  • Clearly document and demonstrate the functionality and power of data models to the business
  • Provide accurate and actionable data to the organization

Experience

  • Expert SQL programmer
  • At least 4 - 5 years designing and building actionable data models for use in Business Intelligence tools
  • Strong understanding of star schema and Kimball methodology
  • Experience building slowly changing dimensions
  • Working knowledge of code repositories (preferrably Git)
  • Transforming data to meet business needs
  • Exposure to Tableau, Power BI, Clik, Quicksight, or other BI tools
  • Strong experience working with multiple business groups to meet their analytics needs
  • Experience validating and performing quality assurance on data as it flows from the sources to data models and visualizations

Bonus Skills

  • Experience with AWS Redshift, Vertica, Greenplum, Netezza, or other MPP databases
  • Past experience building sales funnel and marketing attribution data models
  • Understanding of Salesforce, Marketo, Netsuite, and other enterprise systems