Freelance Pharmacy Tech Informatics Jobs in Dallas, TX

Job Description: Our 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 reporting SQL development and source-to-report validation Power BI dashboard development Power BI semantic model design DAX and Power Query development Healthcare reporting logic and KPI standardization. Report inventory, documentation, QA, and certification support Data 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 scorecards Population 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 MODELING Use 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 MODELING Build 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 CERTIFICATION Lead 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 denominators Measure exclusions Date ranges Provider attribution Location attribution Payer groupings Encounter and visit logic Pharmacy and 340B logic Grants, 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 STANDARDIZATION Support 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: Encounters Visits Unique patients No-show rate Provider productivity Clinical FTE wRVU / productivity-related measures Payer mix Quality measures UDS measures Pharmacy and 340B measures Help reduce multiple versions of truth by aligning reports to approved definitions, certified datasets, and documented logic. REPORT INVENTORY, DOCUMENTATION, AND LINEAGE Lead 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 REPORTING Support 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 ANALYTICS Develop 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 PARTNERSHIP Lead 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 MENTORSHIP Provide 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 MATURITY Identify 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: None Required Skills Required Knowledge, Skills, and Abilities: Advanced proficiency in: Snowflake QL querying and troubleshooting Power BI dashboard development DAX Power Query Data modeling and semantic model design Data validation and source-to-report reconciliation Healthcare reporting and analytics Report QA and UAT Requirements gathering and stakeholder communication Experience 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 standardization Working understanding of: EHR reporting concepts AthenaOne I DataView-style reporting environments Clinical operations reporting Provider productivity reporting Quality measure reporting HRSA / UDS / grants reporting Pharmacy and 3408 reporting Revenue cycle and payer mix reporting HIPAA and responsible healthcare datahandling Preferred experience with: AthenaOne reporting AthenaOne DataView Microsoft Fabric Onelake, dataflows, or lakehouse concepts SQL Server Tableau AzaraDRVS ETLIELT tools such as Azure Data Factory, dbt, SSIS, Fivetran, Alteryx, or equivalent platforms Data warehouse or lakehouse architecture Bronze, silver, and gold datalayer concepts Row-level security or role-based reporting access Python Excellent: Analytical problem solving Communication with technical and nontechnical stakeholders Customer service orientation Documentation discipline Attention to detail Follow-through and accountability Ability to work independently in a lean team Ability to mentor and guide less senior anal¡ics resources Ability 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 Informatics HealthcareAdministration Data Anal¡ics Data Science Public Health Finance Information Systems Business Analytics Computer Science Pharmacy Or related fields Minimum: 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.