Senior Data Engineer

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

The Company:

Personal Capital is a leading digital wealth management company, founded in 2009. We’re on a mission to transform financial lives through technology and people, providing both insight-driven advice with free financial tools and personalized wealth management from 200+ registered financial advisors across the country. Personal Capital has raised $315 million in capital from accomplished financial and strategic investors (IVP, Venrock, Crosslink, Corsair, Blackrock, BBVA, USAA, IGM/Power) to disrupt the traditional $30 trillion U.S. wealth management market. Our free personal finance app is utilized by over two million users, helping them track over $840 billion of their personal finances, all in one place. Our award-winning apps paved the way for our advisory firm, which now manages over $12 billion in personalized investment portfolios for American families. Personal Capital is headquartered in Redwood Shores with offices in San Francisco, Denver, Dallas and Atlanta.


The Opportunity:

You will play a critical role on the Data and Analytics team, responsible for transforming data from disparate systems to provide insights and analytics for business stakeholders. You’ll leverage cloud-based infrastructure to implement technology solutions that are scalable, resilient, and efficient. You will collaborate with Data Engineers, Data Analysts, Data Scientists, DBAs, cross-functional teams, and business partners. You will architect, design, implement and operate data engineering solutions, using Agile methodology, that empower users to make informed business decisions.


The Candidate:

You are self-motivated, self-directed, and have hands-on experience with all aspects of the software development lifecycle, from design to deployment. You have a deep understanding of the full life data lifecycle and the role that high-quality data plays across applications, machine learning, business analytics, and reporting. Strong candidates will exhibit solid critical thinking skills, the ability to synthesize complex problems, and a talent for transforming data to create solutions that add value to a myriad of business requirements. You have the demonstrated ability to facilitate and take ownership of assigned technical projects in a fast-paced environment. Excellent written and speaking communication skills are required as we work together in a collaborative cross-functional environment and interact with the full spectrum of business divisions.

Qualifications:

  • Bachelor of Science degree in Computer Science or equivalent.
  • At least 7 years of post-degree professional experience, including:
    • 4+ years development experience building and maintaining ETL pipelines
    • 3+ years of Python development experience
  • Experience with AWS integrations such as Kinesis, Firehose, Aurora Unload, Redshift, Spectrum, Elastic Mapreduce, SageMaker and Lambda
  • Experience in mentoring junior team members through code reviews and recommending adherence to best practices
  • Deep understanding of writing test cases to ensure data quality, reliability and high level of confidence
  • Track record of advancing new technologies to improve data quality and reliability
  • Continuously improve quality, efficiency, and scalability of data pipelines 
  • Expert skills working with SQL queries, including performance tuning, utilizing indexes, and materialized views to improve query performance
  • Advanced knowledge of both OLTP and OLAP environments with successful implementation of efficient design concepts
  • Proficiency with the design and execution of NoSQL database to optimize BigData storage and retrieval 
  • Experience with API code integrations with external vendors to push/pull data between organizations 
  • Familiarity with data orchestration pipeline using Argo or Airflow
  • Knowledge of analytic tools such as R, Tableau, Plotly, Python Pandas
  • Financial services industry experience is a plus

This role is available in Redwood City, California or as a work from home position offered nationwide.

Personal Capital is proud to be an equal opportunity workplace dedicated to pursuing and hiring a diverse workforce.

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

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • SqlLanguages
    • D3JSLibraries
    • ReactLibraries
    • AngularJSFrameworks
    • Backbone.jsFrameworks
    • ExpressFrameworks
    • HadoopFrameworks
    • Node.jsFrameworks
    • DB2Databases
    • HiveDatabases
    • MySQLDatabases
    • AWSDatabases
    • JIRAManagement
    • SalesforceCRM
    • MarketoLead Gen

Location

Located in the heart of downtown Denver!

An Insider's view of Personal Capital

What are some social events your company does?

We tend to celebrate in big ways. Hitting milestones is exciting for any business, and at Personal Capital we've set aside time to rent out Lucky Strike or take the office out to a Rockie's game to celebrate our success. Our holiday parties are guaranteed to be a good time too!

Will

Sr. Recruiter

How do you collaborate with other teams in the company?

I work with and rely on Data Engineering to provide the data architecture needed for my analyses. I brainstorm promotion ideas with Sales, Marketing, and Product and track results in real-time. My insights and recommendations get presented to upper management to evaluate and implement, ultimately providing business intelligence using data.

Chris

Business Analyst

What are some things you learned at the company?

We want our employees to grow personally and professionally. At Personal Capital, you'll learn that clients always come first. We do all we can to help our clients fulfill their financial goals. That mentality spreads to every facet of your life, outside of work we try to better our community and we take pride in donating our time.

Jordan

Recruiter

How do you make yourself accessible to the rest of the team?

To make sure I'm regularly formally connecting with each member of my team, I schedule bi-weekly check-ins to see how they're feeling about everything from day-to-day challenges to long-term opportunities they want to tackle. In addition to that, we have an open work environment and I sit right in the middle of my team!

Danielle

Manager | Senior Financial Advisor

How would you describe the company’s work-life balance?

With 9 paid holidays, weekends off, and generous PTO, there's a lot of time to enjoy living in Denver. Our Team can be found hitting the slopes every weekend or playing kickball in the Summer.

Meghan

Director of Human Resources: Talent Acquisition, Development, and Retention

What are Personal Capital Perks + Benefits

Culture
Volunteer in local community
Friends outside of work
Eat lunch together
Intracompany committees
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Highly diverse management team
Unconscious bias training
Diversity manifesto
Diversity Employee Resource Groups
Business resource groups include ALMA: Aspiring Latinos Moving Ahead, BOLD: Black Organization for Leadership Development, EA, Pride, NAMaSTE, VETS, and WEN: Women's Empowerment Network.
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)
401(K) Matching
Performance Bonus
Match charitable contributions
The company matches up to $5000/year per employee for charitable giving.
Child Care & Parental Leave Benefits
Generous Parental Leave
Personal Capital provides 4 weeks of parental leave. In addition, Personal Capital offers supplemental wage replacement for employees who elect to utilize a paid pregnancy disability leave plan.
Flexible Work Schedule
Remote Work Program
Our remote work program includes the option to work from home full-time.
Family Medical Leave
Adoption Assistance
We offer up to four weeks of wage replacement options for employees on parental leave following adoption.
Company sponsored family events
Vacation & Time Off Benefits
Unlimited Vacation Policy
Generous PTO
Paid Volunteer Time
Our employees receive 16 hours per year of paid volunteer time.
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Game Room
Stocked Kitchen
Happy Hours
Fitness Subsidies
Home Office Stipend for Remote Employees
Professional Development Benefits
Tuition Reimbursement
Lunch and learns
Cross functional training encouraged
Promote from within
Mentorship program
Our mentorship program includes Cross-department program, Career mentoring.
Continuing Education stipend
Online course subscriptions available
Customized development tracks
Paid industry certifications
More Jobs at Personal Capital12 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
Marketing
Operations
Project Mgmt
Sales
Project Mgmt
new
Remote
Operations
new
Remote
Marketing
new
Remote
Data + Analytics
new
Remote
Operations
new
Denver
Sales
new
Denver
Finance
new
Denver
Data + Analytics
new
Remote
Developer
new
Denver
Finance
new
Remote
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Personal Capital's full profileSee more Personal Capital jobs