Job Title: Senior IT Systems Analyst
Pay & FSLA Status: Competitive Compensation, D.O.E., Hourly non-exempt
Regular Schedule & Shift: Monday - Friday, Day shift
Regular Weekly Hours: Full-time/40 hours per week (overtime as needed)
Paid Time Off (PTO): 80 hours accrued year 1; 120 hours accrued annually after year 1
Paid Sick Time: 40 hours annually
Management Position: No
Branch Location: Corporate office in Wilsonville, OR; Hybrid flexible
POSITION SUMMARY:
The Senior IT Systems Analyst will work to support, maintain, and enhance key BI, ERP (Enterprise Resource Planning) system functional areas, as well as support systems users. This position will be a team member at our corporate headquarters, interacting with IT leadership and internal customers.
OrePac Building Products seeks dynamic individuals who exemplify excellence in quality, trust, value, and service. Our ideal candidate for this position is a self-motivated professional who has excellent communication skills, problem solving skills, and a strong understanding of IT systems and infrastructure in the business environment.
COMPENSATION & BENEFITS PACKAGE:

• Competitive compensation, D.O.E. opportunities for quarterly/annual performance bonuses based on branch/company/employee performance annual reviews with opportunities for pay increases based on employee performance.
• Medical, dental, and vision insurance up to 70% paid by OrePac.
• FREE Informed Health Line and Health Advocates.
• Health Spending Account (HSA) available with up to $1,000 annual OrePac contribution.
• Flexible Spending Account (FSA) available.
• FREE Employee Assistance Program (EAP).
• FREE life and Long-Term Disability (LTD) insurance.
• Short-Term Disability (STD) insurance available.
• Accident, Hospital Indemnity, and Critical Illness plans available.
• 401K with up to 3.5% OrePac contribution.
• Paid time off (PTO) as specified above.
• Paid sick time as specified above.
• 7 paid holidays annually.
• FREE gym membership.
• Employee discount.

ESSENTIAL DUTIES & RESPONSIBILITIES:

• Work with branches, administrative departments, IT management, and operations departments to identify IT system needs, opportunities, and solutions.
• Analyze and interpret complex data to identify trends and insights that drive business decisions.
• Participate in systems support help desk and user training activities.
• Thoroughly understand ERP UI, workflows, and database schema.
• Analyze and troubleshoot system issues reported by users.
• Perform testing and QA activities.
• Perform research and project management for various IS projects as needed.
• Design, develop, and maintain workflows and dataflow processes across the Microsoft stack.
• Perform data modeling, design, and implementation of ETL workflows. Design, develop, test, and deploy data solutions.
• Develop Business Requirement Documents (BRD's), Functional Requirement Documents (FRD), Use Case Documents, Standard Operating Procedures (SOP's) and Software Requirement Specifications (SRS's) across the deliverables of a project to support enhancements for ERP and BI systems.

REQUIRED SKILLS:

• ERP system administration skills.
• Experience with SDLC and Project management methodologies including Agile.
• Gathering system requirements, defining business processes, UML modeling, DFD, and ERD diagramming.
• Expertise in creating SQL Queries, Query tuning, and a strong understanding of data and analytics.
• Data warehousing and ETL processes.
• Professional writing and verbal skills.
• Self-motivated. Collaborative teamwork mindset yet comfortable working independently.
• Strong user support and communication skills.
• Strong project management skills which allow you to prioritize, communicate, and execute effectively.
• Resourceful self-starter, eager to learn, and a creative problem solver.
• Microsoft Office suite.

DESIRABLE SKILLS:

• SQL Database administration and developer skills including Triggers, Stored Procedures, Indexes, Security, SSAS, and SSIS.

• Experience developing and publishing Power BI reports, dashboards, and DAX coding.
• Power BI data modeling skills.

REQUIRED EDUCATION & EXPERIENCE:

• Bachelor's degree in Computer Science, Information Systems, Information Technology, Business, Accounting, Finance, Mathematics, or a related field.
• Any combination of education, training, or experience that demonstrates the ability to perform the duties of the position will be accepted in place of the education and/or experience requirements listed for this role.

PHYSICAL DEMANDS:

• Regularly required to see, talk, and hear. Specific vision abilities required by this job include close vision, the ability to adjust focus, and peripheral vision.
• Ability to lift files, open filing cabinets, and bend or stand on a stool as necessary.

WORK ENVIRONMENT:

• The noise level in the work environment is generally quiet.
• This position operates in a professional office environment.
• This position routinely uses standard office equipment such as laptop computers, photocopiers, and smartphones.

DRESS CODE:

• All employees are expected to wear clothing appropriate for the nature of OrePac business and the type of work being performed. Clothing should be neat, clean, and tasteful.

SAFETY DUTIES & RESPONSIBILITIES:

• Report all incidents and accidents to one's immediate supervisor immediately or within 24 hours.
• Maintain the work area in a safe and healthful condition.
• Report, and whenever possible correct, unsafe working conditions to branch leadership.
• Operate vehicles while in the course of employment in a safe and lawful manner.
• Provide assistance to reduce or eliminate workplace hazards.
• Comply with company drug testing policies and procedures.
• Comply with company Personal Protective Equipment (PPE) policies. OrePac will provide required PPE to employees.

OREPAC HISTORY & CULTURE:
Founded by the Hart family in 1977, OrePac is a family-owned and operated wholesale building materials supplier providing product, sales, and technology solutions to the shelter industry.
At OrePac we value trust, integrity, and a dedication to excellence. That commitment can be found in the services we offer, the quality of the products we provide, and the way we treat our employees and customers. This dedication to our markets has enabled us to make a positive impact on the shelter industry and the communities we serve.
Our vision is to create trusted partnerships by providing quality products and maintaining strong relationships through unmatched service, operations, and logistics. Our mission: Make Complicated Simple .
LEGAL STATEMENTS:
OrePac provides equal employment opportunities (EEO) to all employees and applicants without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, OrePac complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.
This job description is not intended to contain a comprehensive list of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time, with or without notice.
Regularly scheduled workdays, hours, and shifts are described above. Shift availability may vary. Hours may need to be extended or adjusted at any time, with or without notice, to meet the needs of the organization.
To perform this job successfully, an individual must be able to perform each essential duty and responsibility satisfactorily. The required skills, education, experience, and physical demands listed above are representative of the minimum knowledge, skills, and/or abilities required to perform the essential functions satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
The work environment characteristics described above are representative of those an employee encounters while performing the essential functions of this job.
OrePac supports a safe and drug-free workplace. OrePac may administer a pre-employment background check and/or drug-screen, as well as random and/or reasonable suspicion drug-screens during employment.
Employees are required to perform safety duties and responsibilities in accordance with acceptable and safe work procedures. OrePac's safety policy requires the use of Personal Protective Equipment (PPE) in designated safety-sensitive areas while on OrePac property. OrePac employees who handle or deliver OrePac products while not on OrePac property are required to adhere to OrePac's safety policy and use the required PPE necessary for their specific role.
The dress code described above is representative of what an employee must wear while performing the duties of this position. Individual branches may issue more specific guidelines than what is outlined below. Reasonable accommodations may be made for individuals with religious beliefs . click apply for full job details

About the Company:
Orepac Holding Company