Myriad Genetics Laboratories Data Warehouse Engineer in SALT LAKE CITY, Utah

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. ResponsibilitiesWorking 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 dimensionsDesigns and plans for the integration for all data warehouse technical componentsTechnical implementation of the data warehouse,including data extracts-transforms (ETL)Hardware- software configurationCreates management reports that will be delivered to all levels within the companyDevelops and modifies the data warehouse components to meet applicable security standardsServe as a subject-matter expert for available data elements and analytic capabilitiesDevelops support plansProvides on-call support RequirementsProfessional 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 toolsCandidates 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 ServicesExperience with web architecture design and Web ServicesExperience automating tasks with a workflow engineUnderstands multiple type of databases (i.e. Vertica,Oracle,MySQL,etc)Understanding of data warehouse development lifecycle and process methodologies,including agile experienceAbility to communicate with business customers and translate business needs to technical solutionsUnderstands dimensional modeling and data architectureAbility 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. PI99781677