Informatics & Analytics Analyst Job – Dallas, TX

Our Core Values

• We are solution seekers.
• We have a can-do attitude.
• We are mission driven.
• We care about people.

Why You ll Love This Job

Position Summary

• The Informatics & Analytics Analyst provides hands-on reporting, analytics, data validation, documentation, and operational support across Prism Health North Texas  healthcare data and reporting environment.

• This role supports the Informatics function by assisting with:
• Clinical, financial, operational, pharmacy, quality, grants, and executive reporting
• Power BI dashboard support and enhancement
• Snowflake-based querying, validation, and analysis
• Report inventory, documentation, and data lineage
• Data quality review and source-to-report reconciliation
• KPI definition and Data Governance Committee support
• Recurring reporting and stakeholder request support
• The Informatics & Analytics Analyst helps ensure data and reports are accurate, timely, documented, and useful for decision-making. This position works closely with the Lead Healthcare Informaticist / Analytics Developer, IT, HIM, Clinical Operations, Quality, Grants, Finance, Pharmacy, Revenue Cycle, and executive stakeholders.
• This is not intended to be an entry-level reporting role. The position requires enough healthcare data, Snowflake, SQL, Power BI, Excel, and validation experience to contribute quickly while continuing to grow into more advanced healthcare analytics and informatics responsibilities.

REPORTING, ANALYTICS, AND DASHBOARD SUPPORT

• Support the development, maintenance, testing, and enhancement of Power BI reports and dashboards.
• Assist with recurring reports supporting clinical operations, quality, grants, pharmacy, finance, executive leadership, and operational departments.
• Modify existing reports and dashboards based on approved requirements and documented business needs.
• Support dashboard refreshes, data updates, filter adjustments, visual changes, and routine report maintenance.
• Assist with reports and dashboards related to:
• Provider productivity
• Patient access
• Clinical quality measures
• HRSA / UDS / grants reporting
• Pharmacy and 340B reporting
• Revenue cycle and payer mix
• Executive scorecards
• Population health and health equity
• Help identify duplicate, outdated, unused, conflicting, or unreliable reports.

SNOWFLAKE, SQL, AND SOURCE DATA SUPPORT

• Use Snowflake to query, extract, compare, and validate healthcare data.
• Write and modify SQL queries to support reporting, dashboard development, data validation, and discrepancy analysis.
• Support Athena One / Data View / Snowflake-based reporting and analytics.
• Help document source tables, fields, joins, filters, relationships, and reporting logic.
• Compare source-system outputs to Power BI dashboards, Athena One reports, exported files, SharePoint based reports, and stakeholder-maintained spreadsheets.
• Support investigation of discrepancies between Athena One reports, Snowflake/Data View queries, Power BI dashboards and manually maintained reporting sources.
• Escalate complex query, data model, data architecture, or source-system issues to the Lead Healthcare Informaticist / Analytics Developer.

DATA VALIDATION AND QUALITY ASSURANCE

• Validate report outputs against source systems, stakeholder expectations, prior reports, and documented business rules.
• Review data for accuracy, completeness, duplicate records, date-range errors, attribution issues, calculation issues, and missing values.
• Execute QA checklists for new, modified, and recurring reports.
• Assist in validating:
• Numerators and denominators
• Measure exclusions
• Date ranges
• Provider attribution
• Location attribution
• Payer groupings
• Encounter and visit logic
• Quality measure logic
• Document validation results, known issues, assumptions, and open questions.
• Track and escalate data quality issues requiring review, correction, or governance decisions.

POWER BI, EXCEL, AND DATA PREPARATION

• Support Power BI report development, maintenance, and testing.
• Use Excel for data analysis, reconciliation, comparison, cleanup, and validation.
• Use Power Query to clean, transform, and prepare data for reporting where appropriate.
• Support basic to intermediate DAX measures under the direction of the Lead Healthcare Informaticist / Analytics Developer.
• Help maintain report filters, slicers, relationships, refresh settings, and visual layouts.
• Test Power BI dashboards after data source, model, refresh, or calculation changes.
• Assist with the transition from spreadsheet-heavy reporting to more reliable Power BI and Snowflake supported reporting models.

REPORT INVENTORY, DOCUMENTATION, AND LINEAGE

• Maintain the enterprise report and dashboard inventory.
• Document report owners, business purpose, data sources, Snowflake objects, refresh frequency, distribution method,…