Justin Palmer

Resume

Justin Palmer

.NET / Blazor Engineer Data Engineering EF Core • SQL Server

Builds secure ASP.NET Core/Blazor apps with EF/SQL; leads CI/CD in Azure DevOps; integrates analytics with Power BI (governed RLS, refresh & access automation).

Justin Palmer

Senior .NET / Blazor & Data Engineering

Secure ASP.NET Core delivery • Power BI Service admin (RLS, automation) • Azure Functions & ADF ELT • EF Core/SQL • Python & PowerShell.

Hillsboro, OH · justinraypalmer@gmail.com · https://justinraypalmer.com/

Experience

Senior Data Engineer / .NET Engineer (Business Intelligence Architect)
U.S. Department of the Treasury
Nov 2022 — Present • 2 yrs 11 mos
ex.Description
  • Own configuration, governance, testing, and packaging for Python/R across Azure VMs; automate secure package deployments and present change requests to Cybersecurity.
  • Built an AD password-expiry notification service + access dashboard (LDAP + T-SQL + Database Mail) showing security groups (incl. nested), DB permissions, and SSRS roles—used for audits and self-service troubleshooting.
  • Designed daily ETL + dimensional models (SSIS/SQL) for IRS ITM Learning powering 100+ reports/dashboards; documented in Markdown and transitioned to Azure DevOps for O&M.
Management & Program Analyst
Internal Revenue Service
Jun 2019 — Nov 2022 • 3 yrs 5 mos
ex.Description
  • Led the transition of IRS training analytics to Treasury’s warehouse; authored deltas/ETL requirements and consolidated 20+ PL/SQL scripts into a daily SQL model powering 50+ Power BI dashboards over 20M rows.
  • Developed .NET + SQL programs to reconcile HR payroll data across three enterprise systems; bi-weekly diffs drove architecture fixes and improved data integrity across platforms.
  • Published and maintained six HR dashboards with 50k+ cumulative views by 500+ stakeholders—self-service analytics reduced ad-hoc requests and cycle time.
Operations Research Analyst
Internal Revenue Service
Nov 2017 — Jun 2019 • 1 yr 7 mos
ex.Description
  • Replaced ~$3M legacy tool with a custom org-charting app (Visio/SharePoint/Excel/VBA) encoding IRS HR hierarchy rules; trained teams and drove adoption.
  • Automated the ‘Workforce Snapshot’ Tableau product—ten charts previously compiled quarterly now refresh every pay period.
  • Delivered R-based analyses and automation for outliers/forecasts; scripted performance-plan timeliness reporting from SharePoint flat files.

Selected Projects

  • Azure Function Apps for user lifecycle & governance; pipelines to capture Power BI activity for audit dashboards.
  • ADF ELT and orchestration integrating line-of-business sources into dimensional models; EF Core APIs.
  • Enterprise RLS patterns with security tables; automated refresh/access flows; capacity hygiene and tuning.

Highlights

  • Lead engineer for Treasury’s shared analytics platform serving 250+ devs/analysts.
  • Migrated 600+ projects to Azure DevOps; standardized Repos/Boards/Wikis/Pipelines.
  • Admin for Power BI Service & Report Server (upgrades, tuning, uptime).
  • Built production ADF ELT & .NET Azure Functions for automation/integration.
  • Own enterprise RLS patterns and security tables; automate refresh/access.

Experience

Senior Data Engineer / .NET Engineer (Business Intelligence Architect)
U.S. Department of the Treasury
Washington, DC
Nov 2022 — Present • 2 yrs 11 mos

