Analytics Engineer - Finance

Lambda•San Francisco, CA

11d•Hybrid

About The Position

Join our team as a Analytics Engineer - Finance , where you will collaborate with a small, high-performing team of Data Analysts and Data Engineers to design data pipelines, a data warehouse, an automated data catalog and internal tools on a Data Platform team. You will be a thought-leader on how Lambda manages its BI layer, building tested, verified, documented data pilelines, training users who are hungry to learn about data tools, and setting up Lambda to scale up during a hyper-growth period. The Data Platform team is specifically targeting candidates with demonstrable experience with ICFR; providing financial or fundraising-supporting data with strong data governance processes. The role will report to the Data Platform Manager.

Requirements

Have a Bachelor’s degree in Information Systems, Business Administration, Data Analytics, Finance or a related field, Master’s preferred.
Have 7+ years of professional experience in BI and data analytics or analytics engineering
Have demonstrated experience working with an IR, FP&A, or executive team on financial and operational business KPIs
Have demonstrated experience working within ITGCs (IT General Controls) and ICFR (Internal Controls over Financial Reporting)
Have advanced SQL skills and ability to mentor junior team members
Have advanced data visualization and data presentation skills
Have 2+ years of experience modeling in DBT and contributing to a Github repository
Have exemplary soft skills: Excellent communication, problem-solving, and leadership abilities.
Work well in a small team environment and can prioritize projects in an agile way and lead agile ceremonies

Responsibilities

Manage public KPI data integrity: Ensure that Lambda has cleaned, approved KPIs in its marketing materials, publications, and investor communications
Support ICFR: Work with internal audit team to verify data flows and metrics and ensure data integrity of key data points
DBT / Data Catalog / Governance: Become a subject matter expert in data models and clean data at Lambda, supporting executive level data sets and cleanliness controls.
Data modeling: Have a strong understanding of concepts like star schemas, snowflake schemas, Kimball modeling, data cubes, and an ability to fluently discuss efficient data warehousing
Data warehousing: Become a subject matter expert and contributor to a best-in-class cloud data warehouse (BigQuery)
Leadership: Lead and mentor junior members of the team in KPI development, data testing, stakeholder management and project management skills. Be a spokesperson for the team in high profile stakeholder meetings.
User Training & Enablement: Develop and deliver training programs to empower users, fostering a self-service BI environment and enhancing data literacy across the organization.
Analytics Development: Design and maintain analytics tools, dashboards, and reports to support cross-functional teams in achieving their objectives. Guide users in the appropriate tools for the appropriate data use case (Tableau, sheets, operational systems, SQL, etc)
Performance Monitoring: Continuously monitor and improve tool performance, scalability, and reliability across the data stack.
Innovation: Stay abreast of industry trends and emerging technologies to recommend innovative solutions.
Collaboration: Partner with stakeholders to understand requirements and deliver tailored solutions.
Documentation: Maintain comprehensive documentation of BI tools, processes, and best practices.