Jake Gussler

Background

About Jake Gussler

I’m an Analytics Engineer building multi-tenant analytics platforms for pharmaceutical SaaS clients—owning end-to-end architecture across Snowflake, dbt, and Microsoft Fabric/Power BI.At Riparian (Envision Pharma Group), I’ve helped scale a standardized reporting platform supporting 50+ pharmaceutical clients, replacing ad hoc SQL workflows with governed, self-service datasets and saving ~30–40 hours/month of manual work for one team alone. I’ve also built the onboarding and delivery infrastructure (orchestration + automated deployments + environment patterns) that made enterprise-scale reporting rollout feasible—helping enable a multi-million-dollar client engagement.What I own and deliver: • Government Pricing analytics layer (end-to-end): 200+ dbt models, curated Snowflake marts, a governed Power BI semantic model, and production reporting outputs built from complex MongoDB-source data • Governed semantic model + reporting: 40+ fact/dimension tables and 60+ Power BI & paginated reports with standardized measures, drill-through, historical trends, and validation views—reducing off-system Excel quality issues and accelerating review cycles • Metadata-driven orchestration: tag-based selectors + Snowflake metadata + encrypted key management to run pipelines per app/client with zero code changes to onboard new clients • Automated Fabric deployments: Python framework using REST APIs + YAML manifests + dependency resolution, reducing deployments from 45+ manual hours per application to under an hour while automating connections and refresh scheduling across client workspaces • Standards & enablement: medallion architecture, Kimball-aligned star schemas, shared dbt macros, Git-based workflows, and deployment processes for a team of 5+I thrive in autonomous environments where I can design, build, and operate systems in production. Open to Analytics Engineer roles where platform ownership and measurable delivery matter.