Overview
The ETL Developer will ensure the stability, integrity & efficient operation of new & legacy data, jobs, procedures, and scripts used by the Data Warehouse Application Development Team. The successful candidate will leverage, develop & strengthen their SQL Server experience and skills.
Responsibilities
• Ensure data accuracy and availability through monitoring and supporting ETL processes from various sources
• Gain thorough understanding of existing processes and procedures including data dependencies
• Independently research & make recommendations for improvements to improve efficiency
• Collaborate with team to refine processes to ensure a high level of data quality and optimal system performance
• Support data development team by executing identified improvement opportunities in batch processes
• Participate in testing for development tool and hardware upgrades
• Provides status updates of work progress to project team and management
• Develop a good working relationship with team members from source systems for coordination and resolution of batch issues
Qualifications
• 3+ years of experience using Microsoft SQL Server including design, creation, and maintenance of relational database objects (tables, stored procedures, scripts, SSIS packages) and automated schedules
• Availability outside of normal working hours to provide oversight, monitor and troubleshoot ETL processing issues
• Strong analytical, problem-solving, deductive reasoning and critical thinking skills
• Familiarity with standard software development concepts (SDLC, modeling, migration / conversion, repositories, change management, unit testing)
• A willingness to learn technology to solve business problems
• Ability to deliver assigned work tasks within project timelines
• Interest in learning about builder supply & construction industry and company business practices
• Excellent interpersonal and communication skills, both oral and written
• Proven success working in a collaborative team environment
• A curious self-starter who can determine viable options or the best next step to work independently to achieve results
Preferred Experience
• Experience with Visual Studio, Azure DevOps, and Azure ADF
Preferred Education
• Bachelor’s degree in Computer Science or a related field.
Location: Eighty Four, PA
Posted: Oct. 7, 2024, 9:45 a.m.
Apply Now Company Website