Job Description :
SQL BI Developer

Oak Brook, Illinois

Full Time



Job Descripition :

Performs research and analysis of complex healthcare claims data, pharmacy data, and lab data regarding network utilization and cost containment information. Evaluates, writes, and presents healthcare utilization and cost containment reports and makes recommendations based on relevant findings.

Knowledge/Skills/Abilities:

Develop ad-hoc reports using 9 SQL Server Reporting Services , Medinsight, RxNavigator, Crystal Reports, Executive Dashboard, and other analytic / programming tools as needed.
Generate and distribute standard reports on schedule using SQL, Excel, and other reporting software.
Collects and documents report / programming requirements from requestors to ensure appropriate creation of reports and analyses. Uses peer-to-peer review process and end-user consultation to reduce report writing errors and rework.
Identify and complete report enhancements/fixes; modify reports in response to approved change requests; retain old and new report design for audit trail purposes.
Analyze data sets and trends for anomalies, outliers, trend changes, and opportunities.
Create comprehensive workflows for the production and distribution of assigned reports; document reporting processes and procedures.
Assist with completion of special projects as requested by various internal departments, or in support of requests from regulatory agencies, contracting agencies, or other external organizations.
Demonstrate Healthcare experience in Quantifying, Measuring and Analyzing Financial and Utilization Metrics of Healthcare


Qualifications:

Bachelor''s Degree in Finance, Economics, Math, Computer Science; or equivalent experience

Required Skills :

4-6 years increasingly complex database and data management responsibilities
Basic knowledge of SQL
4-6 years of increasingly complex experience in quantifying, measuring, and analyzing financial/performance management metrics

Preferred Skills:

Preferred experience in Medical Economics and Strong Knowledge of Performance Indicators:
Proactively identify and investigate complex suspect areas regarding medical cost issues
Initiate in-depth analysis of the suspect/problem areas and suggest a corrective action plan
Apply investigative skill and analytical methods to look behind the numbers, assess business impacts, and make recommendations through use of healthcare analytics, predictive modeling, etc.
Analysis and forecasting of trends in medical costs to provide analytic support for finance, pricing and actuarial functions