Talent.com
Revenue Cycle Database AdministratorReporting Analyst
Revenue Cycle Database AdministratorReporting AnalystKeystone Advisors • Chicago, Illinois, USA
Revenue Cycle Database AdministratorReporting Analyst

Revenue Cycle Database AdministratorReporting Analyst

Keystone Advisors • Chicago, Illinois, USA
[job_card.variable_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

Keystone Advisors is looking for a Revenue Cycle Database Administrator / Reporting Analyst to support one of our healthcare clients in the Illinois Medical District in the West Loop of Chicago.

This is a 100% Remote position but the client prefers that candidates lives within the Chicagoland area.

Summary :

The Revenue Cycle Database Administrator / Reporting Analyst will be responsible for the configuration maintenance and performance of the Revenue Cycle critical SQL Server database environments.

This role is also a key developer for our Business Intelligence (BI) content focusing on end-to-end report and dashboard delivery using SQL Server Reporting Services (SSRS) and Tableau Desktop for the Revenue Cycle.

Typical Duties :

Core Database Administration (SQL Server & SSMS)

  • Maintenance & Operations : Install configure and maintain Microsoft SQL Server instances (including upgrades and patching).
  • Performance Tuning : Proactively monitor and tune database performance including query optimization index management and overall server health using SSMS tools.
  • Security : Manage database security user access permissions and roles in compliance with organizational policies.
  • Data Integrity & Availability : Design implement and test robust backup / recovery strategies and manage High Availability (HA) / Disaster Recovery (DR) solutions.

Business Intelligence & Data Management (Tableau & SSRS)

  • Report & Dashboard Creation : Design develop and deploy complex reports using SSRS and interactive dashboards / workbooks using Tableau Desktop.
  • Data Sourcing & Modeling : Write and optimize complex T-SQL queries stored procedures and views within SSMS to serve as high-performance data sources for both SSRS and Tableau.
  • Tableau Data Connections :
  • Establish manage and optimize data connections from SQL Server to Tableau including live connections and extract configurations.
  • Manage and schedule data extracts ensuring efficient refresh cycles and connection reliability.
  • Data Validation and Reconciliation (Daily Balancing) :
  • Implement monitor and maintain scheduled checks to ensure daily balancing of data.
  • This involves rigorous data validation and reconciliation processes to confirm that the data copied extracted or loaded into the BI systems (e.g. Tableau extracts) exactly matches the original source data in the SQL Server environment.
  • Troubleshoot and resolve data discrepancies identified during the balancing process promptly.
  • BI Content Management : Manage and configure the SSRS Report Server and deploy / publish Tableau Workbooks to the Tableau Server managing report and dashboard permissions and subscriptions.

    • Performance & Optimization

  • Tune T-SQL queries and optimize database structures specifically for BI workloads focusing on fast data retrieval for reports and dashboards.
  • Collaborate with Data Analysts and Developers to optimize Tableau Workbooks and SSRS reports for user experience and performance.

    • Minimum Qualifications :

  • Proficiency in T-SQL development and query tuning
  • Deep practical experience with SSMS and core SQL Server DBA tasks.
  • Proven experience in designing deploying and managing reports using SSRS.
  • Experience with ETL tools (e.g. SSIS) for data preparation.
  • Demonstrated ability to implement and manage data validation and reconciliation processes.

    • Preferred Qualifications :

  • Experience working with data from Cerner Millenium
  • Familiarity with healthcare data standards i.e. charges orders adjustments payments HCPCS / CPT 835 (Remittance Advice) and 837 (Claims) transaction data.
  • Experience with publishing and managing BI content on Tableau Server (excluding user provisioning)
  • Bachelors degree in computer science IT or a related field.

    • Compensation Package

  • Competitive Salary
  • Paid Time Off
  • Health Vision & Dental Insurance
  • Health Savings Account (HSA)
  • Flexible Spending Account (FSA)
  • Short & Long Term Disability
  • 401K
  • Life Insurance

    • Required Experience :

    Manager

    Key Skills

    Business Development,Apprentice,Asset Management,ABAP,IT Strategy,Manufacturing

    Employment Type : Full-Time

    Experience : years

    Vacancy : 1

    [job_alerts.create_a_job]

    Revenue Cycle Database AdministratorReporting Analyst • Chicago, Illinois, USA

    [internal_linking.similar_jobs]
    Loyalty Data Architect & BA (Hybrid)

    Loyalty Data Architect & BA (Hybrid)

    MMD Services • Chicago, IL, United States
    [job_card.full_time]
    A leading consulting firm in Chicago is looking for a Senior Technical Business Analyst / Data Architect to support a large-scale loyalty platform. This hybrid role balances business analysis with d...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Business Analyst - Card Loss Forecast and Allowance

    Senior Business Analyst - Card Loss Forecast and Allowance

    Chicago Staffing • Chicago, IL, US
    [job_card.full_time] +1
    Senior Business Analyst - Card Loss Forecast and Allowance.The Loss Forecasting and Allowance team resides within our Consumer Card Risk Management Organization and is focused on delivering quality...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    SINAI CHICAGO REVENUE CYCLE ANALYST

    SINAI CHICAGO REVENUE CYCLE ANALYST

    Sinai Chicago • Chicago, Illinois, United States, 60608
    [job_card.full_time]
    SINAI CHICAGO REVENUE CYCLE ANALYST.At Sinai Health System, Sinai Chicago, we take health care personally.Excellence in healthcare is about more than just medicine, technology, tests, and treatment...[show_more]
    [last_updated.last_updated_30]
    Resolution and Recovery Planning Analyst Sr.

    Resolution and Recovery Planning Analyst Sr.

    Chicago Staffing • Chicago, IL, US
    [job_card.full_time]
    Resolution & Recovery Planning Analyst.Huntington National Bank's Recovery and Resolution Planning Office is seeking a Resolution & Recovery Planning Analyst to join the Resolution & Recovery Plann...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Business Analyst III

    Business Analyst III

    PTR Global • Chicago, IL, United States
    [job_card.full_time]
    Chicago, Illinois or Houston, TX (Hybrid role ).The Business Analyst III will play a critical role in identifying requirements across business units and improving substandard systems processes thro...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Capital Partnerships Analyst — Data, Reporting & Growth

    Capital Partnerships Analyst — Data, Reporting & Growth

    Ryan Specialty Underwriting Managers • Chicago, IL, United States
    [job_card.full_time]
    A leading specialty insurance firm in Chicago is seeking an Entry-level Analyst for the Capital Management team.This role involves conducting in-depth portfolio analysis, designing executive presen...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Billing Solutions Architect

    Billing Solutions Architect

    Stripe • Chicago, IL, United States
    [job_card.full_time]
    Stripe is a financial infrastructure platform for businesses.Millions of companies—from the world’s largest enterprises to the most ambitious startups—use Stripe to accept payments, grow their reve...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Revenue Cycle AR Collections Specialist

    Revenue Cycle AR Collections Specialist

    Spectrum Billing Solutions • Skokie, IL, US
    [job_card.full_time]
    Revenue Cycle Ar Collections Specialist / h2pSpectrum Billing Solutions is a revenue cycle management company for healthcare organizations. We are looking to add a passionate and skilled Revenue Cycle...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Revenue Cycle Manager

    Revenue Cycle Manager

    Tempus • Chicago, IL, US
    [job_card.full_time]
    Passionate about precision medicine and advancing the healthcare industry?.Recent advancements in underlying technology have made it possible for AI to impact clinical care in a meaningful way.Temp...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    AR Revenue Cycle Collections Specialist

    AR Revenue Cycle Collections Specialist

    LifeLine Ambulance Illinois • Skokie, Illinois
    [job_card.full_time]
    [filters_job_card.quick_apply]
    AR Revenue Cycle Collections Specialist.Lifeline Ambulance Network is a multi-market private ambulance provider delivering emergency and non-emergency medical transportation services.Our revenue cy...[show_more]
    [last_updated.last_updated_variable_hours] • [new]
    Revenue Management Analyst

    Revenue Management Analyst

    Hispanic Alliance for Career Enhancement • Chicago, Illinois, US
    [job_card.full_time]
    Application Deadline : 12 / 30 / 2025 Address : 320 S Canal Street Job Family Group : Data Analytics & Reporting Treasury and Payment Solutions (TPS) Revenue Management seeks a dynamic individual to drive...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Database Administrator

    Senior Database Administrator

    Barrow Wise Consulting • Chicago, IL, USA
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Enjoy problem-solving, need a venue to display your creativity, and emerging technologies pique your interest; if so, Barrow Wise Consulting, LLC is for you. As a multi-disciplined leader, you under...[show_more]
    [last_updated.last_updated_30]
    Lead, Portfolio Analytics – U.S. & Bermuda

    Lead, Portfolio Analytics – U.S. & Bermuda

    Markel • Chicago, Illinois, United States
    [job_card.full_time]
    A leading global insurance firm is looking for a Head of Portfolio Analytics to set a vision that engages stakeholders and leads a transformative team. This role requires someone with a significant ...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Healthcare Analytics Leader - SQL & Tableau Dashboards

    Healthcare Analytics Leader - SQL & Tableau Dashboards

    CH01 CHE Fresenius Medical Care (Schweiz) AG • Chicago, IL, United States
    [job_card.full_time]
    A leading healthcare analytics firm is seeking a Director of Healthcare Analytics to transform large datasets and develop insightful Tableau dashboards in a hybrid work environment.Candidates must ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Business Analyst - Card Loss Forecast and Allowance

    Senior Business Analyst - Card Loss Forecast and Allowance

    Capital One • Chicago, IL, US
    [job_card.full_time] +1
    Senior Business Analyst - Card Loss Forecast and Allowance.The Loss Forecasting and Allowance team resides within the Consumer Card Risk Management Organization and is focused on delivering quality...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Manager, Data Analysis - Card Services

    Manager, Data Analysis - Card Services

    Chicago Staffing • Chicago, IL, US
    [job_card.full_time] +1
    Manager, Data Analysis - Card Services.At Capital One, data is at the center of everything we do.When we launched as a startup we disrupted the credit card industry by individually personalizing ev...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Manager Revenue Cycle

    Manager Revenue Cycle

    La Rabida Children's Hospital • Chicago, IL, United States
    [job_card.full_time]
    La Rabida Children’s Hospital provides specialized, family-centered health care to children with medically complex conditions, disabilities, and chronic illness. Through expertise, compassion, and a...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Epic Reporting Analyst

    Epic Reporting Analyst

    Sinai Chicago • Chicago, Illinois, United States, 60608
    [job_card.full_time]
    Located on Chicago’s West and Southwest Side, Sinai Health System is comprised of Mount Sinai Hospital, Holy Cross Hospital, Schwab Rehabilitation Hospital, Sinai Children’s Hospital, Sinai Communi...[show_more]
    [last_updated.last_updated_variable_days]