- Extraction – Appcast has several disparate internal proprietary, external proprietary and external public sources that all serve our customers in several ways. A data engineer's primary job is to build automated processes that extract data from these disparate sources for downstream use by data analysts.
- Transform – A 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 – A data engineer will need to load the new tables into a cloud data warehouse using efficient, low-latency methods.
- Monitor performance – As data needs grow, the 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.
- Liaison with the Appcast core software development team on data extraction from its proprietary database.
- Data visualization/dashboards - Ensure BI tools (e.g., Tableau) are accurate and up to date, functioning as data dashboards both internally and externally.
- 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.
- 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 the CTO and head of Data & Insights to decide on what data is proper to share with clients/media due to sample size and quality
- Strong problem-solving skills and attention to detail
- Excellent communication and collaboration skills
- Bachelor's degree (or higher) in Computer Science, Information Technology, or a related field
- 5 years or more of experience in data engineering
- Expert experience in writing SQL queries
- Strong experience in writing Python and/or R code
- Strong experience in managing data warehouses and ETL/ELT/OLAP processes
- Experience with PostgreSQL, Tableau, or AWS tools is a plus
- We're the best at what we do. We're the global leader in programmatic recruitment advertising. With advanced technology, unmatched market data and a team of the industry's 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 Our Story and check out Working at Appcast 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.
-
QC Analytical Chemist
2 weeks ago
Actalent Lakewood, United States Full timeDescription: · Perform analytical testing of raw materials and complete all necessary reporting and documentation within the QC Lab. · Additional Skills & Qualifications: · Bachelor's Degree in Chemistry · Hands on lab testing experience - can be academic or professional · About ...
-
QC Analytical Chemist
2 weeks ago
Actalent Lakewood, United States Full timeDescription: · Perform analytical testing of raw materials and complete all necessary reporting and documentation within the QC Lab. · Must Haves · Bachelor's Degree in Chemistry · Hands on lab testing experience · Skills: · chemistry, gmp · Additional Skills & Qualifications: ...
-
QC Analytical Chemist
6 days ago
Actalent Lakewood, United States Full timeDescription: · Perform analytical testing of raw materials and complete all necessary reporting and documentation within the QC Lab. Must Haves Bachelor's Degree in ChemistryHands on lab testing experience · Skills: · chemistry, gmp · Top Skills Details: · chemistry · Additional ...
-
QC Analytical Chemist
2 weeks ago
Actalent Lakewood, United States Full timeDescription: · Perform analytical testing of raw materials and complete all necessary reporting and documentation within the QC Lab. · Must Haves: · -Bachelor's Degree in Chemistry · -Hands on lab testing experience · Skills: · chemistry, gmp · Top Skills Details: · chemistry · ...
-
QC Analytical Chemist
6 days ago
Actalent Lakewood, United States Full timeDescription: · Perform analytical testing of raw materials and complete all necessary reporting and documentation within the QC Lab. · Must Haves · Bachelor's Degree in Chemistry · Hands on lab testing experience · Skills: · chemistry, gmp · Top Skills Details: · chemistry · Ad ...
-
QC Analytical Chemist
2 weeks ago
Actalent Lakewood, United States Full timeDescription: · Perform analytical testing of raw materials and complete all necessary reporting and documentation within the QC Lab. Must Haves Bachelor's Degree in ChemistryHands on lab testing experience · Skills: · chemistry, gmp · Top Skills Details: · chemistry · Additional ...
-
QC Analytical Chemist
2 weeks ago
Actalent Lakewood, United States Full time**New Chemistry Graduates are encouraged to apply** · Entry-Level Job Opportunity · Fantastic opportunity to get GMP and USP experience · Description: · Perform analytical testing of raw materials and complete all necessary reporting and documentation within the QC Lab. Working ...
-
QC Analytical Chemist
3 weeks ago
Actalent Lakewood, United States Full timeDescription: · Perform analytical testing of raw materials and complete all necessary reporting and documentation within the QC Lab. · Must Haves · Bachelor's Degree in Chemistry · Hands on lab testing experience · Skills: · chemistry, GMP · Top Skills Details: · chemistry · A ...
-
Regional Sales Manager
1 week ago
Zund America Lakewood, United StatesZünd America Inc., located in Oak Creek, Wisconsin is the US Headquarters of Zünd Systemtechnik AG in Altstätten, Switzerland. Our cutting and routing tables enhance the production capabilities of our customers worldwide. Our cutting-edge software solutions and integration techno ...
-
CNC Machinist Setup/operator
20 hours ago
TFC MFG INC. Lakewood, United States**Full job description** · **CNC Machinist Position summary**: · Prepares and sets up the CNC mills within the department for the fabrication of a variety of hardware used in the aircraft industry. · **CNC Machinist Essential Functions**: · - Sets up and operates 3, 4, and 5 axis ...
-
Product Manager
1 week ago
Zoll Medical Corporation , CO, United StatesProduct Manager · Locations: US CO Remote; Remote, AZ, United States of America; Remote, UT, United States of America; Placeholder, NV, United States of America; Placeholder, NM, United States of America; Remote, IL, United States of America; Remote, CA, United States of America; ...
-
Senior Project Manager
2 weeks ago
Spartan Engineering, Inc. Lakewood, United StatesThe Senior Project Manager should possess the skills, experience, and knowledge to support the Engineering & Business Development teams. This critical position reports directly to the Manager of Projects however will work directly with Senior Management, engineering & design posi ...
-
RF Design Engineer
3 weeks ago
LanceSoft Inc , CO, United States100% Onsite Role: Littleton CO · Shift: Mon-Fri 8-5 (local time) · No Travel Required · MUST HAVE: · Solid RF Design experience especially working on National RF teams and being SME on design process. · Scripting skills especially with python · Loking for an RF Engineer based in ...
-
Relay Commissioning Technician/Specialist
1 week ago
Schweitzer Engineering Labs Lakewood, United StatesThe devices we make at SEL are embedded in the power grid. They prevent blackouts. They make outages safer and shorter in duration; they add cybersecurity, automation, and communication. They use cutting-edge technologies and operate at speeds that push other pieces of the grid t ...
-
Process Engineering Supervisor
3 weeks ago
ZAP Engineering & Construction Services, Inc. Lakewood, United StatesTITLE: · Process Engineering Supervisor · DEPARTMENT: · Engineering · REPORTS TO: · Director, Process Engineering · FLSA: · Exempt, Full-Time · WORK SCHEDULE: · M-F 8AM to 5PM · TRAVEL REQUIRED: · Up to 20% · LOCATION: · Lakewood, Colorado · MANAGEMENT: · Yes · EEO: · Professiona ...
-
Business Analyst
3 weeks ago
Hazen and Sawyer Lakewood, United StatesJoin our Hazen team and make the world a better place providing exceptional client service in all things water and superior technical solutions for our clients. Hazen is a creative, employee-owned company with minimal bureaucracy where employees thrive. · Hazen and Sawyer, a lea ...
-
Telecommunications Mechanic I
2 weeks ago
Constellis Lakewood, United States· POSITION OVERVIEW · The Contractor shall provide to the Government telecommunication mechanic support for the Technical Service Desk, which includes coordinating support on new system installations throughout all the regions that the MegaCenters service. Support shall also inc ...
-
Senior System Engineer
1 week ago
Compri Consulting Lakewood, United StatesOne of our amazing local clients in Lakewood, Colorado is seeking a Windows System Engineer for a full-time, direct hire position. This position reports to the Operations Manager and participates on a nine-person team responsible for designing, administering, and supporting the W ...
-
Terumo BCT, Inc. Lakewood, United StatesRequisition ID: 31918 · At Terumo Blood and Cell Technologies, our 7,000+ global associates proud to come to work each day, knowing that what we do impacts the lives of patients around the world. · We make medical devices and related products that are used to collect, separate, ...
-
Chemist
1 week ago
Department Of The Interior Lakewood, United StatesWhat General Information Do I Need To Know About This Position? · Salary: · GS-07: $54,505 (Step 01) to $70,859 (Step 10). · GS-09: $66,670 (Step 01) to $86,670 (Step 10). · NOTE: First time hires to the Federal Government are typically hired at the Step 01. · This announcement w ...
Data Engineer - Lakewood, United States - Stepstone
2 weeks ago
Description
Company Description
Appcast is the global leader in programmatic recruitment advertising technology and services. With advanced technology, unmatched market data and a team of the industry's best recruitment marketers, Appcast's technology and services manage job advertising annually for enterprise clients across industries. 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.
Job Description
The data engineer will serve as a liaison between its core developers and downstream analysts. The data engineer's primary job is to 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. Experience managing data warehouses and ELT/ETL processes in an OLAP database is strongly desired. The employee can be in the U.S., Canada, Belarus, or Poland.
Job Responsibilities
Move data between systems:
Manage cloud data warehouse:
Serve data to downstream users ("democratize data"):
Set data strategy for company:
Expected salary range: $85,000-$150,000
Qualifications
Education and Experience
Additional Information
Appcast recognized as one of Inc Magazine's "Best Workplaces" for 2021 & 2022
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.