Lead Data Analytics Engineer

* You will take ad-hoc business use cases and analyze the data warehouse and marts to enable business be data driven by helping them discover new insights
* You will understand Lending Club’s data usage, and deliver optimal data analysis
* You will identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, reduce Cloud cost, etc.
* You will work with stakeholders including the Business, Product, Program and Engineering teams to deliver required data in time with high quality at reasonable cost
* You will build and maintain robust, reusable, and well-documented data transformation pipelines using dbt, ensuring data models are version-controlled, tested, and easily understood across teams.
* You will work with technologies such as Snowflake, Tableau, Spark, Kafka, Presto etc. and cloud technologies across AWS stack
* Implement processes to validate and monitor data quality and support operations to manage the production environment and lead in resolving production issues with RCA
* Identify, design, and implement automated processes, optimizing analytics, re-designing infrastructure for greater scalability, etc.
* You will work closely with Quality Engineers, and lead products across all data use cases.

You will work closely with business teams to help them start to use our modern data and analytics stack. You will work with business analyst to help them query data on an ad-hoc basis
* 7+ years of solid production quality data analyst (Sql) helping business be data driven
* Hands-on experience developing and managing data models in dbt, including version control, testing, documentation, and deployment best practices.
* In-depth working experience of distributed systems distributed database with cloud experience. Working with Spark, Hive, Kafka, Airflow is a strong plus. Familiarity with Snowflake is a plus
* 6+ years of experience with OLTP and OLAP use cases at scale
* Experience working with public cloud platforms, preferably AWS
* Familiar with Agile methodology, test-driven development, source control management and automated testing
* Experience supporting and working with cross-functional teams in a dynamic environment
* Experience with technical leadership of products and teams
* You’re passionate about Big Data Analytics, Cloud, and transforming business to be data driven
* You have excellent listening skills and are empathetic to others
* You believe in simple and elegant solutions and give paramount importance to quality
* Passionate with good understanding of data, with a focus on having fun, while delivering incredible business results8+ years’ experience and bachelor's degree in computer science or a related field; or equivalent work experience8+ years of solid professional experience as a data analyst using data warehouses, and marts
** Work Location
** San Francisco    The above locations are eligible offices for this role. The locations have been determined to foster in-person collaboration with this role’s team or the related business lines. We utilize a hybrid work model, and our teams are in-office Tuesdays, Wednesdays, and Thursdays. In-person attendance is essential for this role’s success, and remote placement will not be considered. Lending Club offers relocation, based on actual job level.

** Time Zone Requirements
** Primarily PT    While the position will primarily work local hours, Lending Club is headquartered in Pacific Time and our ideal candidate will be flexible working across time zones when necessary.

** Travel Requirements
** As needed travel to Lending Club offices and/or other locations, as needed.

** Compensation
* * The target base salary range for this position is ,000. The base salary of the role will be determined by job-related knowledge, experience, education, skills, and location. Base salary is just one part of Lending Club’s Total Rewards package. You may also be eligible for long-term awards (equity) and an annual bonus (which is based on company performance, employee performance and eligible earnings).
We’re creating new financial services solutions for our members based on fairness, simplicity, and heart, and we treat our employees the same way. We offer a competitive benefits package that includes medical, dental and vision plans for employees and their families, 401(k) match, health and wellness programs, flexible time off policies for salaried employees, up to 16 weeks paid parental leave and more.
#LI-Hybrid   #LI-JH1
#J-18808-Ljbffr