We are looking for a skilled ETL Developer to design, implement, and maintain efficient data pipelines using industry-leading tools like Alteryx. The ideal candidate will focus on extracting, transforming, and loading data from diverse sources into data warehouses and databases, ensuring the accuracy and reliability of data for further analysis. This role requires a strong technical background in data handling, data transformation, and automation of ETL processes.
Key Responsibilities:
- Design and Implement ETL Processes: Build and maintain ETL workflows using Alteryx and other tools to ensure data is properly extracted, transformed, and loaded from various sources.
- Data Extraction: Collect data from multiple sources such as databases, APIs, spreadsheets, and flat files.
- Data Transformation: Cleanse, aggregate, and transform raw data into formats suitable for loading into data warehouses or databases.
- Data Loading: Load transformed data into target systems, ensuring data integrity and consistency.
- Performance Optimization: Optimize ETL processes for scalability, efficiency, and reliability.
- Data Integration: Combine and harmonize data from disparate systems to create unified datasets for analytics.
- Automation and Scheduling: Set up and manage automated ETL workflows, schedules, and monitoring systems to ensure regular data updates.
- Data Quality Assurance: Implement data validation and quality checks to ensure accurate and reliable data delivery.
- Troubleshooting: Diagnose and resolve any issues related to ETL workflows and data integrity.
- Documentation: Maintain comprehensive documentation for ETL processes, including workflow diagrams, data mapping, and transformation logic.
Required Skills and Qualifications:Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.1+ years of experience in ETL development, data engineering, or a similar role.Proficiency with Alteryx for data extraction, transformation, and loading processes.Strong SQL skills for querying, managing, and manipulating data.Familiarity with data integration and ETL tools beyond Alteryx.Problem-solving skills with a focus on data accuracy and transformation logic.Ability to work with large data sets and complex data environments.Attention to detail and a methodical approach to handling data.