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
- Bachelors degree in Computer Science or a related field.