Data Warehouse Manager, 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 the Data Warehouse Manager, ETL you will lead and mentor the ETL team responsible for processing the public record data powering Spokeo’s people-search products. This is an exciting opportunity to help transform the quality of the data we process, partnering with business stakeholders, data scientists, and big data developers. The ideal candidate will have an understanding of the challenges associated with big data aggregation with a focus on quality.

Responsibilities:
  • Collaborating with stakeholders to define business logic for source-to-target mappings and integration workflows.
  • Development of scalable, modular, and robust ETL routines, using ETL tools and external programming/scripting languages as necessary.
  • Developing and mentoring the ETL development team, ensuring that best practices are implemented for data governance, data quality, data cleansing, and other ETL related activities.
  • Utilizing insights from data profiling reports and business use cases to drive processing decisions.
  • Creating and maintaining the company data dictionary as well as technical documentation for source-to-target mapping.
  • Assisting in production support by resolving source data issues and refining transformation rules when needed.
  • Collaborating with stakeholders to design and develop our data warehouse, data marts, and data models

Requirements:
  • B.S. preferred in Computer Science, Information Systems, or related fields.
  • 5+ years of development experience with Pentaho (or equivalent tools such as Talend, DataStage, and Informatica) 
  • 3+ years of experience managing, motivating and mentoring a team.
  • Advanced SQL coding skills for data transformations, profiling, and query tasks.
  • Experience with data warehousing, data modeling, and database architecture.
  • Experience in agile environments using Scrum and/or Kanban and software development life cycle.
  • Ability to communicate effectively with all stakeholders.
  • Preference for open source big data experience with tools such as Hive, HBase, Parquet, Spark, etc.

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

Additional Perks + Benefits

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

More Jobs at Spokeo12 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
Marketing
Data + Analytics
new
Pasadena
Developer
new
Pasadena
Finance
new
Pasadena
Data + Analytics
new
Pasadena
Data + Analytics
new
Pasadena
Marketing
new
Pasadena
Data + Analytics
new
Pasadena
Design + UX
new
Pasadena