Systems Reporting Analyst
At Kingspan, our future success is based on the quality of our people, who's expertise and motivation have helped ensure that we remain at the forefront of the construction materials manufacturing industry. In joining Kingspan you become an important part of a growing organization with a reputation for innovative design and use of technology, technical expertise, product quality, service excellence, and dedication to sustainability.
Ready to be part of our team?
We are looking for a Systems Reporting Analyst/Business Analyst for our DeLand, FL location (possible remote opportunity).
Required: SQL database and maintenance experience and creating queries.
Summary:
This position will design, develop, configure, test and maintain all system reporting, including SQL Queries, Power BI, Salesforce and any BI software integrating all of Kingspan’s systems for a unified reporting process. The reporting solutions will be based on customer requirements, using development standards, and software lifecycle process. Daily tasks will include requirements analysis, design, planning, programming, testing, documentation, error/exception handling, and performance improvements. You will work with all systems and all functional areas to align the reporting needs/outputs with the business process. As the expert you will be expected to implement best practices, lead workshops to understand business needs, and train employees on new procedures.
Responsibilities
Essential Duties:
- Interact with all functional departments to gather requirements, prioritize work, develop enhancements to the current system, coordinate testing, and perform change/management/training for all system-based reporting
- Develop and maintain SQL queries and scheduled jobs
- Design comprehensive BI solutions, translating complex requirements into an optimal report/BI design
- Design processes to minimize data quality risks and proactively identify potential data issues
- Build and enhance BI objects including Power BI, DTPs, Salesforce, etc.
- Prepare required transport documentation as needed to move system reporting changes into a production environment.
- Develop functional specifications and technical specifications for system reporting changes.
- Maintain documentation on all system reports including, a description, system(s) used as source data, fields being pulled, departments & user using the report
- Identify metrics and related reports that will be used after implementation to monitor process integrity and identify potential issues.
- Ensure deliverables are met on time, on/under budget, and meet or exceed expectations.
- Must have the ability to manage multiple projects and work without close supervision.
- Must be able to present information in professional and user friendly package, detailed oriented with strong organizational and communication skills.
- Must be able to travel within North America
Qualifications
Education/Experience:
- 4 year Technical/Financial degree, MIS or Computer Science is preferred
- Strong SQL experience is required
- 3+ years of relevant experience with SQL, BI, SAP BW, Power BI or other system-based reporting structures
- BOBJ and SAP Report Development
- Experience in database design and query/reporting tools
- Strong analytical skills and demonstrated developing analytical solutions
- Certification in SAP BW, Power BI or any BI solution a plus
- CRM system experience, Salesforce a plus
- Experience in a Manufacturing environment a plus
Computer Skills:
- Must be highly proficient in all Microsoft Office applications (Word, Excel, Power Point, Visio & Project) and Outlook.
- Strong Excel skills (macros, pivot tables) a plus
- Computer programming experience a plus, specifically SAP or Salesforce certifications
- Experience with SAP, Salesforce, Power BI, Javascript, Adobe forms, Drawloop, DocuSign, OneDrive, Azure a plus
Employment Disclaimer
**Kingspan is an Equal Opportunity Employer**