ETL Developer #2365
Position Summary:
Our partner, a cloud-based software platform designed to optimize veterinary practice management, is looking to add an ETL Developer to their team. In this role, you will be responsible for designing, developing, and maintaining robust and scalable Extract, Transform, and Load (ETL) processes to support the organization's projects and initiatives. You will work closely with cross-functional teams to gather requirements, implement data extraction and transformation workflows, and ensure the reliability and performance of the data pipeline. You will play a crucial role in ensuring that data is accurately captured, processed, and made available for reporting, analysis, and other business purposes.
Experience and Education:
Bachelor or higher degree in Computer Science, Information Systems, Information Technology, or a related technical field/experience.
5+ years of experience in ETL development and processes.
Experience with data warehousing principles, concepts and best practices.
Experience working within a Google Cloud Platform (GCP) environment.
Skills and Strengths:
Python
Google Cloud Platform
PostgreSQL
ETL Processes
Data warehousing
Data modeling
Data pipelines
Apache Airflow/Kafka (as a plus)
Elixir (as a plus)
Primary Job Responsibilities:
- Design, develop, and implement efficient ETL processes to extract, transform, and load data from various sources into target systems.
- Develop and maintain data pipelines.
- Gather and extract data from legacy systems and other sources using appropriate techniques, connectors, or programming interfaces.
- Transform and load data into data warehouses, ensuring data integrity, referential integrity, and appropriate data modeling principles.
- Leverage Python for complex data processing and data extraction.
- Leverage GCP services for data storage, processing, and analytics.
- Collaborate with business stakeholders to understand data requirements and translate them into technical solutions.
- Maintain and monitor ETL processes to ensure their smooth functioning, data accuracy, and timely data updates.
- Create documentation of the ETL processes, data mappings, data lineage, and metadata to ensure proper understanding and governance.
- Stay up to date with industry trends, emerging technologies, and best practices related to data integration, ETL, and data warehousing.