BUSINESS INTELLIGENCE ETL DEVELOPER

A.C. Coy

  • Eighty Four, PA
  • Permanent
  • Full-time
  • 15 days ago
Overview:Location: Onsite near Bridgeville, PAJob Type: Full Time / PermanentWork Authorization: No sponsorshipThe 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. 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+ yearsProvide oversight, monitor and troubleshoot ETL processing issuesFamiliarity with standard software development concepts (SDLC, modeling, migration / conversion, repositories, change management, unit testing)Experience with Visual Studio, Azure DevOps, and Azure ADF - Preferred

A.C. Coy