Senior Alteryx Developer
at Adventist Health System

Date Posted: 5/4/2017

Job Description



Job:  Information Technology

Organization:  Adventist IT

Shift:  Day

Job Posting:  Nov 3, 2016, 8:21:57 AM

Adventist Health System (AHS) is making big stride in the Healthcare analytics arena. In order to remain ahead of the curve we are looking for innovative and committed individuals. Our goal is to provide data driven direction by providing analytical solutions and information tools to clinicians and hospital leadership in order to improve outcomes.


We are currently hiring a Senior-level Alteryx Developer with experience in data acquisition/extraction and data blending geared towards but not limited to the Healthcare Industry. We are looking for individuals passionate about data analytics and interested in working with the latest developments surrounding various Business Intelligence/Self-Service Analytical tools that help to support enhanced decision making and improve patient outcomes. The developer under the direction of the Manger of Business Analytics will be responsible for researching and extracting pertinent data points within multiple source systems while developing analytical reporting solutions for our various clients.


PRINCIPAL DUTIES AND JOB RESPONSIBILITIES:

• Design and develop ETL workflows and datasets in Alteryx to be used by the BI reporting tool (*** Not traditional ETL development to write database tables. ETL specific for creating datasets (Tableau Data Extract/ Qlikview Dataset for BI tools)

• Will write SQL queries with multiple joins against oracle database and automate/manipulate these extracts in Alteryx

• Works in partnership with the DW team and other stakeholders concerning the accuracy of data and efficiency of processes

• Prepare technical specifications and documentation for Alteryx workflows supporting BI reports.

• Perform end to end Data validation to maintain accuracy of data sets

• Lead discussions with business partners to identify functional requirements resulting in data acquisition for BI applications

• Translate business logic from one system (Excel, SQL, etc) into Alteryx in a quick and accurate manner

• Develop re-useable processes that can be leveraged and standardized for multiple instances

• Understanding the star schema and data models in the existing data warehouse.

• Ensure application stability and performance by monitoring existing workflows to ensure they are working correctly and that they reconcile with the source.

• Provide ad-hoc data analysis and support to business functions.

Job Requirements

KNOWLEDGE AND SKILLS REQUIRED:


• Advanced knowledge of SQL, database technologies and data warehouse design philosophies

• Advanced skills with Microsoft Office Suite with emphasis on Excel

• Ability to effectively prioritize and execute tasks

• Strong analytical, problem solving, and troubleshooting abilities

• Advanced knowledge of self-service analytic/ETL tools, specifically Alteryx Designer and QlikView

• Ability to follow detailed procedures and ensure accuracy in documentation and data


KNOWLEDGE AND SKILLS PREFERRED:

• Knowledge of using predictive analytics tools such as R or SAS

• Working knowledge of clinical processes and terminology

• Competency of BI tools (QlikView, Tableau)

• Highly proficient in Microsoft Excel to analyze data and report results using pivot tables, charts and graphs



EDUCATION AND EXPERIENCE REQUIRED:


• Bachelor’s degree in Computer Science, Management Information Systems, Informatics or similar analytical field

• Minimum 3 - 5 years of related experience with Alteryx or similar (Talend, Pentaho) data extraction and manipulation tool.

• Minimum 3 - 5 years writing SQL queries against any RDBMS with query optimization.

• Ability to gather and document business requirements.

• Minimum 3 - 5 years of experience in working with relational database systems OR Master’s degree in a field mentioned above with 2-3 years of experience


EDUCATION AND EXPERIENCE PREFERRED:

• Master’s degree in any of the fields mentioned above

• 5+ Years of experience in working with Healthcare relational database systems

• Experience in building, publishing and managing reports/dashboards leveraging QlikView or any other BI tool (Ex. Tableau)

• Experience with HiveQL or Big Data

Job Snapshot

About Us

About Adventist Health System

Who We Are

We are one of the largest faith-based health care providers in the United States. For 150 years, we have carried on a tradition of providing whole-person care that not only addresses patients' physical ailments, but also supports their emotional and spiritual well-being. We demonstrate the same level of compassion and care for our employees as well, doing all that we can to help them realize their full potential – both personally and professionally.

Who You Are

You are a compassionate, talented professional who wants to work in an environment where you can live out your faith and your values. You are excited about being part of a team that uses the latest technology and medical research to ensure patients receive quality care, but who also recognize that great care is always personal. You enjoy going out of your way to make each patient and their family feel special, and are passionate about guiding them toward optimal health.

Our Community

Our community is global and so is our reach. From coordinating medical mission trips in Ethiopia to planting school gardens in Florida, we are constantly seeking ways to go beyond hospital walls in improving the health of our communities. As a member of our team, you will be encouraged to use your talents in fun, meaningful ways that bring joy and healing to people around the world.

Our Mission

Part of this worldwide network, Adventist Health System was founded in 1973 to support and strengthen the Seventh-day Adventist health care organizations in the Southern and Southwestern regions of the United States. Today it is a national leader in quality, safety and patient satisfaction, comprised of 46 hospital campuses and nearly 77,000 employees.

Although separated by geography, each of our facilities is united by the mission of Extending the Healing Ministry of Christ. Today we continue the tradition of whole-person care by practicing and sharing CREATION Health, a blueprint for living a healthy, happy life based on the principles given in the Bible’s creation story: Choice, Rest, Environment, Activity, Trust, Interpersonal relationships, Outlook and Nutrition.

We provide comprehensive benefits, training and advancement opportunities. We care for our employees as well as we care for our patients.