Sonoma Consulting Inc.
Enterprise SaaSDirect SmartRecruiters career site

BI Developer

Location
Portland, OR
Job type
Full-time
Level
Mid-level
Experience
3+ years
Education
Bachelor's degree
Listed
Today

Skills & highlights for this role

  • SQL Server
  • SSAS
  • SSRS
  • SSIS

Also useful

  • Microsoft Dynamics AX
  • Halo BI
  • Salesforce Marketing Cloud
Free · No account needed

How well does your resume fit this job?

Upload your resume to see your score for this Sonoma Consulting Inc. role, what matches, what's missing, and your best other matches.

Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.

Position Summary

Provide timely, accurate and actionable data to ensure successful business decision-making. Gather requirements from business users, determine the best reporting solution, design, build and deploy reports and dashboards using a variety of front end visualization tools (Halo BI, SSRS, Atlas, Excel). Play multiple roles including business analyst, architect, report developer, SQL programmer, visualization designer and end user trainer.

Our Director is looking for a BI Developer that manipulates data into a cube or dimensions, SSAS - this is newer methodology.

Qualifications & Requirements

  • Education and/or Experience: Bachelor's Degree in Computer Science or related field of study.
  • Minimum of 3 years of experience as a business intelligence database developer or related field.
  • Experience with the Microsoft BI Stack (SQL Server, SSRS, SSIS & SSAS) required.
  • Expert with SQL and with ability to write complex SQL queries.
  • Strong knowledge of relational and multi-dimensional database architectures.
  • Extensive knowledge of query optimization and performance tuning techniques.
  • Ability to understand business processes.
  • Advanced knowledge of a manufacturing environment is preferred, including supply chain systems, sourcing, logistics and finance.
  • Experience with Microsoft Dynamics AX is preferred.
  • Excellent skills in interpersonal relationships, communication and teamwork.
  • Possess strong written and oral communication skills.
  • Work independently and possess a high level of self-motivation and initiative.
  • Effectively prioritize and follow through on assignments and projects.

Essential Functions

  • Translate business requirements into well-developed reporting solutions to meet business needs.
  • Develop standards, best practices and repeatable processes to ensure data standardization and consistency.
  • Build and maintain project files for the extraction, transformation and loading of organization data from multiple data sources.
  • Design and implement SSAS cubes.
  • Develop reports from Microsoft Dynamics AX using SSRS.
  • Ensure data accuracy by performing cube validation.
  • Create data visualizations that clearly convey key insights that are actionable.
  • Handle and prioritize Ad-Hoc reporting requests as they arise.
  • Support Salesforce Marketing Cloud with query requests and daily build maintenance.
  • Build and maintain documentation related to the company's database environment.
Read the original posting

From Sonoma Consulting Inc.'s careers page, first listed on Rolev.ai on November 19, 2026. Rolev.ai is not the employer.

How Rolev.ai helps with this application

Rolev.ai is a job search and application tool for US job seekers. For this BI Developer role at Sonoma Consulting Inc., it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.

  • See how you fit

    Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.

  • Tailor without inventing

    Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.

  • Draft the full kit

    Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.

  • 1-Click Extension Autofill

    The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.

Common questions

Where is the BI Developer job at Sonoma Consulting Inc. located?

This BI Developer position at Sonoma Consulting Inc. is located in Portland, OR. Always check Sonoma Consulting Inc.'s application page for specific state eligibility or relocation policies.

What qualifications are required for BI Developer at Sonoma Consulting Inc.?

For the BI Developer role, Sonoma Consulting Inc. highlights 3+ years of relevant experience; a bachelor's degree; experience with SQL Server, SSAS, SSRS, SSIS. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.

How do I apply for the BI Developer position at Sonoma Consulting Inc.?

This listing links directly to Sonoma Consulting Inc.'s SmartRecruiters application page. You can apply directly on Sonoma Consulting Inc.'s site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.