**ONSITE REQUIRED – NO EXCEPTIONS**
136920-THIS IS A CONTRACT TO HIRE ROLE. Candidates must be willing and able to convert to an FTE role.

Must have SSMS DBA skills, Tableau and Clarity (data models – not data ware house) certs and work experience

Experience Level:  6-10 Years.

Minimum Education:  Bachelor’s degree

Minimum Experience: Six (6) years of relevant experience REQUIRED
- Data Consultant that provides Clarity development and Production Support of Clarity Reports for the Revenue Cycle Department. 
-  report development in Teradata and Oracle Exadata, providing product support to Business partners including: - issue resolution, root cause analysis, ensuring reports process timely and accurately, and developing new reports.  

Required Education and Experience: - 
• 7+ years providing support in a technical environment, prefer reporting support environment.
• 5+ years experience with writing reports from relational databases 
• 5+ years experience with report development utilizing reporting tools 
• 3+ years experience with Epic/Clarity module (working with Clarity data model.)
• 3+ years experience with SQL Oracle
MUST HAVE
1. SSMS experience: creating stored procedures, maintaining and monitoring jobs, troubleshooting
2. SQL skills specifically for Oracle/Exadata databases

Preferred Experience: 
1. Epic Clarity certification in HB or PB, ideally both modules
• T-SQL, Teradata, Oracle Exadata, MS Access, Visual Basic
• Advanced MS Excel skills, experience with MS SQL Stack (SSMS, SSIS, SSAS), and building reports and dashboards inTableau.
• Knowledge of Microsoft Office Suite products including Word, Powerpoint, Visio.  
• Knowledge of Healthcare systems for Clinical Care, Practice Management- Experience with developing web content. - Experience working in large corporations. 
TABLEAU AND CLARITY

Description:
We are looking for a talented SQL Programmer with advanced Excel and some Tableau experience to join our team.
The SQL Programmer should have a minimum of three years of programming in SQL Oracle.
This individual should be able to clearly and logically translate internal client needs and issues into reporting that provides useful insight into how we can better serve our members.
The ideal candidate will have experience working with large health care datasets. 

• Top 3-5 Daily Responsibilities:
1. Develops reports with accurate, easy to read, useful information.
2. Translates needs, issues, and ideas into effective strategies and action plans.

• Top 3-5 Required Skills:
1. Experience with analytical manipulation and interpretation of large databases required.
2. Broad familiarity with medical practices, especially revenue cycle management and process and outcomes measurement preferred.
3. Very strong analytic and critical thinking skills, writing skills, communication skills, consulting skills, and ability to work within a team.
4. Must be an independent self-starter.
5. Clarity Data Model Certifications or Proficiencies in Resolute Hospital Billing, Resolute Professional Billing. Other modules preferred but not required – ADT & Prelude.
• Desired Skills:
1. Ability to express complex analytical and technical information to senior management or to audiences with clinical training.
2. Three (3) years programming in SQL Oracle.
3. Advanced Excel.
4. Experience building reports and dashboards in Tableau. 
• Soft Skills:
1. Three (3) years of related analytical consulting experience, healthcare experience preferred.

Position Description:
Advises and recommends areas of program planning, business management, budget execution and program coordination.
Prepares needs assessment.
Validates resource requirements and develops cost estimate models.
Conducts and coordinates financial, product, market, operational, and related research to support strategic and business planning within the various departments and programs of the client group.
Interprets, evaluates, and interrelates research data, and develops integrated business analyses and projections for incorporation into strategic decision-making.
Plans and coordinates the development of primary and secondary market research studies in support of strategic planning and specific marketing initiatives, as required, and presents findings of studies to client committees.
Provides consultative, technical, and staff support, as appropriate.


Skill Set:
Knowledge of project management principles, practices, techniques, and tools.
Knowledge and appreciation of business concepts and requirements as applicable to a large academic, research, and/or health care facility. Knowledge and understanding of business research principles, processes, and techniques.
Ability to develop and prepare business analyses and plans.
Ability to develop and deliver presentations.
Knowledge of the principles of strategic business decision-making.
Ability to process computer data and to format and generate reports.
Ability to create, compose, and edit written materials.
Consultative and advisory skills.
Skill in the use of survey and market research methodologies, systems, and techniques.
Skill in the use of computerized spreadsheet, relational database, and word processing software