Lead engineer for Treasury’s shared virtual analytics environment (250+ users). Deliver secure, data-driven .NET solutions, Python/R runtime governance, dimensional modeling, and automation across Azure/Power BI.

  • Own configuration, governance, testing, and packaging for Python/R across Azure VMs; automate secure package deployments and present change requests to Cybersecurity.
  • Built an AD password-expiry notification service + access dashboard (LDAP + T-SQL + Database Mail) showing security groups (incl. nested), DB permissions, and SSRS roles—used for audits and self-service troubleshooting.
  • Designed daily ETL + dimensional models (SSIS/SQL) for IRS ITM Learning powering 100+ reports/dashboards; documented in Markdown and transitioned to Azure DevOps for O&M.
  • Wrote a C#/.NET data-quality comparator that web-scrapes IRS report metadata, reconciles Treasury’s HR warehouse, persists diffs to SQL, and visualizes KPIs via Power BI.
Management & Program Analyst
Internal Revenue Service
Cincinnati, OH
Jun 2019 — Nov 2022 • 3 yrs 5 mos

Drove HR analytics modernization and enterprise reporting—architected data models, automated ETL, and delivered high-impact dashboards consumed by executives and analysts.

  • Led the transition of IRS training analytics to Treasury’s warehouse; authored deltas/ETL requirements and consolidated 20+ PL/SQL scripts into a daily SQL model powering 50+ Power BI dashboards over 20M rows.
  • Developed .NET + SQL programs to reconcile HR payroll data across three enterprise systems; bi-weekly diffs drove architecture fixes and improved data integrity across platforms.
  • Published and maintained six HR dashboards with 50k+ cumulative views by 500+ stakeholders—self-service analytics reduced ad-hoc requests and cycle time.
  • Built automated COVID-19 data pipelines (JHU GitHub + CDC APIs) to ingest, transform, and publish datasets via SQL jobs/shared drives.
Operations Research Analyst
Internal Revenue Service
Cincinnati, OH
Nov 2017 — Jun 2019 • 1 yr 7 mos

Built decision-support tools, automated analytics, and workforce visualization used by leadership each pay period.

  • Replaced ~$3M legacy tool with a custom org-charting app (Visio/SharePoint/Excel/VBA) encoding IRS HR hierarchy rules; trained teams and drove adoption.
  • Automated the ‘Workforce Snapshot’ Tableau product—ten charts previously compiled quarterly now refresh every pay period.
  • Delivered R-based analyses and automation for outliers/forecasts; scripted performance-plan timeliness reporting from SharePoint flat files.
  • Built a UI-Automation + HTML Object Library scraper to ingest 457 paginated HR records automatically into curated datasets.
Internal Revenue Agent
Internal Revenue Service
Cincinnati, OH
Sep 2009 — Nov 2017 • 8 yrs 2 mos

Subject-matter expert and knowledge-management leader for the Exempt Organizations program; training, policy, and process improvement.

  • Led knowledge network analysis and training for EO; delivered technical training to 250+ agents, cutting related field questions by >50%.
  • Automated KM metrics/reporting (monthly/quarterly/annual) enabling program effectiveness tracking.
  • Authored official guidance adopted by the Service (guide sheets + three issue snapshots) and released publicly.
  • Acted as front-line manager and SME across multiple 501(c) domains; briefed senior leaders and coordinated complex resolutions.

Education

Master of Business Administration (MBA)
Murray State University
Murray, KY, United States
Dec 2010 — Dec 2012 • 2 yrs

MBA with a 4.0 GPA; emphasis in finance, strategy, and analytics.

Bachelor of Science, Accounting
University of Kentucky
Lexington, KY, United States
Aug 2006 — Aug 2009 • 3 yrs

BS in Accounting with strong foundations in financial reporting, auditing, taxation, and information systems.

Skills

Languages & Frameworks
C# / .NET ASP.NET (Server & WASM) Python T-SQL R PowerShell Razor/Blazor REST APIs LINQ
Data & BI
SQL Server / SQLite EF Core SSIS Postgres Power BI (Service/RS, RLS) DAX Dimensional Modeling
Cloud & DevOps
Azure Azure DevOps (Repos/Boards/Wikis/Pipelines) CI/CD Git Azure Functions Azure Data Factory
Security & Delivery
CSP / Headers / Validation Antiforgery Rate Limiting Agile / Scrum Mentoring & Reviews

Certifications

An unhandled error has occurred. Reload 🗙