Business Intelligence Developer

$60,000 - $60,000/Yr

Lone Star Circle Of Care - Georgetown, TX

Full-time - Entry Level

Remote - Georgetown, TX

Ambulatory Health Care Services

About the position

The Business Intelligence Developer position at Lone Star Circle of Care (LSCC) is a full-time role focused on creating and optimizing reports, visualizations, dashboards, and metrics to support the organization's analytical needs. The developer will collaborate with various stakeholders, including developers, physicians, and clinical operations staff, to ensure data accuracy and integrity across reporting platforms. This role requires travel to LSCC facilities as needed and emphasizes excellent customer service and professional relationships.

Responsibilities

• Design, develop, and deploy BI solutions, including reports, dashboards, and data visualizations using tools such as Power BI and SQL Server Reporting Services (SSRS).
• Write and optimize SQL queries and ETL stored procedures with Snowflake and SQL Server.
• Analyze various types of technical and healthcare data, processes, and systems.
• Create comprehensive documentation for new developments, updates, and enhancements for both developers and end-users.
• Build low-code applications using the PowerApps platform.
• Ensure data accuracy, integrity, and consistency across all reporting platforms.
• Perform quality assurance testing and audit business intelligence products.
• Validate results and reconcile discrepancies with data and end user workflows.
• Troubleshoot and resolve technical issues related to BI tools and data integration processes.
• Support existing and create new Extract, Transform, and Load (ETL) processes.
• Manage communication with both internal and external stakeholders.
• Utilize and manage git repositories.
• Perform other duties as assigned.

Requirements

• Demonstrated excellence in technical skills in one or more higher level programming languages (specifically SQL and/or a statistical or object-oriented language).
• Proficiency with Windows operating systems and Microsoft Office 365 applications.

Nice-to-haves

• Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field.
• Two (2) years of T-SQL experience with a strong emphasis on Reporting and Aggregating.
• Experience with process improvement/automation and data visualization software such as Power BI.
• Experience using SQL Server Reporting Services (SSRS) or similar report tools.
• Statistics experience (particularly experience with R or SAS).
• Working knowledge of healthcare terminology and structured vocabularies (e.g. ICD, CPT, NDC, etc.).
• Experience with electronic health record (EHR) systems and the associated tables.
• Experience with Collaboration tools like SharePoint or MS Teams.
• Knowledge of data warehousing.

Benefits

• Dental insurance
• Employee assistance program
• Health insurance
• Life insurance
• Paid time off
• Referral program
• Retirement plan
• Vision insurance