Senior Software Developer, ETL

| Pasadena
Spokeo is a people search engine that both enlightens and empowers our customers. With over 12 billion records and 18 million visitors per month, we reconnect friends, reunite families, prevent fraud, and more. Every day our nimble team takes on enormous challenges in data science that push the limits of the cloud and search architecture.
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:
  • Profiling source data to assess the quality and facilitate cleansing and business requirements.
  • Working with Product, Data Architects and Data Scientist to define business requirements.
  • Translating business requirements into data requirements and source-to-target data mappings.
  • Collaborating with Data Engineers to optimize, automate and integrate new components into the data pipeline. 
  • Assisting in the ongoing development of technical best practices for data movement, data quality, data cleansing, and other ETL related activities.
  • Performing ad-hoc investigations into data anomalies as needed.
Requirements:
  • B.S. preferred in Computer Science, Information Systems, or related field.
  • Minimum of two years of development experience with Pentaho, with a preference for five years of ETL tool experience. Prefer Pentaho version 7.0 or higher. 
  • Advanced SQL coding skills for data transformations, profiling, and query tasks.
  • Experience in agile environments such as scrum and Kanban.
  • Preference for experience in Hadoop fundamentals and architecture: HDFS, map-reduce, job performance.
  • Preference for open source big data skills in tools such as Hive, HBase, parquet, Spark.
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

Technology we use

  • Engineering
    • JavascriptLanguages
    • PythonLanguages
    • RubyLanguages
    • SqlLanguages
    • KafkaLanguages
    • ReactLibraries
    • AngularJSFrameworks
    • HadoopFrameworks
    • Node.jsFrameworks
    • Ruby on RailsFrameworks
    • SparkFrameworks
    • MongoDBDatabases
    • MySQLDatabases
    • RedshiftDatabases
    • SnowflakeDatabases

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.

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
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Acme employees can contribute up to $5000 annually to their FSA.
Disability Insurance
Disability insurance covers 60% of annual salary up to $10000 monthly maximum payout.
Dental Benefits
Our dental plan covers $100 of expenses.
Vision Benefits
The vision benefits plan covers 100% for annual eye exams with $130 for glasses and contact lenses.
Health Insurance Benefits
Acme's health insurance policy covers up to 100% of out of pocket expenses.
Life Insurance
Life insurance is equal to 5 times an employee's annual salary.
Wellness Programs
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Performance Bonus
Child Care & Parental Leave Benefits
Flexible Work Schedule
Acme Co. provides employees with a flexible work schedule that includes Flexible start and end times.
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
More Jobs at Spokeo15 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
Marketing
Data + Analytics
new
Pasadena
Developer
new
Pasadena
Finance
new
Pasadena
Design + UX
new
Pasadena
Data + Analytics
new
Pasadena
Developer
new
Pasadena
Developer
new
Pasadena
Developer
new
Pasadena
Marketing
new
Pasadena
Developer
new
Pasadena