DATA ENGINEERING • ANALYTICS • BI • PIPELINE AUTOMATION

Engineering data systems
behind scalable analytics.

Hands-on Senior Data Engineer & BI Developer turning complex data streams into production ETL/ELT pipelines, enterprise data warehouses, and decision-support systems.

Hidden throughout this page: 2 data jokes, 1 law joke, and 1 hidden easter egg. Scroll to explore!

SCROLL TO EXPLORE ↓

Reliable data engineering
takes disciplined execution.

I design, build, and maintain the underlying infrastructure that transforms raw transactional data into high-leverage business intelligence.

With an advanced technical foundation across SQL, Python, Databricks, Snowflake, and multi-database architectures—complemented by a JD/MBA background—I specialize in translating complex financial, operational, and healthcare rules into seamless, automated data pipelines that drive good decisions.

STEPHEN JENSEN (JD/MBA)SENIOR DATA ENGINEER & BI DEVELOPER
8+YEARS IN DATA
100+DATA PIPELINES & ETLS
250+PROCESS AUTOMATION PIPELINES
93.5%PROCESS TIME REDUCTION
2K+PRODUCTION PYTHON SCRIPTS
100+FINANCIAL & BI DASHBOARDS
30+CONTRACT & PROVIDER TIERS
0CLOUD DEPENDENCY HOMELAB

(Fluent in SysAdmin)

Hands-on stack
built for performance.

Technical depth across pipeline engineering, database architecture, decision support systems, and process automation.

1

Data Pipeline & ETL Engineering

Python, SQL, Databricks DABs, dbt Models/Macros/Sources, SparkSQL, ADF, web scrapers, standardized logging tables, automated auditing, and low-latency API integration.

2

Enterprise Warehousing & Architecture

Kimball Star-Schema dimensional modeling, Medallion Architecture, sandbox warehouse setups, Databricks, PostgreSQL, Oracle, SSMS, Snowflake, and BigQuery.

3

BI & Decision Support Systems

PowerBI, Tableau dashboard development, Looker/LookML data governance layers, Excel VBA/Power Pivot routines, and analyst self-service tooling enablement.

4

Process & Workflow Automation

RPA deployment, CMS Relative Value ingestion and calculations, complex physician compensation modeling, SQL Server Agent scheduled jobs, and Git/JIRA workflow tracking.

Python pandas scikit-learnrequestsbeautifulsoupfastapiNiceGUI & Streamlitcustom packagescustom packages SQLCTEssubqueriesquery optimizationindicies left, inner, outer, cross joins Two tables walk into a bar. One asks the other, "Mind if I JOIN you?" temp tablesStored ProceduresMaterialized Views DatabricksSnowflakeBigQueryQuestDBPostgreSQLSSMSMariaDBMySQL dbt - Data Build ToolAirflowDeclarative Asset Bundlesmetadataauditing TableauPower BIMS Excel/Google SheetsVS CodeWindows and LinuxDockerProxmox / Hypervisors / High AvailabilityVMS and ContainersCLI - Command Line Interface LLMs An AI walks into a bar, and the bartender says, "Sorry, we don't serve your kind here." The AI responds, "That's okay, I'm here to update your software. You're about to become very accommodating." RAGChunkingEmbeddingsVector DatabasesContext InjectionMarkdown GitAzureDevOpsOneDevforgejoclonecommitpushpull requests NetworkingUplink, Trunk, Access PortsSwitch StackingLACP BondsVLANsFirewall RulesVPNsSANNASNVMEoFiSCSISMBNFS

Hands-on
engineering roles.

Production data engineering, analytics, and BI execution across high-scale enterprise environments.

1
MAR 2025 — PRESENT PETS BEST INSURANCE / IPH / DOUBTLESS Raleigh, NC / Remote

Senior Data Scientist / Senior Data Engineer

  • ETL & Integration Engineering: Engineered extensive SQL and Python scripts to develop enterprise ETL pipelines, including an external integration table ('Golden Record Table') consolidating veterinary hospital master data across systems.
  • Automated Auditing & Processing: Built internal SQL/Python data pipelines for automated claim resolution and automated payment audits; developed direct Outlook inbox scraping for medical record tracking and processing.
  • Web Scraping & Product BI: Constructed custom Web/HTTP scraper pipelines to automatically download insurance rate filings from SERFF for product competitive analysis, pricing elasticity metrics, and customer retention modeling.
  • Warehouse Infrastructure & Logging: Stood up the first analytics sandbox database in company history; established a standardized logging table structure for end-to-end ETL flow tracking and created the company's first data engineering Git repository.
  • Databricks & BI Visualization: Served as primary in-house Databricks developer; connected analytics sandbox tables directly to PowerBI to deliver self-service visualization for commercialization and product teams.
  • Teammate Enablement & UI Tools: Designed custom Python modules to grant non-technical analysts simplified access to reusable ETL functions; developed a custom UI for customer service teammate oversight and audit tracking.
