Business Systems Analyst - SQL, ProjectWise

Job Title: Business Systems Analyst - SQL, ProjectWise

Location: Salem, OR (remote)

Duration: 6-7 months

Key Skills: Enterprise Content Management System, ProjectWise, SharePoint, SQL, Business Analysis

Job Description:

We are seeking a skilled Computer Systems Specialist to join our team at the Client's (Tech and Data Unit - TDU). The ideal candidate will provide technical guidance for the development and troubleshooting of computer systems, identify necessary system components, and develop secure system implementation guidelines. This role is pivotal in supporting and maintaining client's Enterprise Content Management (ECM) software, ProjectWise.

Key Responsibilities:

Consultation & Recommendations:

• Provide expert consultations and solution recommendations for client's ECM software, specifically ProjectWise.

Process Documentation:

• Develop comprehensive as-is and to-be process documentation.

Business Data Requirements:

• Use various information gathering techniques (e.g., interviews, facilitation, diagrams) to gather, define, and document complex business data requirements.

System Improvement:

• Identify and propose areas for improvement in current systems.
• Collaborate with business partners and stakeholders to enhance business processes related to ECM.

Impact Analysis & Specifications:

• Conduct, document, and present impact analyses.
• Create and manage requirements traceability matrix.
• Develop functional specifications for data models, customizations, extracts, and reports.

Implementation Support:

• Create implementation documentation and support the implementation process.
• Design changes in asset management software in development and testing environments, ensuring seamless integration into the production environment.

Data Cleanup & Testing:

• Plan and support data cleanup activities.
• Prepare test data, implement and support test activities including creation of test plans and cases.
• Create and implement regression test plans and cases.
• Plan and support user acceptance testing.

Collaboration & Training:

• Coordinate with team members to meet project milestones and deadlines.
• Engage and build strong working relationships with IT, Business, and Sourcing partners.
• Create training materials for both Business and technical audiences, including User Guides, Job Aids, PowerPoint presentations, and training data.
• Conduct in-person and remote training sessions.

Troubleshooting:

• Troubleshoot issues, determine causes, and provide solutions.

Qualifications:

Education & Experience:

• Bachelor's degree in a related area with at least 6 years of experience, or equivalent experience in the field or a related area.

Technical Skills:

• Experience with ECM software, specifically Bentley's ProjectWise.
• Proficient in SharePoint, MS Office, and Microsoft SQL.

Other Skills:

• Business analysis skills.
• Strong communication skills (verbal and written).
• Development and systems/data analyst skills for release development tasks.
• Testing/analysis skills for the release development tasks and release acceptance testing tasks.
• Ability to produce business analysis deliverables: business process and workflow diagrams, system requirements, design specifications, and training and testing materials to facilitate implementation activities.
• Ability to complete work without direct supervision.
• Proficient in soft skills with an emphasis on customer relations, time-management, critical thinking, and organizational skills.