Job Title

JOB DESCRIPTION The position description is a guide to the critical duties and essential functions of the job, not an all-inclusive list of responsibilities, qualifications, physical demands, and work environment conditions. Position descriptions are reviewed and revised to meet the changing needs of the organization. TITLE: Healthcare Intelligence Developer II JOB OVERVIEW: Tasked with delivering comprehensive reporting and analytical services to our internal business partners and leadership team. Leads the creation and implementation of integrated solutions, utilizing both business acumen and technical skills to design, develop, and implement Business Intelligence (BI) solutions, databases, data warehouses, data marts, interfaces, custom programming, complex reports, and analysis. Offers technical expertise in developing integrated data and business process improvement solutions for various functional areas through the use of technology. DEPARTMENT: Information Technology WORK HOURS: As required to fulfill responsibilities. REPORTS TO: IT Director/Manager/Supervisor PREREQUISITES: * Bachelor's degree, OR Associate's degree and two (2) years related industry experience, OR five (5) years related experience. * Applied IT Job Experience: 2-5 years * Experience in direct development using SQL Server technologies (SSAS, SSRS, SSIS). * Experience with current Microsoft SQL database management platform preferred. * Experience utilizing standard reporting tools to generate reports. * Experience utilizing BI Reporting solutions like Tableau, Power BI, etc. * Certification: * Epic Cogito Certification/Proficiency Required, and Epic Access, Clinical, or Revenue Cycle Data Model Certification/Proficiency OR be able to obtain withing three (3) months of hire date OR * Infor BIRST Administrator Certification OR be able to obtain with six (6) months of hire date. QUALIFICATIONS: * Ability to learn new applications/software systems effectively and efficiently. * Ability to take a problem, requirement, or strategy, research, and present solutions for implementation for desired outcomes. * Ability to effectively prioritize and meet deadlines. * Ability to work independently under clearly defined guidelines with supervision. * Ability to listen to business needs expressed by clients and clearly document system capabilities and constraints. Maintains specifications according to departmental standards. * Knowledge of health care operations and structure, general requirements in an integrated delivery system, and use of information system applications in the health care environment. * Understanding of data governance principles and practices UNIQUE PHYSICAL/MENTAL DEMANDS, ENVIRONMENT AND WORKING CONDITIONS: Requires the ability to move PC's and printers weighing up to 40 lbs. Requires planning, organizing, and working on multiple tasks at one time. Tolerates ambiguity in instructions and work situations. PERFORMANCE RESPONSIBILITIES: * Generic Job Functions: See Generic Job Description for Administrative Partner * Essential Responsibilities and Competencies * * Provides direct supervisor or lead with a weekly summary of activities. * Documents change control and system problems according to departmental procedures. * Documents all work efforts in IT ticketing system according to departmental procedures. * Advises direct supervisor or lead of potential problems, requirements for expanded services and status of current systems on an ongoing basis. * Promptly notifies direct supervisor or lead of problems, unexpected tasks and missed targets. * Responds to all requests according to departmental standards. * Performs end-user functions for assigned products to a high level of competency. * Ensures that reports, data, and devices are appropriately secured. * Maintains the security of the Data Center(s) systems and information, per VMC and departmental Information Privacy Policies. * Provides after-hours support as required. * Ability to successfully log into enterprise network and all supported applications. * Ability to organize, schedule, manage (chair) meetings and publish meeting minutes. * Ability to successfully contact vendor for support. * Ability to complete annual VMC educational requirements. * Write and execute basic SQL queries to retrieve data for analysis and reporting. * Maintain and update existing queries and stored procedures, ensuring they remain functional and efficient. * Document SQL scripts and processes for future reference and team knowledge sharing. * Perform routine maintenance and updates to existing reports. * Develop basic dashboards, reports, and visualizations using tools Tableau, Power BI, Epic Reporting Workbench, Radar dashboard, and/or Infor Application Reporting tools. * Develop complex data integration solutions, combining multiple disparate data sources into a single, well-structured environment. * Improve data validation techniques, ensuring the highest quality and accuracy in reporting and analytics. * Design and develop high-impact dashboards and reports using Tableau, Power BI, and other BI tools. * Design and develop reports using Radar SQL Metrics, RW SQL, and SlicerDicer * Design and develop reports using BIRST. * Ensure data governance, compliance, and security best practices are embedded into all BI solutions. * Champion self-service BI, empowering business users with tools and training to access and analyze data independently. * Performs other related duties as required. Revised: 2/25 Grade: NC-10 FLSA: E CC: 8553 Job Qualifications: PREREQUISITES: * Bachelor's degree, OR Associate's degree and two (2) years related industry experience, OR five (5) years related experience. * Applied IT Job Experience: 2-5 years * Experience in direct development using SQL Server technologies (SSAS, SSRS, SSIS). * Experience with current Microsoft SQL database management platform preferred. * Experience utilizing standard reporting tools to generate reports. * Experience utilizing BI Reporting solutions like Tableau, Power BI, etc. * Certification: * Epic Cogito Certification/Proficiency Required, and Epic Access, Clinical, or Revenue Cycle Data Model Certification/Proficiency OR be able to obtain withing three (3) months of hire date OR * Infor BIRST Administrator Certification OR be able to obtain with six (6) months of hire date. QUALIFICATIONS: * Ability to learn new applications/software systems effectively and efficiently. * Ability to take a problem, requirement, or strategy, research, and present solutions for implementation for desired outcomes. * Ability to effectively prioritize and meet deadlines. * Ability to work independently under clearly defined guidelines with supervision. * Ability to listen to business needs expressed by clients and clearly document system capabilities and constraints. Maintains specifications according to departmental standards. * Knowledge of health care operations and structure, general requirements in an integrated delivery system, and use of information system applications in the health care environment. * Understanding of data governance principles and practices