Keystone Advisors LLC ยท 1 day ago
Revenue Cycle Database Administrator/Reporting Analyst
United States
Full-time
Remote
Mid LevelKeystone Advisors LLC is looking for a Revenue Cycle Database Administrator/Reporting Analyst to support one of their healthcare clients in the Illinois Medical District. This role involves the configuration, maintenance, and performance of SQL Server database environments, along with the development of Business Intelligence content using SSRS and Tableau Desktop.
AccountingAdviceFinanceFinancial ServicesSoftware
Responsibilities
Install, configure, and maintain Microsoft SQL Server instances (including upgrades and patching)
Proactively monitor and tune database performance, including query optimization, index management, and overall server health using SSMS tools
Manage database security, user access, permissions, and roles in compliance with organizational policies
Design, implement, and test robust backup/recovery strategies and manage High Availability (HA)/Disaster Recovery (DR) solutions
Design, develop, and deploy complex reports using SSRS and interactive dashboards/workbooks using Tableau Desktop
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
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
Implement, monitor, and maintain scheduled checks to ensure daily balancing of data
Troubleshoot and resolve data discrepancies identified during the balancing process promptly
Manage and configure the SSRS Report Server and deploy/publish Tableau Workbooks to the Tableau Server, managing report and dashboard permissions and subscriptions
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
Qualification
Required
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
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
Benefits
Competitive Salary
Paid Time Off
Health, Vision & Dental Insurance
Health Savings Account (HSA)
Flexible Spending Account (FSA)
Short & Long Term Disability
401K
Life Insurance
Company
Keystone Advisors LLC
Keystone Advisors of Illinois, LLC.
Founded in 2008
11-50 employees
H1B Sponsorship
Keystone Advisors LLC has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (3)
2022 (1)
Funding
Current Stage
Early StageCompany data provided by crunchbase