Associate Healthcare Data Analyst Full Time

POSITION GOAL

The Associate Healthcare Data Analyst will focus on understanding database structures and data content, developing reliable SQL-based data access, and serving as the primary resource for database development so that UI/UX, ETL (SSIS), and Data Visualization developers can concentrate on their respective areas. This role emphasizes learning, ownership, and sound technical fundamentals.

POSITION RESPONSIBILITIES

• Learn and maintain an understanding of database schemas, table relationships, and data meaning
• Develop and maintain SQL queries, views, and stored procedures.
• Create and support CRUD procedures for front-end and application development.
• Refactor existing queries as data sources or requirements change.
• Support Microsoft SQL Server databases used by applications and internal systems.
• Assist with monitoring database performance and resource usage.
• Identify inefficient or fragile SQL patterns and help improve them.
• Participate in database hardening efforts, including permissions and security best practices.
• Use linked servers and external connections (such as Snowflake or other data platforms).
• Collaborate with UI/UX, ETL (SSIS), and Data Visualization developers
• Document database structures, procedures, and data access logic
• Use AI-based tools to accelerate coding, troubleshooting, and learning when appropriate.
• Demonstrate a solid understanding of SQL and database concepts independent of AI tools
• Be able to write, review, and debug SQL code without reliance on AI assistance
• Validate AI-generated outputs for correctness, performance, and security

Some additional responsibilities might include:

• Data modeling and database design.
• ETL (Extract, Transform, Load) development.
• Data quality and validation.
• Data security and compliance.
• Cloud computing (AWS, Azure, Google Cloud).
• Data analytics and visualization tools (Tableau, Power BI).
• Programming languages (Python, SQL, Java).
• Data architecture and strategy.

POSITION REQUIREMENTS

Experience:

Required: