Staff Analytics Engineer

Palo Alto, CA, United States

ABOUT EARNIN

As one of the first pioneers of earned wage access, our passion at EarnIn is building products that deliver real-time financial flexibility for those with the unique needs of living paycheck to paycheck. Our community members access their earnings as they earn them, with options to spend, save, and grow their money without mandatory fees, interest rates, or credit checks. Since our founding, our app has been downloaded over 13M times and we have provided access to over $15 billion in earnings.

We’re fortunate to have an incredibly experienced leadership team, combined with world-class funding partners like A16Z, Matrix Partners, DST, Ribbit Capital, and a very healthy core business with a tremendous runway. We’re growing fast and are excited to continue bringing world-class talent onboard to help shape the next chapter of our growth journey.

POSITION SUMMARY

This is a high impact role within the AI & Data team. You will work across teams, help drive data-driven decisions and own the automated reporting systems. You will develop solutions to complex business problems characterized by imperfect data. You will gather, transform, and present data to enable data-driven decision-making. You will help scale the analytics we are offering to both internal and external stakeholders.  You will also help us strengthen our capabilities to build, maintain strategic data assets & platforms, generate insights for critical business functions and drive the culture of clean data at EarnIn!

This position is Palo Alto-based and will require hybrid work from the office 2 days per week.  The Palo Alto base salary range for this full-time position is $200,700- $245,300 + equity + benefits. Our salary ranges are determined by role, level, and location.

WHAT YOU'LL DO

Interface with Finance, Engineering and Analytics to understand data needs and deliver high quality data products (25%)

Get familiar with finance & analytics domain at EarnIn and identify opportunities for process automation

Build data functional expertise and own data quality for allocated areas of ownership.

Create quality controls on data feed to ensure high quality data delivered for end product

Design, build and launch new data extraction, transformation and loading processes in production as and when required

Implement data governance practices, including data security, privacy, and compliance measures

Deep analysis to uncover areas of opportunity and present recommendations that will help shape the strategy and operations of business stakeholders

Create project related documentation for requirements, design, processing methodologies and changes planned and other relevant areas

Provide analytical support for financial needs such as annual audits, new product revenue reporting and external lender inquiries

Champion data quality and governance throughout EarnIn by maintaining and extending a clean data ecosystem for the company (25%)

Gather business requirements from key stakeholders across the company to identify and model key clean data entities needed for critical business functions and needs

Work with analytical engineering and data engineer teams to create curated datasets in batch and real-time via modern data processing solutions.

Ensure the curated datasets fulfill the main elements of data products - well designed, richly described, strongly governed, high quality, operationally reliable (within SLAs) and compliant with data privacy regulations

Streamline data flows from source and produce high quality data and pipelines (20%)

Develop and maintain data pipelines, ETL processes, and data integration workflows to ensure efficient and accurate data acquisition from various internal & external sources using SQL, Python, or other scripting languages

Work with data infrastructure to triage infra issues and drive to resolution and serve as the key point to bridge between data infrastructure and end customers

Design, build, and optimize data architecture & models to support business reporting and analytics needs. Understand evolving business requirements to optimize/update data pipelines in SQL

Monitor and optimize the performance of data systems, troubleshoot issues, and propose solutions for data-related problems

Design, develop and maintain scaled, automated, user-friendly systems, reports, dashboards, etc. that will support our financial needs (20%)

Build and deliver high quality visualization and reporting solutions to support Finance business needs

Design and create customized reports for all new financial reconciliation needs catering to their specific needs

Automate reporting for Finance using Python, Periscope, Tableau, Amplitude and other EarnIn in-house business intelligence tools and platforms

Be a data and functional expert at EarnIn (10%)

Stay up to date with industry trends and emerging technologies in the field of business intelligence and data analytics.

Be a data SME related to fintech domain

Identify and recommend BI and data tools that can be used within the company for increased productivity and scalability

WHAT WE'RE LOOKING FOR

Bachelor/ Master degree in Engineering / Analytics related fields

6+ years of relevant work experience in Analytics, Business Intelligence, Data Science or relevant field

6+ years experience in custom ETL design, implementation and maintenance.

5+ years experience with schema design and dimensional data modeling

5+ years experience in writing complex SQL queries and Python

5+ years experience working with Snowflake / Databricks or similar distributed compute systems

5+ experience with business intelligence tools such as Tableau, Power BI, or QlikView.

5+ years of working with relational databases (Redshift, PostgreSQL) and big data structures

5+ years of experience in collaborating with cross-functional teams

Proficient in at least one major data processing framework like Spark

Hands on experience working in cloud environments: AWS, GCP, Azure

Experiences working with finance team is preferred not required

Ability to analyze data to identify deliverables, gaps and inconsistencies. Excellent problem-solving and analytical skills

Fintech industry experience preferred

At EarnIn, we believe that the best way to build a financial system that works for everyday people is by hiring a team that represents our diverse community. Our team is diverse not only in background and experience but also in perspective. We celebrate our diversity and strive to create a culture of belonging. EarnIn does not unlawfully discriminate based on race, color, religion, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), gender identity, gender expression, national origin, ancestry, citizenship, age, physical or mental disability, legally protected medical condition, family care status, military or veteran status, marital status, registered domestic partner status, sexual orientation, genetic information, or any other basis protected by local, state, or federal laws. EarnIn is an E-Verify participant.

EarnIn does not accept unsolicited resumes from individual recruiters or third-party recruiting agencies in response to job postings. No fee will be paid to third parties who submit unsolicited candidates directly to our hiring managers or HR team.