A.C.Coy Company
BUSINESS INTELLIGENCE ETL DEVELOPER
A.C.Coy Company, Bridgeville, Pennsylvania, United States, 15017
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 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. Responsibilities
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 Qualifications
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
Location: Onsite near Bridgeville, PA Job Type: Full Time / Permanent Work Authorization: No sponsorship The A.C.Coy company has an immediate 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. Responsibilities
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 Qualifications
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