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]
    Revenue Cycle Analyst

    Revenue Cycle Analyst

    VirtualVocations • Chicago, Illinois, United States
    [job_card.full_time]
    A company is looking for a Revenue Cycle Analyst.Key Responsibilities Oversee the entire full cycle revenue management and improve cash cycle Assist in implementing and maintaining billing syste...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Restaurant Delivery - Sign Up in Minutes

    Restaurant Delivery - Sign Up in Minutes

    DoorDash • Highland Park, IL, United States
    [job_card.full_time] +1
    DoorDash is the #1 category leader in food delivery, food pickup, and convenience store delivery in the US, trusted by millions of customers every day. As a Dasher, you’ll stay busy with a variety o...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Sr Pricing Analyst

    Sr Pricing Analyst

    Griffith Foods Inc. • Alsip, IL, United States
    [job_card.full_time]
    Griffith Foods is the caring, creative product development partner helping food companies meet the evolving needs of consumers while sustaining the planet. As a family business founded in 1919 and h...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    School-Based SLP | Zion, Illinois

    School-Based SLP | Zion, Illinois

    Soliant • Zion, IL, US
    [job_card.part_time]
    Master's degree in Speech-Language Pathology, active SLP license and 1+ year of Speech-Language Pathology experience required. Applicants who do not meet these qualifications will not be conside...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Travel Nurse RN - ED - Emergency Department - $2,226 per week

    Travel Nurse RN - ED - Emergency Department - $2,226 per week

    TotalMed Staffing • Zion, IL, USA
    [job_card.permanent]
    TotalMed Staffing is seeking a travel nurse RN ED - Emergency Department for a travel nursing job in Zion, Illinois.Job Description & Requirements. TotalMed is a Top Ten, travel nursing and healthca...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Reinsurance SICS Business Analyst

    Reinsurance SICS Business Analyst

    Aon • Chicago, IL, United States
    [job_card.full_time] +1
    Aon are looking to recruit an experienced Reinsurance Business Analyst to join our team in the US.This is a Hybrid position and can be based anywhere in the US. Important Notice Prior to Applying!.I...[show_more]
    [last_updated.last_updated_30] • [promoted]
    eDiscovery Analyst

    eDiscovery Analyst

    Taft Stettinius & Hollister LLP • Chicago, IL, United States
    [job_card.full_time]
    Taft is seeking an eDiscovery Analyst to serve our eDiscovery Services team in Taft's Chicago, Cincinnati, Cleveland, Columbus, Dayton, Denver, Detroit, Indianapolis or Minneapolis office.We are se...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Workforce Management Analyst

    Workforce Management Analyst

    Relativity • Chicago, IL, United States
    [job_card.full_time]
    The Workforce Management Analyst supports effective staffing, scheduling, and capacity decisions across the Relativity Success organization. This role translates forecasted demand, operational insig...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Epic Willow Ambulatory Analyst

    Epic Willow Ambulatory Analyst

    TEKsystems • Chicago, IL, United States
    [job_card.full_time]
    We are seeking an experienced Epic Willow Ambulatory Analyst to join our client and support the implementation and optimization of Epic Willow Ambulatory workflows. This role is critical as we insta...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Digital Opinion Contributor - Help Shape Future Products

    Digital Opinion Contributor - Help Shape Future Products

    Opinion Bureau • Zion, Illinois, US
    [job_card.full_time]
    Take quick online surveys and earn rewards for sharing your thoughts.Join today — it's free and easy!.[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Remote Financial Analyst - AI Trainer ($50-$60 / hour)

    Remote Financial Analyst - AI Trainer ($50-$60 / hour)

    Data Annotation • Zion, Illinois
    [filters.remote]
    [job_card.full_time] +1
    We are looking for a finance professional to join our team to train AI models.You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the quality of ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    TurboTax (WFH) Customer Service - Entry-Level

    TurboTax (WFH) Customer Service - Entry-Level

    TurboTax • Highland Park, Illinois
    [filters.remote]
    [job_card.full_time]
    Work from home with TurboTax Product Expert.Get a $405 Certification bonus³.Work from home & set your own flexible schedule between 8am EST and 12am midnight EST Monday to Sunday⁴.Earn an ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Travel Nurse RN - ED - Emergency Department - $2,381 per week

    Travel Nurse RN - ED - Emergency Department - $2,381 per week

    LanceSoft • Zion, IL, USA
    [job_card.permanent]
    LanceSoft is seeking a travel nurse RN ED - Emergency Department for a travel nursing job in Zion, Illinois.Job Description & Requirements. BLS(AHA), MAB, NIH, TNCC, ACLS and PALS Cert required.IL s...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Travel Nurse RN - Administration / Management in Highland Park, IL

    Travel Nurse RN - Administration / Management in Highland Park, IL

    TravelNurseSource • Highland Park, IL, US
    [job_card.full_time]
    Registered Nurse (RN) | Administration / Management.Competitive weekly pay (inquire for details) .TravelNurseSource is working with Health Advocates Network to find a qualified Admin / Mgmt RN in Hig...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Cost Analyst - Self Perform Operations

    Cost Analyst - Self Perform Operations

    Turner Construction Company • Chicago, IL, United States
    [job_card.permanent]
    Position Description : Prepare financial analyses, reports, and audit forecasts to confirm costs and effectively validate forecast financial outcome of assigned projects for Turner Constructions Na...[show_more]
    [last_updated.last_updated_less] • [promoted] • [new]
    Database Administrator

    Database Administrator

    CompTech Computer Technologies • Chicago, Illinois, USA
    [job_card.full_time]
    CompTech is a service-oriented program management and technical company working to build lasting relationships with small and large companies municipalities and Government agencies.Headquartered in...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    IAM Analyst

    IAM Analyst

    Skill • Northbrook, IL, United States
    [job_card.temporary]
    Aquent is partnering with a leading organization at the forefront of its industry, dedicated to innovation and excellence. This is an incredible opportunity to join a team that values security, inte...[show_more]
    [last_updated.last_updated_less] • [promoted] • [new]
    Travel Nurse - ED - Emergency Department Job in Zion, IL - $10,783 per Month (2 Years Experience Needed)

    Travel Nurse - ED - Emergency Department Job in Zion, IL - $10,783 per Month (2 Years Experience Needed)

    Vetted Health • Zion, IL, US
    [job_card.full_time]
    Vetted is seeking a RN - ED - Emergency Department for a travel job in Zion, Illinois.Must have 2 years of experience.This contract pays approximately $10,783 / month gross. Assignment details : Contra...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]