Job Description
Job DetailsJob Location: Corporate - Clackamas, OR 97015Position Type: Full TimeSalary Range: $67,000.00 - $80,000.00 Salary/yearOur Vision
A world where no resource is wasted.
Our Mission
To ensure that no resource goes to waste by empowering people to redeem every container easily, efficiently, and effectively.
Our Values
We are loyal, resilient, trustworthy, creative, competent, and engaged.
Summary
Business Intelligence Analyst supports data reporting and analytics by building and maintaining reports and dashboards in OBRC’s reporting tools, including Power BI, SQL Server Reporting Services, and others. This role works with Azure SQL and other data sources to help OBRC’s leadership and teams understand performance, trends, and key metrics.
Primary Duties & Responsibilities
Write and maintain SQL queries against Azure SQL and other databases
Build and update SSRS reports and Power BI reports and dashboards
Validate data accuracy and troubleshoot reporting issues
Work with stakeholders to understand basic reporting needs
Other duties as assigned.
Education/Experience
Bachelor’s degree in business administration, Statistics, Mathematics, Accounting, or Computer Science required.
2+ years’ experience in business intelligence, data analysis, and database management.
Requirements – Skills, Job Knowledge & Abilities
In-depth understanding of database design and construction.
Advanced proficiency in use of reporting tools, Excel and transact SQL queries
Proficiency and professional knowledge of Microsoft Office Suite.
Demonstrated ability to successfully prioritize and manage multiple projects, adhere to deadlines, handle frequent changes effectively and professionally, follow through on issues in a timely manner.
Strong organization skills with exceptional attention to detail.
Strong verbal and written communication skills; ability to communicate effectively at all levels with both internal and external partners.
Technical proficiency in BI tools, specifically Power BI.
Analytical and critical thinking.
Nice to Have
Familiarity with Azure data platforms.
Exposure to DAX or Power Query.
Experience with business or operational data.
Benefits and Perks
Comprehensive medical, dental, and vision coverage.
401(k) with 100% match on employee deferrals up to 4% of compensation. 50% match on deferrals between 4%-6%
Generous PTO plan and 7 paid holidays annually.
Free on-site coffee and tea station.
Supervisory Responsibility
None
Travel
None
Working Conditions/Physical Requirements
Perform work in an indoor professional office environment.
Use standard office equipment and supplies.
Sit/stand for continuous periods of time at a desk and work on a computer, walk occasionally
Use arms, wrists, hands and fingers to reach, grasp objects, use tools, and for writing and keyboarding.
Read, write, and speak to communicate effectively with others.
Listen to interpret comments and instructions received.
Visual abilities for close and distance vision, peripheral vision, and the ability to adjust focus.
Lift, carry and push/pull 20 pounds.
Qualifications