Description
We have an exciting opportunity in the newly formed Enterprise Data Office (EDO) with its mandate to serve the business leaders and data stakeholders at StackAdapt with trusted official reporting and governed self-service analytics. Reporting to the Director of Enterprise Data Office, the ETL Developer will be responsible for end-to-end data pipeline development from ingesting the raw data into the centralized data lake, to transforming the data into business-friendly data models on the Enterprise Data Warehouse that can be easily consumed by the business through Business Intelligence applications and other downstream processes.
This role will assess the data requirements provided by the Manager of Business Data Analysis and collaborate with other team members and the source data owners to design and build automated batch or near-real-time data ingestion pipelines that will ingress the necessary data from the source, which may be a variety of formats and mediums such as relational/non-relationship databases, flat files, and applications, into the centralized data lake. Subsequently, under the guidance of the Data Architect, who will provide the target data models, the ETL developer will build the transformation pipelines necessary to materialize various types of data models into the Enterprise Data Warehouse. The ETL developer will work collaboratively with the Data Architect in the deployment, automation, and orchestration of these newly developed data pipelines, and collaborate with the BI engineers to ensure the smooth connection of these data models into the BI semantic layer so that it can be leveraged easily by business users. Finally, the ETL developer will also assist the Data Architect and the Manager of Business Data Analysis in the maintenance and support of the data pipeline operations as well as the overall EDO environments.
StackAdapt is a Remote-First company. We are open to candidates located anywhere in Canada for this position.
We have an exciting opportunity in the newly formed Enterprise Data Office (EDO) with its mandate to serve the business leaders and data stakeholders at StackAdapt with trusted official reporting and governed self-service analytics. Reporting to the Director of Enterprise Data Office, the ETL Developer will be responsible for end-to-end data pipeline development from ingesting the raw data into the centralized data lake, to transforming the data into business-friendly data models on the Enterprise Data Warehouse that can be easily consumed by the business through Business Intelligence applications and other downstream processes.
This role will assess the data requirements provided by the Manager of Business Data Analysis and collaborate with other team members and the source data owners to design and build automated batch or near-real-time data ingestion pipelines that will ingress the necessary data from the source, which may be a variety of formats and mediums such as relational/non-relationship databases, flat files, and applications, into the centralized data lake. Subsequently, under the guidance of the Data Architect, who will provide the target data models, the ETL developer will build the transformation pipelines necessary to materialize various types of data models into the Enterprise Data Warehouse. The ETL developer will work collaboratively with the Data Architect in the deployment, automation, and orchestration of these newly developed data pipelines, and collaborate with the BI engineers to ensure the smooth connection of these data models into the BI semantic layer so that it can be leveraged easily by business users. Finally, the ETL developer will also assist the Data Architect and the Manager of Business Data Analysis in the maintenance and support of the data pipeline operations as well as the overall EDO environments.
StackAdapt is a Remote-First company. We are open to candidates located anywhere in Canada for this position.
What you'll be doing:
What you’ll bring to the table:
StackAdapters Enjoy
If this role speaks to you then please submit an application - we'd love to speak with you. Due to a high volume of interest, only those shortlisted for interview will be contacted.
#LI-KR1
