Senior Software Developer, ETL

| Pasadena
Spokeo is a people search engine that both enlightens and empowers our customers. With over 14 billion records and 15 million visitors per month, we reconnect friends, reunite families, prevent fraud, and more.
As a Senior Software Developer, ETL at Spokeo, you will be responsible for implementing ETL processes using a variety of data sources. This can include the effort to locate and analyze source data, create data flows to extract, profile and store ingested data, define and implement data cleansing, map data to a common schema, transform data to satisfy business rules and validate content.
Responsibilities:
  • Collaborating with stakeholders to define business logic for source-to-target data mappings and integration workflows.
  • Profiling source data to assess the quality and inform business logic.
  • Developing source-to-target data mappings and transformations to support business requirements.
  • Collaborating with Data Engineers to optimize, automate and integrate new components into the data pipeline. 
  • Mentoring and ensuring the implementation of technical best practices for data governance, data quality, data cleansing, and other ETL related activities.
  • Leading ad-hoc investigations into data anomalies as needed.

Requirements:
  • B.S. preferred in Computer Science, Information Systems, or related field.
  • Minimum of five years of development experience with Pentaho (or equivalent tools such as Talend, DataStage, and Informatica) 
  • Big Data experience in ETL tools such as Pentaho AEL or Informatica Blaze.
  • Advanced SQL coding skills for data transformations, profiling, and query tasks.
  • Experience in agile environments such as scrum and Kanban.
  • Preference for open source big data skills in tools such as Hive, HBase, parquet, Spark.

Privacy Notice for Candidates: https://www.spokeo.com/recruiting-policy
Spokeo is an equal opportunity employer. Applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status. Spokeo fosters a business culture where ideas and decisions from all people help us grow, innovate, create the best products and be relevant in a rapidly changing world.

Recruiters or staffing agencies: Spokeo is not obligated to compensate any external recruiter or search firm who presents a candidate or their resume or profile to a Spokeo employee without 1) a current, fully-executed agreement on file and 2) being assigned to the open position (as a search) via our applicant tracking solution.
Read Full Job Description
Apply now

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavascriptLanguages
    • PythonLanguages
    • RubyLanguages
    • SqlLanguages
    • KafkaLanguages
    • ReactLibraries
    • AngularJSFrameworks
    • HadoopFrameworks
    • Node.jsFrameworks
    • Ruby on RailsFrameworks
    • SparkFrameworks
    • MongoDBDatabases
    • MySQLDatabases
    • RedshiftDatabases
    • Google AnalyticsAnalytics
    • IllustratorDesign
    • InVisionDesign
    • PhotoshopDesign
    • SketchDesign
    • ConfluenceManagement
    • JIRAManagement
    • HootsuitCMS
    • SalesforceCRM
    • SendGridEmail
    • Salesforce for Marketing CloudEmail
    • FullContactLead Gen

Location

Our office is a short drive from downtown LA and a quick walk from the Metro Gold Line. Incredible restaurants and vibrant Old Town and the Rose Bowl!

An Insider's view of Spokeo

What’s the vibe like in the office?

The key thing that we do well is transparency. We share all stats (good and bad), and we go a step beyond just sharing information by providing context to promote understanding. We always endeavor to be authentic and true to our core values.

Harrison

CEO

How do you collaborate with other teams in the company?

Everyone is very accessible. Anytime I am working with other departments (which is often), I just walk over and have a face to face or send a quick message.

Brady

Customer Experience Manager

How does the company support your career growth?

"We try to invest in the long term for our teammates' careers. We want to see them grow and develop and we actively set growth goals for each individual teammate. Our team is small enough so every member can make a big impact quickly, while still being large enough to allow specialization."

Byron Wang

Vice President of Engineering

What is your vision for the company?

I see Spokeo continuing to strive to be a forward-thinking technology company that delivers people data and helps our customers use people data intelligently.

Maggie

Vice President of Operations

What does your typical day look like?

In my day to day as a designer at Spokeo, I work with multiple teams on most projects. The voices of my teammates and the synergy between us have made my work better.

Clara

Senior Visual Designer

What are Spokeo Perks + Benefits

Spokeo Benefits Overview

We take care of our team members and their families. Here’s some of what you can expect:

HEALTH INSURANCE
Spokeo covers 100% of the medical premium for employees and 80% for dependents with no waiting period

401(K)
Spokeo will match 100% of your 401(k) deferral up to 3% of your annual base pay earnings. No Vesting Period to Receive Matching!

PAID TIME OFF POLICY
9 paid holidays
Full time employees earn 1.5 vacation days every full month worked for a total of 18 days per year.
Full time employees will receive 1 extra vacation day per year for every full year worked (up to 5 years).
Six (6) sick days per year, issued on the first of the year.

Other Perks
Flexible hours
Casual dress
Daily free catered lunch
Full pantry/fridge with endless snacks and beverages
Game room

Culture
Partners with Nonprofits
Spokeo Search Angels, scholarships, philanthropy and in the local community - including the Junior League of Pasadena, SWE, she codes, Pasadena Women In Technology, Innovate Pasadena and Rails Girls.
Eat Lunch Together
Daily Stand-up
Open Door Policy
Team-Owned Deliverables
Open Office Floor Plan
Diversity
Highly Diverse Management Team
Unconscious Bias Training
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Performance Bonus
Child Care & Parental Leave Benefits
Remote Work Program
Family Medical Leave
Company-Sponsored Family Events
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Free Daily Meals
Game Room
Stocked Kitchen
Parking
Relocation Assistance
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Lunch and Learns
Continuing Education Stipend
Paid Industry Certifications

Additional Perks + Benefits

We have our very own, dedicated Culture Team that is separate from Human Resources.

More Jobs at Spokeo15 open jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
Legal
Marketing
Product
Data + Analytics
new
Pasadena
Data + Analytics
new
Pasadena
Data + Analytics
new
Pasadena
Design + UX
new
Pasadena
Design + UX
new
Pasadena
Data + Analytics
new
Pasadena
Developer
new
Pasadena
Marketing
new
Pasadena