Senior Data Analyst – Analytics Engineering - FTI Consulting - Remote
(2023-01)
Stack: dbt, Snowflake, Airflow, Python, Looker, SQL, Fivetran, Git
- Architected end-to-end dbt-based analytics engineering framework across 12+ source systems, reducing data transformation latency by 67% and eliminating over 4,000 lines of redundant SQL logic.
- Designed and deployed modular, layered data models (staging, intermediate, mart) in Snowflake that serve as the single source of truth for 300+ downstream dashboards consumed by litigation and forensic consulting teams.
- Built automated data quality testing suite (dbt tests + Great Expectations) catching 98.4% of upstream anomalies before reaching production, directly reducing client report error rate from 11% to under 1%.
- Led migration of legacy ETL pipelines from SSIS to modern ELT stack with Fivetran + Airflow, cutting pipeline maintenance overhead by 55% and improving SLA adherence to 99.7%.
- Collaborated with FTI's forensic investigation teams to build bespoke financial anomaly detection models in Python (scikit-learn), surfacing $14M+ in flagged transactions across three active legal matters.
- Standardized metadata documentation and data lineage tracking using dbt Docs and Monte Carlo, enabling self-service data discovery across 40+ data consumers.
- Mentored team of 4 junior analysts in SQL best practices, dbt workflow, and version-controlled analytics development, cutting onboarding time from 6 weeks to 2 weeks.
- Presented analytics architecture decisions and pipeline performance metrics to VP-level stakeholders on a monthly basis, influencing a $2.1M investment in data infrastructure modernization.
Senior Product Data Analyst - Humana - Remote
(2021-06 - 2022-12)
Stack: Python, SQL, Tableau, Mixpanel, Big Query, Jira, Confluence, dbt
- Owned end-to-end product analytics function supporting Humana's digital health platform serving 4.2M+ plan members, defining and tracking 60+ product KPIs across acquisition, engagement, and retention funnels.
- Designed and analyzed 22 A/B and multivariate experiments across web and mobile surfaces, resulting in a cumulative 18.3% improvement in member portal engagement and a 9.4% reduction in care navigation abandonment.
- Built self-service Tableau dashboards and Big Query semantic layer enabling product managers and clinicians to independently explore member behavior data by reducing ad hoc analytics requests to the data team by 43%.
- Partnered with engineering to instrument 35+ new product events using Mixpanel SDK, creating comprehensive behavioral tracking coverage across the member app and enabling funnel visualization for the first time.
- Developed predictive churn model (Random Forest, Python) identifying at-risk members 60 days in advance with 81% accuracy, enabling proactive outreach that improved 12-month retention by 6.2 percentage points.
- Translated complex healthcare data analysis into executive narratives and product roadmap recommendations, directly influencing $3.8M in feature investment decisions across two fiscal quarters.
- Collaborated cross-functionally with UX, clinical, and actuarial teams to ensure data models accurately reflected healthcare compliance requirements (HIPAA, CMS) while remaining analytically actionable.
- Established product analytics center of excellence authored 30+ internal documentation articles and conducted bi-weekly office hours adopted by 6 product squads.
Senior Business Data Analyst - Geisinger - Remote
(2019-03 - 2021-05)
Stack: SQL Server, Power BI, Excel, Python, Alteryx, Tableau, SSRS
- Served as primary analytics partner for Geisinger's enterprise transformation initiative, supporting $220M cost optimization program by delivering weekly operational scorecards and variance analysis to C-suite leadership.
- Designed and maintained 25+ Power BI dashboards and SSRS reports across clinical operations, revenue cycle, supply chain, and workforce management functions replacing 60+ legacy Excel-based reports.
- Built Alteryx-based automated data preparation workflows processing 8M+ patient encounter records monthly, reducing manual data preparation time by 78% and enabling real-time operational decision-making.
- Partnered with clinical informatics and IT teams to define enterprise data dictionary and standardize 140+ business metrics, resolving long-standing data consistency issues that had impacted board-level reporting accuracy.
- Led requirements gathering and stakeholder alignment for a system-wide BI governance framework, successfully adopted by 7 service lines and reducing duplicative reporting efforts estimated at 1,200+ analyst hours annually.
- Conducted root cause analysis on a revenue leakage issue identified through claims data modeling, recovering $4.7M in improperly denied reimbursements through corrected coding and appeals process.
- Developed workforce capacity planning model integrating HR, scheduling, and patient volume data, enabling 14% reduction in overtime expenditure while maintaining 98.2% patient service level targets.
- Trained 45+ clinical and administrative staff on Power BI report consumption and basic data literacy, achieving 91% self-service adoption rate within 6 months of deployment.
Senior Marketing Data Analyst - Group O - Remote
(2017-08 - 2019-02)
Stack: R, SQL, Google Analytics, Salesforce, Tableau, HubSpot, SAS
- Led marketing analytics functions across digital, direct mail, and programmatic advertising channels for Group O's B2B and B2C client portfolio managing analytics delivery for campaigns with combined annual spend of $47M.
- Built unified attribution modeling framework (data-driven multi-touch attribution using Shapley values in R), replacing last-click model and reallocating $8.2M in budget to 34% higher-ROI channels.
- Designed customer segmentation model using k-means clustering and RFM analysis across 2.3M customer records, enabling hyper-personalized campaign targeting that lifted email open rates by 27% and conversion rates by 19%.
- Integrated Salesforce CRM data with Google Analytics and marketing platform data via SQL ETL pipelines, creating closed-loop reporting that connected campaign investment to revenue outcomes for the first time.
- Developed competitive benchmarking dashboards in Tableau for 8 major brand clients, synthesizing paid media performance, share of voice, and audience overlap data into strategic quarterly business reviews.
- Ran weekly marketing analytics standups with creative, media, and strategy teams translating data findings into campaign optimization recommendations adopted in 89% of review cycles.
- Produced executive-level marketing performance reports and board presentations for three enterprise accounts, cited by client leadership as instrumental in contract renewals worth $6.4M combined.
- Authored and implemented Marketing Data Quality Standards playbook adopted by 12-person analytics team, reducing data discrepancy incidents between platforms by 74% within 90 days.
