Resolution Technologies, Inc.
Data Systems Analyst
Resolution Technologies, Inc., Newnan, GA, United States
Data Systems Analyst Job Description:
Job Summary:
Job Summary:
We are looking for a dedicated and technically proficient Data Systems Analyst to join our client
This role focuses exclusively on developing Excel macros, running and optimizing reports in IDMS, and performing related tasks to enhance the efficiency of our procurement processes
improvement.
Key Responsibilities:- Excel Macros Development:
- Design, create, and maintain Excel macros to automate repetitive tasks and improve workflow efficiency for the procurement team
- Ensure that macros are robust, scalable, and user-friendly
- Provide ongoing support and troubleshooting for macro-related issues
- Design, create, and maintain Excel macros to automate repetitive tasks and improve workflow efficiency for the procurement team
- IDMS Reporting:
- Generate, customize, and optimize reports from the Integrated Data Management System (IDMS) to support procurement operations
- Develop and maintain reporting templates to streamline data retrieval and analysis
- Validate report accuracy and data integrity
- Generate, customize, and optimize reports from the Integrated Data Management System (IDMS) to support procurement operations
- Data Analysis and Process Improvement:
- Analyze data from various sources to identify areas for process improvement within the procurement department
- Collaborate with procurement staff to understand their reporting needs and provide tailored solutions
- Implement process improvements based on data-driven insights
- Analyze data from various sources to identify areas for process improvement within the procurement department
- Peripheral Duties:
- Assist with ad-hoc reporting and data extraction tasks as needed
- Document processes and provide training to team members on new tools and macros
- Stay updated with best practices and emerging technologies in data analysis and reporting
- Assist with ad-hoc reporting and data extraction tasks as needed
- Proven experience in developing and maintaining Excel macros, including proficiency in VBA
- Strong experience with IDMS or similar data management systems
- Familiarity with PowerBI and data visualization is highly desirable
- Excellent analytical skills and a keen eye for detail
- Strong problem-solving abilities and capacity to handle multiple projects
- Effective communication skills with the ability to work collaboratively with different teams
- Experience in the construction machinery or manufacturing sector
- Understanding of procurement processes and terminology
- Experience in developing training materials and documentation
- Full-time position with standard working hours
- Occasional overtime may be required based on project demands
- Opportunity for professional development and training