Lead Informatics & Analytics Developer

Job Description

Job Description:\n\nOur Core Values: At Prism Health North Texas, our actions are guided by our Core Values. These values shape every aspect of the employee experience, including hiring, development, performance, and accountability. They are evident in how we serve our patients, engage with communities, and support one another. Our Core Values are:We are solution seekers.We have a can-do attitude. We are mission driven. We care about people. Position Summary: The Lead Informatics & Analytics Developer is a senior hands-on healthcare analytics and informatics role responsible for stabilizing, developing, validating, and modernizing Prism Health North Texas' clinical, operational, financial, pharmacy, quality, grants, and executive reporting environment. This role provides technical leadership and direct execution across:Snowflake-based data analysis and reportingSQL development and source-to-report validationPower BI dashboard developmentPower BI semantic model design DAX and Power Query developmentHealthcare reporting logic and KPI standardization. Report inventory, documentation, QA, and certification supportData governance and reporting maturity initiatives The Lead Informatics & Analytics Developer serves as the primary technical execution lead for the Informatics function. This role is not intended to be a purely strategic, administrative, or supervisory position. The successful candidate must be comfortable working directly in the data, developing reports, troubleshooting discrepancies, validating logic, documenting lineage, and partnering with stakeholders to deliver accurate and actionable reporting. This position works closely with the VP of Information Technology, Informatics & Analytics Analyst, HIM, Clinical Operations, Quality, Grants, Finance, Pharmacy, Revenue Cycle, IT, and executive stakeholders to improve reporting continuity, data integrity, and stakeholder confidence in Prism's analytics function.Responsibilities Position Responsibilities: ANALYTICS DEVELOPMENT AND DASHBOARD DELIVERY Design, develop, maintain, and enhance Power BI dashboards and reports supporting clinical, operational, financial, pharmacy, quality, grants, and executive reporting needs.Serve as the lead developer for high-priority dashboards and analytics deliverables.Translate stakeholder needs into clear reporting requirements, technical specifications, data models, and validated dashboard outputs. Build reporting assets that support: Provider productivity Patient access Clinical quality measures o HRSA / UDS / grants reporting Pharmacy and 340B analytics Revenue cycle and payer mix reporting Executive scorecardsPopulation health and health equity analytics Create reporting solutions that are usable, actionable, and appropriate for executive, operational, and departmental audiences.Reduce reliance on manual exports, one-off spreadsheets, inbox-based reporting, and fragile SharePoint or network-folder workflows where feasible.Other duties as assigned.SNOWFLAKE, SQL, AND DATA MODELINGUse Snowflake as a primary reporting and analytics platform for querying, validating, and developing healthcare data assets. Write, optimize, and troubleshoot SQL queries used for dashboards, recurring reports, validation, and data analysis. Work with AthenaOne /Data View / Snowflake data sources to support clinical, operational, financial, and regulatory reporting. Design and maintain reusable datasets, views, extracts, or reporting logic that reduce duplicate report development and inconsistent calculations. Understand and document source data structures related to patients, encounters, appointments, providers, locations, diagnoses, procedures, payers, orders, quality measures, prescriptions, and financial activity. Identify gaps in source data, joins, filters, logic, or refresh processes that create reporting discrepancies. Support maturation of the reporting environment toward more governed and reusable data models.POWER BI, DAX, POWER QUERY, AND SEMANTIC MODELINGBuild and maintain Power BI semantic models that support consistent, scalable, and reusable enterprise reporting. Develop DAX measures that accurately reflect approved business logic. Use Power Query to clean, transform, and prepare data for reporting. Design data models using appropriate relationships, date tables, hierarchies, filters, measures, and reusable datasets. Develop business logic for calculations such as: No-show rate Provider productivity FTE-adjusted productivity Visit volume Schedule utilization Quality measure rates Numerator / denominator performance Variance to target Rolling trends Payer mix Pharmacy and 340B performance Improve Power BI maturity from disconnected dashboards and visualizations toward governed semantic models and certified datasets.Review and troubleshoot Power BI refresh failures, performance issues, relationship problems, DAX errors, and data mismatches.DATA VALIDATION, QUALITY ASSURANCE, AND REPORT CERTIFICATIONLead source-to-report validation for high-priority reports and dashboards. Validate report outputs against source systems, AthenaOne reports, Snowflake queries,Power BI datasets, and business-owner expectations. Validate:Numerators and denominatorsMeasure exclusionsDate rangesProvider attributionLocation attributionPayer groupingsEncounter and visit logicPharmacy and 340B logicGrants, HRSA, UDS, and quality reporting logic. Develop and maintain QA checklists for new, modified, recurring, and executive-facing reports.Document assumptions, known limitations, validation steps, and sign-off requirements.Support report certification activities through the Data Governance Committee.Conduct root-cause analysis when reporting discrepancies arise and recommend corrective action. DATA GOVERNANCE AND KPI STANDARDIZATIONSupport the Data Governance Committee by preparing reports, dashboards, metric definitions, and validation artifacts for review. Help establish and maintain standardized KPI definitions, reporting logic, and data documentation.Partner with business owners and data stewards to define and validate metrics across clinical, operational, financial, pharmacy, quality, and grants domains. Support development and maintenance of an enterprise KPI dictionary. Standardize commonly used metrics, including:EncountersVisitsUnique patientsNo-show rateProvider productivityClinical FTEwRVU / productivity-related measuresPayer mixQuality measures UDS measuresPharmacy and 340B measuresHelp reduce multiple versions of truth by aligning reports to approved definitions, certified datasets, and documented logic.REPORT INVENTORY, DOCUMENTATION, AND LINEAGELead documentation efforts for critical reports, dashboards, datasets, data sources, refresh processes, and business logic.Maintain and improve the enterprise report and dashboard inventory in partnership with the Informatics & Analytics Analyst.Document report owners, business purpose, data sources, Snowflake objects, refresh frequency, distribution method, audience, and certification status. Create and maintain report runbooks for recurring reports and high-priority dashboards. Document manual reporting workflows involving AthenaOne exports, inbox delivery, SharePoint folders, network files, and spreadsheet manipulation. Establish source-to-report lineage for critical reports.Reduce reliance on tribal knowledge by creating repeatable, accurate, and accessible documentation.CLINICAL, QUALITY, GRANTS, AND REGULATORY REPORTINGSupport and develop reporting related to clinical operations, quality measures, CeM, UDS, HRSA, grants, population health, and health equity.Partner with Clinical Operations, Quality, Grants, HIM, and operational leaders to understand reporting needs and translate them into validated analytics outputs.Support validation of reports used for external, regulatory, grant-related, or executive facing purposes.Ensure sensitive and high-impact reports receive appropriate validation before distribution.Identify and resolve reporting discrepancies that could affect compliance, funding, quality performance, or leadership decision-making.PHARMACY, 340B, FINANCE, AND OPERATIONAL ANALYTICSDevelop and support pharmacy and 340B reporting, including prescription volume, contract pharmacy activity, eligible encounter reporting, referral capture, exception reporting, revenue opportunity, leakage, and audit-readiness support.Partner with Pharmacy, Finance, Revenue Cycle, and operational stakeholders to validate pharmacy and 340B reporting logic.Support finance-related reporting, including payer mix, revenue cycle metrics, provider productivity, visit volume, cost and margin analysis, and service line performance.Work with business owners to confirm assumptions, calculations, and appropriate interpretation of finance and pharmacy reporting.Support reconciliation when reports do not align across systems, departments, or reporting tools.REQUIREMENTS GATHERING AND STAKEHOLDER PARTNERSHIPLead requirements gathering for complex reporting and dashboard requests. Translate vague or broad stakeholder needs into actionable requirements, mockups, data requirements, validation plans, and deliverables. Support the Informatics intake and backlog prioritization process. Communicate timelines, blockers, risks, dependencies, and tradeoffs clearly to stakeholders.Provide service-oriented support while reinforcing standardized intake, governance, QA, and documentation practices.Serve as a trusted technical partner for operational and executive stakeholders.TECHNICAL LEADERSHIP AND ANALYST MENTORSHIPProvide technical direction, mentoring, and work review for the Informatics & Analytics Analyst.Review SQL queries, Power BI reports, documentation, QA outputs, and validation work produced by the analyst.Establish practical development standards for Power BI, SQL, documentation, validation, and report maintenance.Promote a culture of accuracy, responsiveness, documentation, and continuous improvement within the Informatics function.PROCESS IMPROVEMENT AND ANALYTICS MATURITYIdentify fragile, manual, duplicative, or poorly documented reporting processes that should be improved, automated, or retired.Support the transition from reactive reporting support to a governed enterprise analytics function.Help mature Prism's use of Snowflake, Power BI, semantic models, DAX, Power Query, and future Microsoft Fabric capabilities.Support development of more reliable data pipelines, curated reporting layers, and reusable datasets where appropriate.Assist in roadmap activities related to data architecture, report certification, self-service reporting, and analytics governance. Direct reports:NoneRequired Skills Required Knowledge, Skills, and Abilities:Advanced proficiency in:SnowflakeQL querying and troubleshootingPower BI dashboard developmentDAXPower QueryData modeling and semantic model designData validation and source-to-report reconciliationHealthcare reporting and analyticsReport QA and UATRequirements gathering and stakeholder communicationExperience with:Healthcare data and reporting environments Snowflake-based reporting and analytics Power BI semantic models and reusable datasets SQL queries used for dashboards, validation, and operational reporting Healthcare reporting logic, including clinical, operational, quality, finance, pharmacy, or grants reporting Manual and automated reporting workflows Data quality analysis and discrepancy investigation Report documentation, lineage, and runbook development Data governance and KPI standardizationWorking understanding of:EHR reporting conceptsAthenaOne I DataView-style reporting environmentsClinical operations reportingProvider productivity reportingQuality measure reportingHRSA / UDS / grants reportingPharmacy and 3408 reportingRevenue cycle and payer mix reportingHIPAA and responsible healthcare datahandling Preferred experience with:AthenaOne reportingAthenaOne DataViewMicrosoft FabricOnelake, dataflows, or lakehouse conceptsSQL ServerTableauAzaraDRVSETLIELT tools such as Azure Data Factory, dbt, SSIS, Fivetran, Alteryx, or equivalent platformsData warehouse or lakehouse architectureBronze, silver, and gold datalayer conceptsRow-level security or role-based reporting accessPythonExcellent:Analytical problem solvingCommunication with technical and nontechnical stakeholdersCustomer service orientationDocumentation disciplineAttention to detailFollow-through and accountabilityAbility to work independently in a lean teamAbility to mentor and guide less senior anal¡ics resourcesAbility to translate complex data into actionable insight Required Education, Experience, Certifications, and Licenses:Bachelor's degree required; equivalent experience may be considered. Master's degree preferred.Degree fields may include:Health InformaticsHealthcareAdministrationData Anal¡icsData SciencePublic HealthFinanceInformation SystemsBusiness AnalyticsComputer SciencePharmacyOr related fieldsMinimum:5 years of experience in healthcare informatics, business intelligence, analytics development, reporting, data analysis, data engineering, or related healthcare data role.3 years of hands-on experience with Power BI, and snowflake-based reporting or analytics.Experience developing, validating, maintaining, or modernizing healthcare reports and dashboards.Experience translating stakeholder requirements into reporting solutions.