Data Analyst Ii

PARR is the total source for homebuilding supplies, solutions, and services. We focus on supplying building materials and solutions to professional home builders of all sizes including custom builders, large production builders, and multifamily builders. Our customers and community members know that they can rely on us for Legendary Service and quality products.

Job title: Data Analyst II

Salary: Starting at $87k to $108k depending on experience

Schedule: Monday-Friday 8 am to 5 pm. This is a hybrid role that requires three (3) days in office per week.

Location: Corporate Office in Hillsboro, OR -or- any PARR location in OR and WA

The Data Analyst II (DA) position is responsible for the gathering, cleaning, transfer, management, storage, and analysis of data from a variety of sources to assist with business operations. The DA will work closely with Project Managers and other stakeholders to ensure completeness of vision based on business requirements.

The DA may be responsible for other activities including research, reporting, and participating in the design and testing of data deliverables.

Qualifications

• B.S in technology or related disciplines or equivalent experience
• 4+ years of related experience with data concepts, structures, and architecture
• 2+ years experience with data mapping, integrations, and conversions
• 2+ years experience utilizing MS SQL Server
• Ability to write medium to complex data queries, manipulation of data (SQL)
• 2+ experience with analytical/reporting tools like Power BI, Tableau, etc.
• Demonstrated ability to work effectively in a team environment and to lead others in a directed effort to complete projects
• Strong verbal communication skills including the proven ability to communicate effectively on an individual and group presentation basis
• Skill in assessing stakeholder needs and asking probing questions to understand underlying needs and surface essential requirements information
• Demonstrated ability to work with employees and management at all levels of the organization including skill in working across organizational and geographical boundaries
• Strong analytical skills to critically evaluate the information gathered from multiple sources, reconcile conflicts, deconstruct high-level information into details, abstract up from detailed information to a more general understanding, discern underlying true needs from presented user requests, and distinguish solution ideas from requirements
• Ability to work with changing requirements/priorities using internal and external resources
• Demonstrated skill and ability to produce effective written communication, including report preparation, and documentation for a variety of audiences
• Skilled in software including but not limited to Word and Excel
• Ability to learn new systems and applications
• Ability to task manage using service management tool - Jira, admin experience preferred
• Ability to be self-managed and apply skills in problem solving and decision-making
• Ability to prioritize multiple tasks and projects to meet tight schedules and demanding targets while delivering high quality products; effectively managing competing priorities and reconciling divergent expectations
• Exceptional organizational skills, with the ability to follow through on tasks

Duties and Responsibilities

• Perform Extract, Transformation and Loading (ETL) procedures for implementing data integration and data migration tasks in support of data integration projects
• Develop mappings and workflows to automate data integration and complete data conversions
• Effectively map source to target data to meet business/system requirements
• Provides analytical support to any or all divisions of the organization by mining data, conducting analysis, and interpreting results related to business needs
• Developing knowledge of and the ability to analyze data from most commonly used data systems
• Debug, analyze and troubleshoot data quality issues
• Assist with the development of functional and technical requirements documents for diverse audience (technical and non-technical), including migration, implementation, and test plans
• Identify problems or needed changes, recommends resolution, and participates in quality improvement efforts
• Draft working documents for interfaces and other data systems
• Establishes and maintains productive business partnerships across the organization
• Manages expectations through direct and routine interaction with business partners
• Share knowledge and help mentor fellow team members
• May work under project manager or more senior level IT staff for projects
• May direct other staff on assignments
• Other duties as assigned to ensure efficient and effective system operations

This position primarily works in an office environment with a computer.

Physical Requirements

• Ability to sit and/or stand for extended periods of time
• Ability to work indoors in a normal office environment for an entire day
• Must be able to grasp, talk, hear, and operate a computer and keyboard
• Must be able to work outdoors in all weather conditions
• Must be able to drive a vehicle when necessary
• Both local and overnight travel may be required

We know that without great people, we can't be a great company. Voted the fourth top place to work in Oregon in 2023, we offer industry-leading benefits:

• Everyone starts earning 2 weeks of vacation per year on day 1, and gains an additional day every year worked up to 4 weeks off
• Employee paid sick days
• 7 holidays
• 2 medical plan options, one with a high deductible that offers an HSA and our standard plan with a very low $1,250 deductible
• Dental, Vision, EAP (Employee Assistance Program)
• Massage, Chiropractic and Acupuncture coverage
• FSA (Flexible Spending Account) and Childcare pretax spending programs
• HSA (Health Savings Account) - PARR will match up to $360/year
• Up to 50% match on the first 6% you contribute to your 401(k) after 1 year of employment and fully vested at the end of your 3rd year
• In addition to the 401(k) match, there a 3% profit share contribution to the 401(k), with Board approval
• Tuition reimbursement (up to $2,500/year)
• Annual profit sharing (every full time employee who worked the full year earned a minimum of $2,700 for the 2020 year)
• $1,000 referral bonus

PARR Promotes!

We have a transparent pay structure, and love to promote from within. Our current CEO started with the company as a driver and by being open to change and a self-starter he climbed the ranks to the role he has today. There are many members of our management team who started their careers in our entry-level positions. If you're willing to work hard, there's no reason you won't earn regular merit increases and promotions. There is A LOT of opportunity - PARR is growing fast!

We value our employees like family and are constantly working to provide a safe place to work for our employees. Most of our locations are not open past 5 and all our locations are closed on Sundays.

Our company mission is Legendary Service through Teamwork, and we take that seriously. When you join our team, you're joining a family owned company that's been in business for 90 years, with a well-established reputation as a leader within the building material supply industry in the United States.