Senior Data Engineer at Personal Capital

| Remote
Sorry, this job was removed at 11:10 a.m. (MST) on Wednesday, April 28, 2021
Find out who's hiring in Colorado.
See all Developer + Engineer jobs in Colorado
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

The Job:

Senior Data Engineers 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. The Data and Analytics team leverages cloud-based infrastructure to implement technology solutions that are scalable, resilient, and efficient. Collaborate with other Data Engineers, Data Analysts, Data Scientists, DBAs, cross-functional teams, and business partners.

 

The position offers the opportunity to help architect, design, implement and operate data engineering solutions - using Agile methodology - that empower users to make informed business decisions. The ideal candidate is self-motivated, self-directed, and has hands-on experience with all aspects of the software development lifecycle, from design to deployment.

 

The Candidate:

Our team is searching for someone with a deep understanding of the full life data lifecycle and of 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.

 

Ideal candidates will 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

 

What we offer you

We offer an array of diverse and inclusive benefits regardless of where you are in your career. We believe that providing our employees with the means to lead healthy balanced lives results in the best possible work performance.

  • Medical, dental, vision and life insurance
  • Retirement savings – 401(k) plan with generous company matching contributions (up to 5), financial advisory services, potential company discretionary contribution, and a broad investment lineup
  • Tuition reimbursement up to $5,250/year
  • Business-casual environment that includes the option to wear jeans
  • Generous paid time off upon hire – including a paid time off program plus nine paid company holidays and three floating holidays each calendar year
  • Paid volunteer time — 16 hours per calendar year
  • Leave of absence programs – including paid parental leave, paid short- and long-term disability, and Family and Medical Leave (FMLA)
  • Business Resource Groups (BRGs) - internal networks that rally around common interest, experiences and identities such as race, ethnicity, gender, ability, military status and sexual orientation. BRGs play a vital role in educating and engaging our people and advancing our business priorities.

Competitive compensation, includes base salary and eligibility to participate in either an annual bonus program or sales incentive plan, as applicable.  Base salary range provided below is a reasonable estimate and final base salary may differ based on the selected candidate’s education, training, experience, licensure requirements, travel requirements and geographic location.

Location

Redwood City, CA or Nationwide Remote 

Base Salary Range

$ 115,700.00-191,000.00

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
Continuing Education stipend
Online course subscriptions available
Customized development tracks
Paid industry certifications
More Jobs at Personal Capital15 open jobs
All Jobs
Finance
Dev + Engineer
Internships
Marketing
Operations
Product
Project Mgmt
Sales
Project Mgmt
new
Remote
Finance
new
Denver
Internships
new
Remote
Developer
new
Remote
Sales
new
Denver
Sales
new
Denver
Operations
new
Denver
Marketing
new
Remote
Product
new
Remote