First Help FinancialData Engineer Manager
Mar. 2023• Implemented company-wide Snowflake Data Warehouse supporting risk, fraud, sales, and support analytics.
• Built and managed 120+ automated pipelines using Python, Rivery, Fivetran, and REST APIs.
• Developed scalable Salesforce-to-Snowflake integrations via Bulk API 2.0.
• Led integration of data from major credit bureaus, Oracle, MS SQL Server, and vendor API
• Designed and implemented a dimensional analytics layer using star schema principles, enabling consistent, reusable reporting across BI tools.
• Modeled core business processes into fact and dimension tables to standardize metrics and reduce redundant dashboard-specific transformations.
• Collaborated with analytics and business stakeholders to define grain, measures, and dimensions for loan, payment, customer, and risk datasets.
• Introduced shared fact tables and conformed dimensions to improve query performance, reduce Snowflake compute costs, and simplify downstream analytics.
• Established modeling standards and documentation to ensure clarity, reuse, and long-term maintainability of analytical datasets.
• Applied advanced Snowflake techniques including RBAC security design, zero-copy cloning, dynamic tables, GitHub-based CI/CD integration, Streams and Tasks for orchestration, Time Travel, clustering keys, materialized views, and performance tuning.
• Established the Data Engineering department from inception to a fully operational enterprise unit.
• Collaborated with business teams to ensure data quality, governance, and alignment with strategic goals.