Open to opportunities

Kathryn Douglass

@kathryndouglass

Message

Data Analyst transforming complex data into actionable BI through SQL, Power BI, and automated reporting.

United States

Message

What I'm looking for

I’m looking for a role where I can deliver actionable insights with SQL and Power BI, automate reporting end-to-end, and collaborate with stakeholders to improve KPIs, operations, and compliance through data-driven decisions.

I’m a Data Analyst with 12+ years of hands-on experience transforming data into actionable business insights across healthcare, nonprofit, and logistics. I turn messy inputs into KPI dashboards and revenue cycle visibility by streamlining reporting, automating workflows, and using statistical thinking to solve complex problems.

In recent roles, I built and maintained grant reporting systems using Power BI, SQL, and Alteryx, and independently mastered new platforms like NextGen and HMIS. I’ve also automated recurring SQL/Excel reporting, led finance and business analytics for KPIs and denials, and supported pricing optimization across 100+ storage sites.

Experience

Work history, roles, and key accomplishments

Business Intelligence Analyst

Colorado Coalition for the Homeless

Feb 2022 - Jun 2022 (4 months)

Built and maintained grant reporting systems using Power BI, SQL, and Alteryx, delivering data-driven insights to leadership for operations and compliance. Independently ramped up on NextGen and HMIS to support accurate reporting.

Power BI SQL Alteryx HMIS Grant Reporting

Revenue Cycle BI Analyst

Amerita Inc.

Oct 2018 - Oct 2020 (2 years)

Automated recurring revenue cycle reports using SQL and Excel (macros and embedded data connections) to support accurate, timely operations reporting. Identified reporting gaps and delivered tailored BI solutions for stakeholders.

SQL Revenue Cycle Analysis Data Validation

Pricing and Revenue Management Analyst

National Storage Affiliates

May 2018 - Oct 2018 (5 months)

Managed pricing strategy for 100+ storage sites nationwide, supporting revenue optimization. Performed SQL-based ad hoc analysis to support pricing optimization and collaborated with field and corporate teams to maintain data accuracy.

SQL Ad hoc Analysis Pricing Strategy Revenue Management

Data Analyst - Finance & Analytics

Radiology Imaging Associates

Feb 2016 - Feb 2018 (2 years)

Led finance analysis and reporting on KPIs, denials, and physician quality performance. Built automated Excel and VBA dashboards and streamlined data collection and reporting processes across multiple departments.

Excel VBA SQL KPIs Financial Reporting Process Automation Data Visualization Statistical Analysis