Data Warehouse Manager, ETL
Data | Remote | Full Time
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 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.
To be successful in this role you will need to be comfortable operating in a world of billions of records and petabytes of data and have experience with cloud-based data systems. The ideal candidate will have an understanding of the challenges associated with big data aggregation, experience with ETL tools, and scripting languages with a focus on quality.
Collaborating with stakeholders to design and develop our data warehouse, data marts, and presentation databases.
Utilizing insights from data profiling reports and business use cases to help define processing decisions, source-to-target mappings, and integration workflows.
Helping manage the team backlog.
Developing scalable, modular, and robust ETL routines, using ETL tools and external programming/scripting languages.
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.
Creating and maintaining technical documentation for source-to-target mapping.
Assisting in production support by resolving source data issues and refining transformation rules when needed.
B.S. preferred in Computer Science, Information Systems, or related fields.
5+ years of development experience with ETL tools such as Talend, DataStage, Pentaho, or Informatica
3+ years of experience with scripting languages, PySpark, SQL
3+ years of experience managing, motivating and mentoring a team.
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 Spark, etc.
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.