Myriad Genetics, Inc.

Data Warehouse Engineer

US-UT-Salt Lake City
4 weeks ago
Job ID
2017-6597
Location Details
SLC, UT

Overview

A Data Warehouse Engineer partners with business leaders to understand information needs and provide access to data needed to guide strategic business decisions.  Interacts with all components of the data warehouse, including: writing and troubleshooting ETL, creating data models, reporting, dashboards, administering and supporting the hardware and software, and integration between systems.  Develops overall architecture and high level design, utilizing expertise with star schemas, dimensional models, and data marts.  Performs coding and interacts professionally with a diverse team comprised of both technical and business personnel.  Accurately communicates status and issues within the data warehouse environment (verbal and written).  Prepares documentation, devises testing strategies and analyzes existing systems to present the data in effective ways to business users.

Responsibilities

Working closely with the rest of the Informatics data warehouse team, this candidate will have responsibilities over the following areas:

  • Work with business users to define data flow models and flush out the measures (facts) and dimensions
  • Designs and plans for the integration for all data warehouse technical components
  • Technical implementation of the data warehouse, including data extracts/transforms (ETL)
  • Hardware/ software configuration
  • Reviews technical work of other team members
  • Reviews and participate in testing of the data design, tool design, data extracts/transforms, networks and hardware selections
  • Creates management reports that will be delivered to all levels within the company
  • Develops and modifies the data warehouse components to meet applicable security standards
  • Serve as a subject-matter expert for available data elements and analytic capabilities
  • Integrate multiple data sources in order to define and develop performance dashboards
  • Ensures completeness and compatibility of the technical infrastructure to support system performance, availability and architecture requirements
  • Deals with situations positively. Strives for the best outcome in difficult situations and moves projects to successful completion
  • Develops support plans
  • Provides on-call support

Qualifications

Requirements

  • Professional experience with core Business Intelligence tools (eg. Reporting and Dashboards, ETL, Oracle, MySQL, Vertica, Linux, SQL, JSOJN, XML, and HTML)
  • Candidate should have a minimum of 7 years’ experience in business intelligence arena using industry standard ETL and reporting tools
  • Candidates should know Linux, databases, SQL tools, data warehouse concepts and BI reporting tools.
  • This position is often the “face to the internal customer” when presenting enabling technologies and concepts to the business for the first time.  As such, the candidate must be dynamic, personable, able to communicate clearly both verbally and in written form, and have an ability to convey complex IT concepts at a business level.
  • Experience in relational database concepts with a solid knowledge of database code and scripts

 

 

Preferred:

  • Experience with MicroStrategy and SAP Data Services
  • Experience with web architecture design and Web Services
  • Experience automating tasks with a workflow engine
  • Understands multiple type of databases (i.e. Vertica, Oracle, MySQL, etc)
  • Understanding of data warehouse development lifecycle and process methodologies, including agile experience
  • Ability to communicate with business customers and translate business needs to technical solutions
  • Understands dimensional modeling and data architecture
  • Ability to work with supporting technologies (e.g. Source / version control, Jira, and Confluence)

 

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is frequently required to sit; talk; or hear. The employee is occasionally required to stand; walk; use hands to finger, handle, or feel; reach with hands and arms; and stoop; kneel; or crouch The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision and depth perception.

About Myriad

Myriad Genetics, Inc. (Nasdaq: MYGN) is a leading molecular diagnostic company making a difference in patient’s lives through to discovery and commercialization of transformative molecular diagnostic products that assess a person’s risk of developing disease, improve diagnosis, predict disease progression and guide therapy. We believe in improving the healthcare management of patients by providing physicians and patients with critical information across multiple medical specialties that addresses unmet medical needs. With fiscal year 2015 annual revenue of approximately $700 million and more than 2,000 employees, Myriad is focusing on strategic initiatives, including growing our existing markets, launching new products, and expanding our global presence to take advantage of significant long-term growth opportunities. For more information on Myriad, please visit the Company’s website at: www.myriad.com. Myriad is an equal opportunity employer and as such, affirms in policy and practice to recruit, hire, train and promote, in all job classifications without regard to race, color, religion, gender, age, sexual orientation, gender identity, national origin, disability status or status as a protected veteran.

Reasonable accommodation will be provided for qualified individuals with disabilities and disabled veterans in job application procedures. We believe that diversity lends a regional, national, and global advantage to the clients we serve. Our workforce consists of dynamic individuals, with a range of backgrounds, talents, and skills.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed