
Operations Systems Coordinator
Hubbell Incorporated
full-time
Posted on:
Location Type: Office
Location: Aiken • South Carolina • United States
Visit company websiteExplore more
About the role
- Gather requirements from key business users and develop proposed solutions
- Review proposed solutions with key business users for approval of final solution and project scope
- Implement data transfers, queries, and reports to meet customer needs
- Create and maintain standards and procedural documentation related to solutions
- Design and develop queries for user community using different software tools
- Perform Data Validation and data integrity tests and ensure reports and applications comply with user requirements
- Develop jobs/processes to ensure efficient, accurate receipt and processing of data sources
- Monitor and recommend changes if required to all SQL packages and provide stored procedures and design and develop various relational databases
- Troubleshoot data inconsistencies and data integrity issues when necessary
- Provide enhancements to existing databases currently used in Operations by gathering detailed requirements and coordinating the implementation, rollout, and support of relevant systems with the databases
- Troubleshoot, maintain, and further develop the Hubbell Aiken Industrial Internet-of-Things (IIOT) network to enable vendor remote access to automation equipment and internal data collection and storage from automation equipment
- Evaluate, implement, and maintain cloud storage solutions for IoT using MQTT as necessary
Requirements
- Minimum 3 to 6 years of experience in data warehouse/data analysis/data manipulation concepts
- Experience generating, maintaining, and using MSSQL & Microsoft Access databases
- Experience creating reports with Power BI, MS Access, Excel, and Web based reports using Apache Superset
- Minimum 2-4 years VBA experience
- Experience with IoT networking and security
- Solid understanding of OEE concepts
- Aptitude in Data Analysis and presentation
- Good knowledge of logical and physical Data Modelling using normalizing techniques
- Education: Bachelor of Science Degree in Computer Science Engineering or Information Technology
Benefits
- Health insurance
- Retirement plans
- Professional development opportunities
- Flexible work arrangements
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
data analysisdata manipulationMSSQLMicrosoft AccessPower BIVBAdata validationrelational databasesdata integritycloud storage solutions
Soft Skills
requirement gatheringcommunicationtroubleshootingcoordinationpresentation