Data/Analytics Engineer

| Remote
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

As a data engineer on the BI team, you will be responsible for architecting, building and maintaining the data infrastructure for company-wide BI and cross-functional teams at Addepar.  We are building the environment to unify data from different data sources, report on transformed data sets, and enable data-driven decisions.

You will design, build and orchestrate tools and data pipelines, integrate data from disparate data sources to be able to load the data into dimensional models in the data warehouse. You will also be responsible for building a strong data ecosystem by integrating different data systems with the data warehouse and BI tools.

Responsibilities:

  • Build realtime and batch data integrations to integrate data from disparate source systems into the DW
  • Build and maintain scalable ELT/ETL processes using workflow automation tools 
  • Designing dimensional models and be able to cleanse and transform raw data into structured format
  • Administer and maintain data pipeline tools and data warehouse
  • Provide production support for data integration and transformation pipelines
  • Partner with analytics engineer and data analysts to build tooling to be able to effectively move data in and out of the data warehouse/data pond
  • Champion the strategy to build data security framework to store, move and access data
  • Establish best data practices and formalizing data governance framework 
  • Scale and tune data pipelines, databases and SQL queries
  • Build and maintain data reconciliation processes

Requirements:

  • 5+ years of experience as a data engineer and/or software engineer in a SaaS or financial services business
  • 2+ years of experience working with workflow orchestration tools( Preferred: Airflow, Prefect OR Luigi, autosys, etc)
  • 4+ years of experience building ELT/ETL processes using one or more tools(E.g. Python, Informatica, SSIS, Pentaho, etc)
  • Experience working with and administering one or more columnar storage systems (Preferred: Snowflake OR Redshift, Bigquery, etc)
  • Knowledge and skills with Looker will be important, not critical 
  • Must have completed at least one full cycle of building a data lake and/or a data warehouse
  • Exposure to data streaming tools and technologies like kafka
  • Experience working in cloud data environments(Preferred: AWS OR GCP, Azure, etc)
  • Strong software development skills in Python and SQL
  • Experience tuning SQL queries and data pipelines
  • Ability to multi-task and change priorities
  • Stellar communications skills for requirements gathering

Nice to have:

  • You have built Data Lakes in S3 or Hadoop
  • Experience working with CRM systems like Salesforce
  • Exposure to BI/reporting tools ( Preferred:Looker OR Tableau, Sisense/Periscope, Cognos, etc)
  • Building reports and dashboards using BI tools
  • Basic knowledge of statistics  
  • Experience working with with SaaS or Fintech companies is a plus 

Addepar is a wealth management platform that specializes in data aggregation, analytics and reporting for even the most complex investment portfolios. Founded in 2009 by Joe Lonsdale, who currently serves as an active Chairman of its Board of Directors and General Partner at 8VC, the company's platform aggregates portfolio, market and client data all in one place. It provides asset owners and advisors a clearer financial picture at every level, allowing them to make more informed and timely investment decisions. Addepar works with hundreds of leading financial advisors, family offices and large financial institutions that manage data for over $2 trillion of assets on the company's platform. In 2020, Addepar was named as a Forbes Fintech 50 company and honored as a member of the CB Insights Fintech 250. Addepar is headquartered in Silicon Valley and has offices in New York City and Salt Lake City. All brokerage services offered through Acervus Securities Inc., member FINRA / SIPC.

Addepar is proud to be an equal opportunity employer. We seek to bring together diverse ideas, experiences, skill sets, perspectives, backgrounds, and identities to drive innovative solutions. We commit to promoting a welcoming environment where inclusion and belonging are held as a shared responsibility.

In order to ensure the health and safety of all Addepeeps and our prospective candidates, we have instituted a virtual interview and onboarding experience.

Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Location

303 Bryant St, Mountain View, CA 94041

What are Addepar Perks + Benefits

Culture
Volunteer in local community
Friends outside of work
Eat lunch together
Open door policy
Diversity
Unconscious bias training
Someone's primary function is managing the company’s diversity and inclusion initiatives
Diversity Employee Resource Groups
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
Company Equity
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Family Medical Leave
Company sponsored family events
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Free Daily Meals
Stocked Kitchen
Some Meals Provided
Happy Hours
Pet Friendly
Fitness Subsidies
Home Office Stipend for Remote Employees
Professional Development Benefits
Tuition Reimbursement
Diversity Program
Lunch and learns
Promote from within
Continuing Education stipend
More Jobs at Addepar29 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR + Recruiting
Operations
Product
Project Mgmt
Sales
Content
Project Mgmt
new
Remote
Sales
new
Remote
Developer
new
Remote
Project Mgmt
new
Peninsula
Data + Analytics
new
Remote
Data + Analytics
new
Remote
Finance
new
Remote
Developer
new
Remote
Operations
new
Remote
Sales
new
Remote
Developer
new
Remote
Design + UX
new
Remote
Sales
new
Remote
Data + Analytics
new
Remote
Developer
new
Remote
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Addepar's full profileSee more Addepar jobs