ETL Support Developer (SSIS) Position Available In Washington, Pennsylvania

Eighty Four, PA
2 DAYS AGO
21528702
Summary
Eighty Four, PA
Competitive Salary
5 Years Experience
High school graduate or equivalency certificate (GED)
No Commisssion
40.00 hours per week / Day Shift /Full-Time
Description Reference #: 20026
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. EOE of Minorities/Females/Vets/Disability