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
Prefered Experience:
*Experience with Visual Studio, Azure DevOps, and Azure ADF
Prefered Education:
*Bachelor's degree in Computer Science or a related field.
