Senior Analytics Engineer – Finance
SMBC / Thermo Fisher / Amazon / Enterprise Finance Platforms
San Jose, CA
- Owned end-to-end KPI integrity for executive, audit, and investor-facing reporting.
- Designed certified KPI layers with approval workflows for public and executive communications.
- Partnered with IR, FP&A, and Internal Audit to validate financial and operational KPIs.
- Designed ICFR-compliant data flows with immutable raw data, versioned transformations, and reconciliation checkpoints.
- Supported SOX / ITGC audits by providing traceability from source systems to fact tables and dashboards.
- Automated reconciliation across Data Lake, Financial Data Warehouse, Analytics Marts, and ERP / ARCS.
- Designed finance-grade star and snowflake schemas for revenue, cost, gross margin, and unit economics.
- Built canonical fact tables at trade / usage / event grain with conformed dimensions.
- Implemented SCD Type-2 dimensions to preserve historical accuracy.
- Built and optimized analytics platforms on BigQuery, Snowflake, and Redshift, balancing performance and cost.
- Tuned queries using partitioning, clustering, indexing, and workload isolation techniques.
- Managed database operations including performance monitoring, access control, and incident resolution.
- Orchestrated ingestion, transformation, reconciliation, and publishing workflows using Airflow.
- Designed tiered refresh strategies to balance cost, data freshness, and finance certification.
- Built secure APIs using OAuth 2.0, service accounts, and RBAC for ingesting financial and operational data.
- Implemented schema validation, deduplication, idempotency, and error handling.
- Mentored junior engineers on SQL, data modeling, and analytics engineering best practices.
- Acted as analytics representative in executive, audit, and cross-functional discussions.