Talent.com
Revenue Cycle Database Administrator/Reporting Analyst
Revenue Cycle Database Administrator/Reporting AnalystKeystone Advisors LLC • Chicago, IL, US
[error_messages.no_longer_accepting]
Revenue Cycle Database Administrator / Reporting Analyst

Revenue Cycle Database Administrator / Reporting Analyst

Keystone Advisors LLC • Chicago, IL, US
[job_card.variable_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
  • [filters_job_card.quick_apply]
[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) Bachelor's 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  Powered by JazzHR
    • [job_alerts.create_a_job]

    Revenue Cycle Analyst • Chicago, IL, US

    [internal_linking.similar_jobs]
    Database Administrator Lead Consultant - Hybrid- Chicago, IL Hybrid

    Database Administrator Lead Consultant - Hybrid- Chicago, IL Hybrid

    Allstate • Chicago, IL, United States
    [job_card.full_time]
    At Allstate, great things happen when our people work together to protect families and their belongings from life’s uncertainties. And for more than 90 years, our innovative drive has kept us a step...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Associate Actuarial Analyst - Remote Opportunity

    Associate Actuarial Analyst - Remote Opportunity

    GuideOne Insurance • Chicago, IL, United States
    [job_card.full_time]
    As the Associate Actuarial Analyst, you will be responsible for supporting the company's loss ratio forecasting processes. You will assist in the development and maintenance of actuarial models and ...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Data Analyst I - Mission Data & Insights

    Data Analyst I - Mission Data & Insights

    Wounded Warrior Project • Chicago, IL, United States
    [job_card.full_time]
    We know these are some of the things people look for in a job.If you're the kind of person who believes that honoring and empowering our nation's veterans is more than just a cause - that it's a ca...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Data & Reporting Analyst

    Data & Reporting Analyst

    First Chicago Insurance Company (FCIC) • Bedford Park, IL, USA
    [job_card.full_time]
    [filters_job_card.quick_apply]
    We are seeking the ideal candidate for our Data and Reporting Analyst.The Data and Reporting Analyst will work independently within the Product & Actuarial Department while collaborating with v...[show_more]
    [last_updated.last_updated_1_day]
    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]
    SOC Reporting Manager

    SOC Reporting Manager

    Plante Moran • Chicago, IL, United States
    [job_card.full_time]
    Our "we-care" culture is more than just a motto; it's a promise.From day one, we prioritize your growth, well-being, and success. You can count on us to support your career journey and help you achi...[show_more]
    [last_updated.last_updated_variable_days] • [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]
    BIC Compliance Analyst

    BIC Compliance Analyst

    Cooley LLP • Chicago, IL, United States
    [job_card.full_time]
    Cooley is seeking a BIC Compliance Analyst to join the Business Intake and Conflicts team.The BIC Compliance Analyst is responsible for ensuring compliance with risk management policies related to ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Actuarial Analyst, Reserving & Loss Analytics - Middle Market

    Senior Actuarial Analyst, Reserving & Loss Analytics - Middle Market

    Arch Capital Group Ltd. • Chicago, IL, United States
    [job_card.full_time]
    With a company culture rooted in collaboration, expertise and innovation, we aim to promote progress and inspire our clients, employees, investors and communities to achieve their greatest potentia...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Epic Reporting Analyst

    Epic Reporting Analyst

    Sinai Chicago • Chicago, IL, United States
    [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] • [promoted]
    Reporting Analyst

    Reporting Analyst

    Pivotal Solutions Inc • Chicago, IL, United States
    [job_card.full_time]
    The Reporting Analyst will partner with key stakeholders to build data structures and processes to produce meaningful and actionable organizational reporting. This person will need to be able to ext...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Jr Transaction Monitoring Analyst

    Jr Transaction Monitoring Analyst

    Zero Hash • Chicago, IL, United States
    [job_card.full_time]
    This is a fully remote position located in the US or UK reporting to the Monitoring & Surveillance Manager.The role is primarily responsible for the monitoring, research, and analysis of crypto tra...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Senior Financial Reporting Analyst

    Senior Financial Reporting Analyst

    Advantage Solutions • Chicago, IL, United States
    [job_card.full_time]
    Senior Financial Reporting Analyst.US-MO-Saint Louis | US-CA-Irvine | US-IL-Chicago.Primary Posting Location : City.Primary Posting Location : State / Province. Primary Posting Location : Postal Code....[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Financing and Leasing (Accounts Receivable) - Credit Operations Analyst

    Financing and Leasing (Accounts Receivable) - Credit Operations Analyst

    Komatsu • Chicago, IL, United States
    [job_card.full_time]
    Financing and Leasing (Accounts Receivable) - Credit Operations Analyst .Chicago, Illinois, USA, 60631 .Join Komatsu and Be Part of Something Big!. Komatsu Financial provides wholesale, retail and ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Lead Associate Principal, Database Administration

    Lead Associate Principal, Database Administration

    The Options Clearing Corporation • Chicago, IL, United States
    [job_card.full_time]
    This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Client Revenue Management Analyst

    Senior Client Revenue Management Analyst

    Kirkland & Ellis • Chicago, IL, United States
    [job_card.full_time]
    At Kirkland & Ellis, we don't just meet the standard for legal excellence - we set it.Our culture is built on teamwork, ingenuity and an unwavering commitment to continuous growth.We tackle the mos...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    External Reporting Senior Analyst

    External Reporting Senior Analyst

    Aon • Chicago, IL, United States
    [job_card.full_time] +1
    The External Reporting Senior is a critical contributor to Aon’s quarterly financial statement filings.This role is responsible for preparing 10-Q and 10-K disclosures, supporting quarterly balance...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Database Administrator Lead Consultant - Hybrid- Chicago, IL Hybrid

    Database Administrator Lead Consultant - Hybrid- Chicago, IL Hybrid

    Allstate Insurance • Chicago, IL, United States
    [job_card.full_time]
    At Allstate, great things happen when our people work together to protect families and their belongings from life's uncertainties. And for more than 90 years, our innovative drive has kept us a step...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]