Company:
84 Lumber Company
Location: Eighty Four
Closing Date: 21/10/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
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.
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.
Share this job