Business Intelligence Developer (Healthcare Data, EDI, ETL)

MicroHealth is seeking a skilled and motivated Business Intelligence Developer with a strong background in healthcare data and SQL development to join our team. In this role, you will design, develop, and maintain enterprise BI solutions that transform complex healthcare data into actionable insights for clinical, operational, and financial stakeholders. You will collaborate closely with stakeholders and cross-functional teams to understand business needs and deliver high-quality dashboards, reports, and data pipelines that drive decision-making across the organization.Key ResponsibilitiesWrite, optimize, and maintain complex SQL queries, stored procedures, views, and functions against large healthcare datasetsDesign and develop ETL/ELT pipelines to extract, transform, and load data from clinical, claims, and administrative systems (EHR, EMR, ADT, billing)Ensure data integrity, accuracy, and consistency across all reporting layersPerform data profiling, root cause analysis, and data quality remediationBuild and maintain interactive dashboards and reports using BI tools such as Apache Superset, Tableau, Power BI, or similar platformsTranslate business requirements from clinical and operational teams into scalable, self-service BI solutionsDevelop KPI frameworks and performance metrics aligned with healthcare quality, utilization, and financial goalsSupport ad hoc analysis requests and present findings clearly to non-technical stakeholdersWork with standard healthcare data models and terminologies including ICD-10, CPT, SNOMED, LOINC, and HL7/FHIREnsure all BI solutions comply with HIPAA and organizational data governance policiesPartner with clinical informatics and IT teams on data architecture and master data management initiativesGather and document business and technical requirements from stakeholders across clinical, finance, and operationsMaintain thorough documentation of data definitions, data dictionaries, report logic, and development standardsParticipate in Agile/Scrum ceremonies and contribute to sprint planning and backlog groomingMentor junior analysts and provide guidance on SQL best practices and BI development standardsRequired Skills & QualificationsAdvanced SQL (T-SQL, PL/SQL, or PostgreSQL)Healthcare data systems (EHR, EMR, Claims)BI tools: Apache Superset, Tableau, Power BI, or equivalentETL/ELT development and data pipelinesData warehousing concepts (star/snowflake schemas)Stored procedures, views, and query optimizationData quality and validation methodologiesExcel and pivot table analysisICD-10, CPT, SNOMED, LOINC coding standardsHL7/FHIR data standardsHIPAA compliance and data privacy regulationsStrong analytical and problem-solving skillsStakeholder communication and requirements gatheringAgile/Scrum development methodologyPreferred QualificationsBachelor's degree in Computer Science, Health Informatics, Data Science, Mathematics, or a related fieldMinium 7 years of experience in a BI developer, data analyst, or similar role within a healthcare settingExperience with cloud platforms such as AWSFamiliarity with JavaScript, Python, or R for data analysis and automationKnowledge of Epic, Cerner, or other major EHR platforms and their reporting modules (e.g., Epic Clarity/Caboodle)Experience with SSRS, SSAS, or Microsoft SQL Server Integration Services (SSIS)Healthcare analytics certifications (e.g., CHDA, RHIA) or BI tool certifications (e.g., Tableau Desktop Specialist)TRICARE experienceApache Superset experienceSalary: $120000-$130000Physical Demands:While performing the duties of this job, the employee is regularly required to sit. The employee frequently is required to walk; use hands to finger, handle or feel; reach with hands and arms; and talk or hear. The employee is occasionally required to stand. The employee may lift or move objects up to 5 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, and the ability to adjust focus.MicroHealth will recruit, hire, train, and promote persons in all job titles, and ensure that all other personnel actions are administered without regard to race, color, religion, sex, sexual orientation, gender identity, genetic information, national origin, disability, or status as a protected veteran and ensure that all employment decisions are based only on valid job requirements.All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.If you need reasonable accommodation due to a disability for any part of the employment process, please send an e-mail to hr@microhealthllc.com with your request and contact information.Powered by JazzHRUpnOCdhXL0