BUSINESS INTELLIGENCE ETL DEVELOPER

Location: Onsite near Bridgeville, PA  

Job Type: Full Time / Permanent 

Work Authorization: No sponsorship

The A.C.Coy company has an immediate a Business Intelligence ETL Developer.  Ideal candidates must have 5+ years of experience using MS SQL Server including design, creation, and maintenance of relational database objects (tables, stored procedures, scripts, SSIS packages) and automated schedules. 

• Ensure that the stakeholders have the information and reporting tools needed to support the business process
• Provide technical support of the enterprise data warehouse, including the design, development and implementation of solutions
• 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
• 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
• Available to work outside of normal working hours to provide oversight, monitor and troubleshoot ETL processing issues

Education:

• Bachelor's degree in Computer Science or a related field - Preferred

Experience Required:

• Experience using Microsoft SQL Server including design, creation, and maintenance of relational database objects (tables, stored procedures, scripts, SSIS packages) and automated schedules - 5+ years

• SSIS/ETL (SQL Server Integration Services/ Extract, transform, load) - 5+ years

• Provide oversight, monitor and troubleshoot ETL processing issues

• Familiarity with standard software development concepts (SDLC, modeling, migration / conversion, repositories, change management, unit testing)

• Experience with Visual Studio, Azure DevOps, and Azure ADF - Preferred