DatabricksPythonSQLdbtWeb ScrapingNiceGUI/StreamlitETL LoggingPowerBIADO
2
JUL 2022 — MAR 2024 EBAY INC. San Jose, CA / Draper, UT

Policy Analytics Specialist | Senior Analytics Specialist

  • Big Data & SparkSQL Development: Authored optimized SparkSQL scripts against Hadoop clusters to extract and analyze massive transactional datasets, supporting complex risk, financial, and policy impact analytics.
  • A/B Testing & Policy Forecasting: Designed, executed, and analyzed A/B testing models to forecast the financial impact of proposed changes to Seller Protection policies and risk management products.
  • Automated ETL & RPA Deployment: Architected, documented, and deployed multiple automated ETL pipelines; utilized in-house tools to design and roll out 10+ Robotic Process Automation (RPA) flows across operational processes.
  • Cross-Functional Teammate Execution: Collaborated closely with Risk, Product, and Engineering teams to implement product/policy modifications, while wordsmithing technical documentation with Content and Legal teams.
SparkSQLHadoopA/B TestingRPAPythonJIRASQL
3
NOV 2020 — AUG 2022 YOUNG LIVING ESSENTIAL OILS Lehi, UT

Senior BI & Financial Data Developer

  • Multi-Database Engineering: Engineered data solutions and analytics pipelines across diverse database enterprise architectures, including SSMS, Oracle, JDE, Snowflake, PostgreSQL, and BigQuery.
  • Financial & Operational Dashboards: Developed backend SQL data models and interactive Tableau dashboards for 100+ strategic financial and operational analyses, partnering across Marketing, Operations, Sales, and Growth.
  • Automated Reporting Workflows: Constructed SQL scripts and VBA automation routines to streamline repetitive reporting processes, presenting accurate financial performance metrics to executive stakeholders.
SnowflakeOraclePostgreSQLTableauBigQuerySSMSVBA

Complex automation
& custom pipelines.

Volunteer and specialized technical consulting deliverables solving complex data processing bottlenecks.

★
MAY 2023 — OCT 2026 JEFFERSON REGIONAL MEDICAL CENTER Volunteer Technical Consultant

Lead BI & Data Automation Consultant | Physician Compensation Pipeline

  • Healthcare Data Automation: Designed and deployed end-to-end provider compensation automation covering 40+ physicians across 2 payment types, 30+ contract start dates, multiple RVU tiers, CPT code modifiers, and annual/quarterly/monthly bonus schedules.
  • Process Optimization (93.5% Cycle Reduction): Reduced total physician compensation processing time from ~800 manual minutes to just 52 automated minutes per cycle—achieving 100% processing accuracy (0 errors) consistently over a 3-year period.
  • Full-Stack Data Engineering: Created SQL Server Agent jobs to regularly ingest CMS Relative Values and apply internal modifiers; staged refined tables into PowerBI and Tableau dashboards with automated PDF and Excel report generation.
Healthcare BISQL Server AgentCMS Relative ValuesPowerBITableauVBA

Academic
foundation.

Rigorous legal, business, and analytical training underpinning rigorous technical execution.

1
JURIS DOCTOR TEXAS TECH UNIVERSITY School of Law • Lubbock, TX

Juris Doctor (JD – Law What is the difference between a good and bad lawyer? A bad lawyer might drag your case on for years. A good lawyer WILL drag your case on for years. ) | Corporate & Health Law

Only student of 225 to graduate with dual degree in 2.5 years

1 of only 10 students to graduate early

Interesting: In early 2015, I wrote a Global Biosecurity paper suggesting that prophylactic research on dangerous/weaponized diseases (the exceptions provided by the Geneva Convention for bioweapons) posed a significant risk to the human population, and that greater international oversight/data sharing on research was necessary to prevent serious adverse events like outbreaks or epidemics.

Corporate LawHealth LawDual Degree
2
MASTER OF BUSINESS TEXAS TECH UNIVERSITY Rawls College of Business • Lubbock, TX

Master of Business Administration (MBA)

Graduate degree in business administration focused on strategic management and organizational leadership.

Interesting: In 2014, I presented to my Informations Systems class about a proposed "computer program trained on interrelated words in the English dictionary to derive context" that could understand legal claims based on the language someone presented, guide them in what they needed to do, and forward them to a practicing attorney if the law was too complex.

Business AdministrationManagementStrategy
3
BACHELOR OF SCIENCE UTAH VALLEY UNIVERSITY Orem, UT

Bachelor of Science | Business Management / Administration

Undergraduate degree in Business Management / Administration with a minor in Chemistry.

Interesting: I took Physical Chemistry (among others) and calculated the difference in temperature from the top of a waterfall and the bottom of waterfall by using heat capacity of water and kinetic/potential energy conservation.

Business ManagementAdministrationChemistry Minor