Job Description
Key Responsibilities
Database Development & Management
- Design and develop relational databases (OLTP/OLAP) to support business applications and reporting. - Write and optimize SQL queries, stored procedures, and scripts for performance. - Handle database administration tasks, including performance monitoring, tuning, and security. - Ensure database integrity, security, and reliability. - Work with cross-functional teams to integrate data from PMS, EHR, billing, and other healthcare systems.
Data Warehousing & ETL
- Design schemas and data models to store data from multiple sources into the enterprise data warehouse (EDW). - Build, optimize, and maintain ETL pipelines to consolidate and transform data. - Ensure data quality, consistency, and accuracy for analytics and dashboards. - Create queries and stored procedures to support BI and reporting needs. - Support BI developers in creating Power BI dashboards and rep...