Open to opportunities

Dorian Connors

@dorianconnors

Message

I build governed data products and semantic layers that make reporting reliable and self-serve.

United States

Message

What I'm looking for

I'm looking to build governed, reusable data products that turn complex reporting into trusted self-service analytics, while working closely with stakeholders to define useful metrics and scalable workflows.

At Federated Hermes, I build layered Databricks data models and governed semantic layers that serve as the single source of truth for firm performance reporting. I turn recurring analyst requests into reusable data products, eliminating five manual reporting processes and enabling self-service dashboards in Power BI.

I bring 5+ years across investment management, digital consulting, and public accounting. At CliftonLarsonAllen, I delivered 75+ client engagements, designing future-state workflows, building SQL pipelines and dashboards, and communicating analytical findings to non-technical stakeholders.

I'm also building Punchlist, a production multi-tenant SaaS platform using React, Supabase, PostgreSQL, Stripe, and Vercel, with database-level tenant isolation and GitHub pull-request CI/CD.

Experience

Work history, roles, and key accomplishments

Current

Intermediate Data Transformation & Reporting Specialist

Current

Federated Hermes

Aug 2025 - Present (1 year 1 month)

Designs and maintains layered data models on Databricks, serving as the single source of truth for firm performance reporting. Owns the semantic layer, enforces data quality, and converts recurring analyst requests into reusable data products.

SQL Databricks Power BI Data Modeling Data Quality Python ETL ELT Semantic layer Documentation Lineage

Education

Degrees, certifications, and relevant coursework

Penn State Erie - The Behrend College

Bachelor of Science, Accounting

Bachelor of Science in Accounting with a minor in Management Information Systems from Penn State Erie - The Behrend College, completed in December 2020.