The Role
Provide MS SQL Server database administration and EHR support: build/alter stored procedures, develop SSRS reports, troubleshoot performance, deploy patches, create BI reports, automate processes, interact with users and vendors, integrate applications via APIs, and maintain SQL and Power BI reporting documentation.
Summary Generated by Built In
- Provides direct staff support for an Electronic Health Records (EHR) system based on MS SQL Server.
- Provides Technical Support on Client Portal functions for Staff and Staff relayed client issues.
- Diagnoses issues with and/or enhances the Health records system – primarily via the alteration or construction of MS SQL Stored Procedures.
- Construction of SQL Server Reporting System components (SSRS RDLS).
- Fundamentally understands SQL – including the ability to construct complex queries that may involve the use of CTEs, temporary working tables, and higher-level SQL Server SQL extensions.
- Develops and maintains SQL database reports and customized Business Intelligence Reports utilizing SQL databases and Power BI to transform raw data into meaningful, visual dashboards and reports for Executive Leadership, Division Directors, Program Administrators, and Quality Assurance.
- Automates processes using MS SQL Reporting Services when possible.
- Interacts with end users to establish and clarify reporting requirements and develops SQL reports to specifications.
- Troubleshoots, diagnoses, and resolves database performance issues.
- Manages deployment of security patches, hotfixes, and software updates to SQL servers/databases – both internally managed Databases and those managed by the Health Records system vendor.
- Works closely with the MIS team supporting all Center systems and maintenance activities.
- Works directly with vendors where required on escalated issues or enhancements.
- Creates and maintains documentation of SQL and Power BI reporting.
- Routinely works on integration of products between current applications and new applications as they are implemented utilizing various APIs.
Education, Training and Experience (including licensure and certification)
- Associate level College Degree in Information Technology or higher level degree preferred.
- Experience such as certifications or equivalent work experience with MS-SQL (2014 or higher) Server and relational database applications required.
- Two (2) years of work experience in SQL development and reporting required.
- A minimum of 2 years of experience with SmartCare from Streamline Health (EHR) performing administrative/support functions preferred.
- 1 or more years of experience with Microsoft Power BI preferred.
Skills Required
- Experience with MS-SQL Server (2014 or higher) and relational database applications
- Two years of work experience in SQL development and reporting
- Certifications or equivalent work experience with MS-SQL Server
- Ability to construct complex SQL queries including CTEs and temporary tables (T-SQL)
- Experience constructing SQL Server Reporting Services components (SSRS RDLs)
- Associate degree in Information Technology or higher
- Minimum 2 years experience with SmartCare (Streamline Health) performing administrative/support functions
- One or more years of experience with Microsoft Power BI
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
LifePath Systems is the designated behavioral health and intellectual and developmental disabilities authority for Collin County, Texas. Operating as a unit of local government and a not-for-profit center, it provides comprehensive mental health, substance use, and intellectual and developmental disability services to residents of the county. The organization is funded by federal, state, and local sources to serve individuals and families impacted by these challenges.
