Analyst (SQL, Boomi, ERP)

Job Summary:

We are looking for an experienced IT System Analyst with a strong background in SQL, financial applications, interface design / support / development, and ERP application experience. The ideal candidate will have hands-on experience with Boomi integration and the GoAnywhere platform, but it is not a requirement. Candidate should possess technical / interpersonal skills to effectively analyze, design, and implement IT solutions that support our business objectives.

This position will provide IT solutions for a variety of systems including timekeeping and leave, financial and purchasing systems, grant management, and the GoAnywhere file administration platform.

Key Responsibilities:

• Analyze and develop technical solutions for timekeeping and leave, financial and purchasing systems, grant management, and file transfer administration platform systems.
• Collaborate with cross-functional teams to gather business requirements and translate them into technical specifications.
• Design, develop, optimize, and implement SQL queries, reports, stored procedures, and database structures to ensure data integrity, stable integrations, and efficient SQL performance.
• Support, Implement, and Maintain integration processes using Boomi, GoAnywhere, API, and file-based integration platforms, ensuring seamless data flow across applications and systems.
• Conduct system testing in web applications, integration platforms, or SQL clients for troubleshooting and debugging to resolve issues and ensure optimal performance.
• Prepare and maintain comprehensive technical documentation including system designs, technical specifications, script process designs, and user manuals.
• Provide knowledge transfer and support to colleagues / end-users to ensure effective system utilization.
• Manage workload and update tasks through ServiceNow / work management platforms. Key duties include updating the task management system with progress, assigning tasks to other users as applicable, and resolving issues with sufficient documentation to grow the knowledge base effectively.

Required Skills and Qualifications:

• Bachelor’s degree in computer science, Information Technology, or related field.
• 3-5 years of experience as an IT System Analyst or similar role.
• Proficiency in SQL, with experience working with stored procedures, SSIS packages, and complex Data Manipulation commands (select, update, insert, delete) strong understanding of database design and development.
• Experience with ERP web-based applications and integration/file transfer platforms such as Boomi and GoAnywhere.
• Strong analytical and problem-solving skills, with the ability to think critically and make data-driven decisions.
• Excellent communication and interpersonal skills, with the ability to collaborate effectively with both technical and non-technical stakeholders.
• Ability to manage multiple tasks and priorities in a fast-paced environment.

Preferred Skills:

• Familiarity with Boomi and GoAnywhere integration platforms and tools.
• Experience with enterprise resource planning (ERP) systems such as SAP or Oracle.
• Experience with agile methodologies and project management.
• Proficiency in programming languages such as Python, Java, or C# for scripting and automation purposes.
• Experience with data visualization tools such as Power BI or Tableau for creating insightful reports and dashboards.
• Certification in relevant technologies such as Microsoft SQL Server, Boomi Professional Developer, or AWS Solutions Architect.
• Experience in test automation platforms such as TestSavvy.

Experience Required:

• 3 to 5 years of programming/systems analysis experience.

Education Required:

Bachelor's degree in computer science, Information Systems or another related field. Or equivalent work.