Summary
✨ AI‑Generated
A mid-level ETL developer opportunity focused on designing, developing, and supporting reliable data integration workflows. You will work with data from varied sources and formats, build warehouse processes, apply quality and validation controls, optimize performance, handle errors, and support production systems.
Highlights
Mid-level data engineering role centered on end-to-end ETL development, data integration, warehouse systems, validation, performance optimization, and production support.
Description
The ETL (Extract, Transform, Load) Developer develops, designs, and supports ETL processes and tools.
Responsibilities include data loading and manipulation to ensure data from various sources and formats are efficiently and effectively integrated into company’s data warehouse system.
Preferable Skills
Experience with Microsoft SSIS packages (Business Intelligence Tools).
Familiarity with Python programming for data extraction from PDFs, Excel files, and images.
Advanced knowledge of T-SQL scripting and database development.
Strong understanding of Quality Control (QC) processes and data validation techniques.
Experience in designing, developing, and supporting end-to-end ETL workflows, including performance tuning, error handling, and production support.
Essential Duties And Responsibilities
Develop and manage effective working relationships with other departments, groups, and personnel with whom work must be coordinated or interfaced.Establish and enforce data warehousing standards to meet requirements and business needs.Evaluate existing subject areas stored in the data warehouse and determines where data should be stored.Create SSIS ETL solutions with Microsoft SQL Server environmentUtilizes SQL development to produce effective database developmentDevelops solutions to minimize implementation risk and time and/or improve system reliability and performance.Review ETL programs for compliance with best practices, standards, enterprise architecture and documentation requirements, ETL process, programs, and scripts.Conduct root cause analysis and resolve performance and production problems and data issues.Validate the data in the database and test the developed routines.Provide ongoing maintenance and support of assigned ETL applications.Assist in several components of the overall ETL process and data warehouse system.Document tasks for end-user, technical, and managerial review to ensure high quality customer service.Perform quality assurance testing of data integration and report development and monitor data load operations to ensure accuracy.Meet professional obligations through efficient work habits such as, meeting deadlines, honoring schedules, coordinating resources and meetings in an effective and timely manner, and demonstrate respect for others.All work responsibilities are subject to having performance goals and/or targets established.
