Overview:
The Business Intelligence ETL Developer is responsible for supporting the data and business intelligence needs of our teams at both Team Headquarters and in the Field. The successful candidate will ensure that our stakeholders have the information and reporting tools needed to support our business process. The Developer will provide technical support of our enterprise data warehouse, including the design, development, implementation of solutions.

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
• Collaborate with team to refine processes to ensure a high level of data quality and optimal system performance
• Supports the technical deliverables for the design, implementation, maintenance, and support of data warehouse systems and applications
• Interpret business requirements; design, build and test processes
• Participates in the data design and the creation of database architecture and data repositories
• Responsible for technical documentation that includes architecture diagrams, process flow diagrams, and prototypes to effectively communicate design ideas
• Participate in testing for development tool and hardware upgrades
• Provides status updates of work progress to project team and management
• Supports the definition, scope and technical estimates for portions of large complex projects
• Contribute to the roadmap for Business Intelligence and data transformation solutions for the team
• Develop a good working relationship with a wide range of stakeholders to design end-to-end experiences
• Partner with other team members as well as cross-functional partners to support business processes and system solutions

Qualifications:

• 5+ 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.

• 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
• Collaborate with team to refine processes to ensure a high level of data quality and optimal system performance
• Supports the technical deliverables for the design, implementation, maintenance, and support of data warehouse systems and applications
• Interpret business requirements; design, build and test processes
• Participates in the data design and the creation of database architecture and data repositories
• Responsible for technical documentation that includes architecture diagrams, process flow diagrams, and prototypes to effectively communicate design ideas
• Participate in testing for development tool and hardware upgrades
• Provides status updates of work progress to project team and management
• Supports the definition, scope and technical estimates for portions of large complex projects
• Contribute to the roadmap for Business Intelligence and data transformation solutions for the team
• Develop a good working relationship with a wide range of stakeholders to design end-to-end experiences
• Partner with other team members as well as cross-functional partners to support business processes and system solution