Job Description

Company DescriptionAppcast is the global leader in programmatic recruitment advertising technology and recruitment marketing services. With advanced technology, unmatched market data and a team of the industrys best recruitment marketers, Appcasts technology and services manage job advertising annually for enterprise clients across multiple industries and geographies. Headquartered in Lebanon, N.H. with offices in the U.S., Canada and Europe. Appcast is part of the Stepstone group, a leading digital recruitment platform that connects companies with the right talent and helps people find the right job.The Senior Data Engineer will serve as a liaison between the Appcast core development team and downstream analysts on the Data and Insights team. The senior data engineer sets up the data engineering infrastructure, using the tools of your choice. From the architecture you establish, you will then code automated processes that extract data from disparate sources; efficiently build and manage transformations into a cloud data warehouse; and build pipelines that load data into tools used by economists, data scientist, data analysts, and many other stakeholders. SQL and Python/R skills are a must. As is extensive experience managing data warehouses and ELT/ETL processes in an OLAP database.Job ResponsibilitiesMove data between systems:

• Extraction - Appcast has several disparate internal proprietary, external proprietary and external public sources that all serve our customers in several ways. A senior data engineers primary job is to build automated processes that extract data from these disparate sources for downstream use by data analysts.
• Transform - The senior data engineer will transform data from disparate sources into distinct tables using a relational data model, so that analysts can pull them together in one unified workflow.
• Load - The senior data engineer will need to load the new tables into a cloud data warehouse using efficient, low-latency methods.

Manage cloud data warehouse:

• Monitor performance - As data needs grow, the senior data engineer will need to monitor essential performance queries used by downstream analysts to ensure data is being delivered in a timely manner that does not cause slowdowns.
• Data quality - Ensuring both internal and external data sources are accurate and up to date to provide the best quality for our clients and media partners.

Serve data to downstream users (democratize data):

• Liaison with the Appcast core software development team on data extraction from its proprietary database.
• Data visualization/dashboards - Partner with data analysts to ensure BI tools (e.g., Tableau) are accurate and up to date.
• Data permissions/access - Manage the onboarding and offboarding of data permissions, who is given access to the cloud data warehouse and ensuring proper security protocols are being followed.

Set data strategy for company:

• Control cost - Work with procurement specialists to keep negotiated contracts controlled with external data vendors; research/keep up to date with new data vendors that can provide Appcast with a competitive advantage in our competitive market
• Data awareness/education - Educate analysts on basic data hygiene on how to manage and clean data, and where to access data sources
• Data security and governance - Develop a deep understanding of Appcast data, work with internal stakeholders to decide on what data is proper to share with clients/media due to sample size and quality
• Pioneer the adoption of sophisticated ETL/ELT frameworks and platforms such as Apache Airflow and DBT to enhance data workflow automation.
• Serve as the primary senior data engineering expert, advising senior management and other internal stakeholders on technological advancements and strategic investments in data infrastructure.

Qualifications

• Expert proficiency in writing SQL queries
• Expert proficiency in a data engineering programming language (e.g. Python, R, Scala)
• Expert proficiency at managing data warehouses and ETL/ELT/OLAP processes
• Background in data modeling and distributed data systems
• Strong problem-solving skills and attention to detail
• Excellent communication and collaboration skills
• Experience with streaming data platforms like Amazon Kinesis or Apache Kafka
• Implement and manage complex data systems like Apache Spark for efficient data storage and computation.
• Familiarity with BI tools like Tableau, Shiny or PowerBI is a plus

Education and Experience

• Bachelors degree (or higher) in Computer Science, Information Technology, or a related field
• And, 8+ years of experience in data engineering
• Expert experience in writing SQL queries
• Strong experience in writing Python, R, and/or Scala code
• Strong experience in managing data warehouses and ETL/ELT/OLAP processes
• Experience with PostgreSQL, Tableau, or AWS tools is a plus
• Experience with big data technologies like Apache Spark is a plus

Travel RequirementsRegular travel is not necessary for this position.Additional InformationAppcast recognized as one of Inc Magazine's "Best Workplaces" for 2021 & 2022!

• Were the best at what we do. Were the global leader in programmatic recruitment advertising. With advanced technology, unmatched market data and a team of the industrys best recruitment marketers.
• We have an amazing culture driven by great people. Headquartered in Lebanon, N.H. with offices in the U.S., Canada and Europe, Appcast is part of the Stepstone group. To better understand our company culture, read

and check out on our website. * We take care of our employees. We're dedicated to creating an inviting environment where individuals from diverse backgrounds can thrive and develop. We believe in providing competitive compensation and comprehensive benefits, ensuring our team can support their loved ones and one another. We enjoy fostering a sense of community through dedicated employee networks, fun gatherings, delicious food, and even welcoming furry friends into our workspace. We live our values each day including volunteering and giving back to our communities.All your information will be kept confidential according to EEO guidelines.Appcast is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

Appcast