I wanted to know if there are any flexibility tests I should be looking at to specifically identity if weight-bearing activities (carrying a heavy backpack all day) relates to muscle stiffness, such as lumbar and hamstring muscles.
Some of the most basic flexibility assessments of the lower extremities would be things like the Thomas test and straight leg raise test. They would give you a basic idea of muscle tightness.