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]
    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_variable_days]
    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]
    Performance Analyst

    Performance Analyst

    Planpilot LLC • Chicago, Illinois, United States
    [job_card.full_time]
    PlanPILOT takes a comprehensive approach to defined contribution retirement plan consulting, focused on minimizing fiduciary risk for plan sponsors and their oversight teams, as well as minimizing ...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    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 treatmen...[show_more]
    [last_updated.last_updated_30]
    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]
    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]
    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_30] • [promoted]
    Category Management Analyst

    Category Management Analyst

    undefined • Chicago, IL, US
    [job_card.full_time]
    Cheers to creating an incredible tomorrow! .At Molson Coors, we tackle big challenges and defy the status quo.With a proud legacy of excellence, an incredible portfolio of beer, seltze...[show_more]
    [last_updated.last_updated_variable_days] • [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.Spectrum Billing Solutions is a revenue cycle management company for healthcare organizations. We are looking to add a passionate and skilled Revenue Cycle AR...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Sales Operations - Data Management Analyst

    Sales Operations - Data Management Analyst

    Adtalem Global Education • Chicago, IL, US
    [job_card.full_time]
    About Adtalem Global Education.Adtalem Global Education is a national leader in post-secondary education and leading provider of professional talent to the healthcare industry.Adtalem educates and ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Technical Business Analyst

    Technical Business Analyst

    Relativity • Chicago, IL, United States
    [job_card.full_time]
    Relativity's Problem Management is seeking a Technical Business Analyst who excels at using data analytics to uncover trends in quality, client workflows, product performance and efficiency.Your in...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Revenue Management Analyst

    Revenue Management Analyst

    Bmo • Chicago, IL, US
    [job_card.part_time]
    Treasury And Payment Solutions (Tps) Revenue Management.Treasury and Payment Solutions (TPS) Revenue Management seeks a dynamic individual to drive the evolving Cash Management business.This role i...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Actuarial Analyst

    Senior Actuarial Analyst

    QBE Americas, Inc. • Chicago, IL, United States
    [job_card.full_time] +1
    Primary DetailsTime Type : Full time Worker Type : Employee.Work Arrangement : Hybrid / Remote (Based on Location).The salary range for this role is : $ 88,000-165,000. Provide strong qualitative and techn...[show_more]
    [last_updated.last_updated_variable_days] • [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]
    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]