Associate Developer - Business Intelligence ETL Support (SSIS)

Reference #: 15486

OverviewThe 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.

ResponsibilitiesEnsure 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

Qualifications3+ 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.EOE of Minorities/Females/Vets/Disability