Senior Data Engineer at Personal Capital

| Greater Denver Area | Remote
Sorry, this job was removed at 5:30 a.m. (MST) on Saturday, October 16, 2021
Find out who's hiring in Colorado.
See all Data + Analytics jobs in Colorado
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Grow your career with a growing organization

Whether they’re helping people reach their long-term financial goals or providing personal wealth management strategies, every associate contributes to changing the lives of those we serve for the better. When it comes to job satisfaction, that’s hard to beat. And from a personal satisfaction perspective, you’ll enjoy the freedom to support causes that matter to you and experience a truly inclusive work environment. Your future starts now.

About the job:

  • 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.
  • 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.

Requirements

  • 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 pipelines3+ 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

Please note that this role is being posted by Personal Capital, an Empower company. Personal Capital roles are cross-posted to the Empower web site and are also available at https://www.personalcapital.com/company/jobs. For more information about Personal Capital, please visit www.personalcapital.com

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.

The salary range below describes the minimum to maximum base salary range for this position in the location listed. Non-sales positions have the opportunity to participate in a bonus program. Sales positions are eligible for sales incentives, and in some instances a bonus plan, whereby total compensation may far exceed base salary depending on individual performance. Actual compensation offered may vary from posted hiring range based upon geographic location, work experience, education, licensure requirements and/or skill level and will be finalized at the time of offer.

Base Salary Range

$ 97,200.00-160,400.00

Location

CO Remote

We are an equal opportunity employer with a commitment to diversity. All individuals, regardless of personal characteristics, are encouraged to apply. All qualified applicants will receive consideration for employment without regard to age (40 and over), race, color, national origin, ancestry, sex, sexual orientation, gender, gender identity, gender expression, marital status, pregnancy, religion, physical or mental disability, military or veteran status, genetic information, or any other status protected by applicable state or local law. 

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

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 Capital36 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
HR + Recruiting
Marketing
Operations
Product
Project Mgmt
Sales
Data + Analytics
new
Remote
Data + Analytics
new
Remote
Sales
new
Denver
Sales
new
Remote
Operations
new
Denver
Operations
new
Remote
Sales
new
Remote
Finance
new
Remote
Operations
new
Remote
Developer
new
Remote
Developer
new
Remote
Developer
new
Remote
Data + Analytics
new
Remote
Developer
new
Remote
Data + Analytics
new
Remote
Product
new
Remote
Data + Analytics
new
Remote
Developer
new
Remote
Sales
new
Remote
Sales
new
Denver
Operations
new
Remote
Developer
new
Remote
Project Mgmt
new
Remote
Developer
new
Remote
HR + Recruiting
new
Remote
Developer
new
Remote
Data + Analytics
new
Remote
Operations
new
Remote
Operations
new
Remote
Data + Analytics
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