Data Warehouse Manager, ETL
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.
- 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
- 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.