Social Finance, LLC

Job Duties: Design and build a data warehouse using computingbased data cloud (Snowflake) for machine learning, data analysis, self-serve analytics and reporting needs. Develop Extract, Transform, Load (ETL) pipelines to orchestrate execution of scripts, automate data transformation and loading data into data warehouses. Perform data cleansing, validation, testing and schema design to ensure accuracy and reliability of data insights. Manage and build automated workflows and monitor these pipelines and DAGs (Directed Acyclic Graphs). Identify and work on improvements by automating manual processes to optimize data delivery, re-design infrastructure for more scalability using python & sql. Collaborate with cross-functional teams including data engineers, analysts and data scientists to understand the business logic and needs to create an effective and efficient pipeline and data model. Create ad-hoc report/data visualizations based on user requirements. Participate in ETL flow design reviews and recommend solutions to improve processes. Perform data quality checks and alerting to identify issues and resolve bugs in a timely manner. Participate in source code and design reviews in a software development lifecycle (SDLC) driven environment using technical, functional, and domain knowledge. Identify issues or gaps and suggest improvements to the team processes. Provide support for customer requests for all the products handled by the team. Full-time telecommuting is an option. Minimum Requirements: Masters degree (or its foreign degree equivalent) in Analytics, Data Science, Engineering (any field), or a related quantitative discipline, and six (6) months of experience in the job offered or in any occupation in related field. Special Skill Requirements: 1. Data warehouse design and dimensional modeling 2. Extract, Transform, Load (ETL) 3. SQL 4. Python 5. Data Visualization (Tableau or Power BI) 6. Gitlab 7. Azure 8. PySpark 9. OLAP and OLTP system experience (MySQL Database, Postgres DB, or Snowflake) 10. Machine Learning 11. Data Pipeline - Performance & Scalability Techniques. Any suitable combination of education, training and/or experience is acceptable. Full-time telecommuting is an option. Salary: $177,813.00 - $195,594.00 per annum. Submit resume with references to: Req.# 53.2 at: ATTN: HR,

Job Duties: Own the card/credit & debit card transaction fraud prevention strategies. Perform data analytics to support the credit card business from fraud losses. Aggregate and synthesize data sets from multiple data environments. Analyze complex datasets to understand aggregate performance of fraud decisioning and granular performance of multiple decision methods. Develop new data driven rules that optimize decisioning performance between Member experience and fraud prevention. Work with external fraud prevention vendors to optimize their performance. Work with business teams, operations, and product teams to implement new fraud prevention-oriented features. Analyzing complex datasets to understand aggregate performance of fraud decisioning and granular performance of multiple decision methods. Part-time telecommuting is an option. Hybrid work from company office in San Francisco, CA. Minimum Requirements: Masters degree or foreign equivalent in Business Analytics, Finance, or related field, and two (2) years of experience in the job offered or any occupation in a related field. Special Skill Requirements: (1) Performing financial data analysis; (2) Decision tree models; (3) Time series forecasting; (4) A/B testing; (5) Multivariate analysis; (6) Principal component analysis; (7) SQL; (8) Linear and logistic regression. Any suitable combination of education, training and/or experience is acceptable. Skills may be gained through academic coursework or employment experience. Part-time telecommuting is an option. Hybrid work from company office in San Francisco, CA. Salary: $179,882.33 - $197,870.56 per annum. Submit resume with references to: Req.# 346.2 at: ATTN: HR,