BI Reporting & Data Analytics Analyst

Sbsnw; Portland (OR); On-site; USD 90,000 - 130,000; Full time

Job summary

Strategic Business Solutions in Portland, Oregon is seeking an experienced BI Reporting & Data Analytics Analyst to support a large-scale reporting modernization and migration initiative.

The role focuses on building, testing, validating, revising, and migrating 50+ BI reports within Microsoft data environments, working closely with business, engineering, and architecture teams to ensure accurate, production-ready outputs.

Qualifications

• Hands-on BI reporting, testing, and validation.
• Experience building and migrating enterprise reports.
• Strong SQL skills and ability to read existing queries.
• Experience with Azure SQL and Synapse environments.

Responsibilities

• Build, maintain, revise, and update BI reports.
• Test reports prior to production deployment and validate outputs.
• Support migration and modernization of 50+ reports.
• Collaborate with owners and business users to understand needs.
• Read and validate SQL queries used for reporting.
• Work with Azure SQL environments and Synapse endpoints.
• Validate migrated outputs against legacy data.
• Assist with requirements clarification and translation to outputs.
• Ensure reporting outputs are production-ready through testing.
• Gather information from stakeholders to move deliverables forward.

Skills

BI reporting

Data analytics

SQL

Tools

Azure SQL

Azure Synapse

Power BI

Job description

Portland, United States | Posted on 09/14/2026

We are seeking an experienced BI Reporting & Data Analytics Analyst to support a large-scale reporting modernization and system migration initiative.

This role will be heavily focused on building, testing, validating, revising, and migrating business intelligence reports as the organization transitions from a legacy environment to a new commercial platform. The selected consultant will support a portfolio of more than 50 reports and work closely with business stakeholders, engineering teams, and architecture teams to ensure reporting outputs are accurate and ready for production.

This is not a traditional Business Analyst or project management position. The strongest candidate will come from a hands-on BI/reporting and data analytics background with strong SQL skills and experience working within Microsoft data environments.

Key Responsibilities

• Build, maintain, revise, and update BI reports.
• Test reports prior to production deployment and validate reporting outputs for accuracy and completeness.
• Support the migration and modernization of 50+ existing reports.
• Work with report owners and business users to understand reporting needs, clarify information, and validate results.
• Read, understand, and validate SQL queries used to support reporting and analytics.
• Work with Azure SQL environments and validate information coming from Synapse endpoints.
• Perform data validation and reconciliation activities associated with report and system migration.
• Investigate reporting discrepancies and work with technical teams to identify and resolve data issues.
• Collaborate closely with engineering, architecture, reporting, and business teams.
• Assist with requirements clarification where needed, with an emphasis on translating business reporting needs into accurate reporting outputs.
• Validate migrated reports against legacy outputs and underlying source data.
• Support testing, revision, and production-readiness activities throughout the reporting lifecycle.
• Independently gather information from appropriate stakeholders and keep assigned reporting deliverables moving toward completion.

Required Qualifications

• Strong professional experience in BI reporting, reporting analytics, or data analytics.
• Hands-on experience developing, modifying, testing, or validating business intelligence reports.
• Strong SQL skills with the ability to read, understand, and validate existing SQL queries.
• Experience working with Azure SQL.
• Experience working with or validating data from Azure Synapse environments.
• Strong analytical and data-validation skills.
• Experience identifying and investigating discrepancies between reporting outputs and underlying data.
• Ability to work effectively across both business and technical teams.
• Strong communication skills with the ability to work directly with report owners and stakeholders.
• Ability to independently navigate a complex enterprise environment and drive assigned deliverables forward.

Preferred Qualifications

• Experience with Power BI and a strong understanding of BI reporting concepts.
• Understanding of reporting models and reporting architecture.
• Experience supporting report migrations or large reporting-modernization initiatives.
• Previous experience supporting a major system implementation or legacy-system replacement.
• Experience working within a utility or similarly complex enterprise environment.
• Business analysis experience is helpful but is not the primary focus of the position.

Strategic Business Solutions is committed to fostering a diverse and inclusive workplace. We provide equal employment opportunities to all qualified candidates, regardless of race, gender, age, disability, sexual orientation, or any other protected characteristic. We believe in fair hiring practices and a work environment that values respect, equity, and opportunity for all.