BI Developer

Sonoma Consulting Inc.; Portland (OR); On-site; USD 80,000 - 100,000; Full time

Job summary

A prominent consulting firm based in Portland is seeking a BI Developer to deliver actionable data for decision-making. This role involves translating business requirements into reporting solutions and utilizing the Microsoft BI Stack to develop standards and best practices. The ideal candidate will have at least 3 years of experience, a Bachelor's degree, and expertise in SQL, along with strong interpersonal skills and the ability to prioritize projects effectively. Competitive compensation and opportunities for professional growth are offered.

Qualifications

• Minimum of 3 years of experience as a business intelligence database developer or related field.
• Expert with SQL and ability to write complex SQL queries.
• Strong knowledge of relational and multi-dimensional database architectures.

Responsibilities

• Translate business requirements into well-developed reporting solutions.
• Develop standards, best practices and repeatable processes.
• Design and implement SSAS cubes.

Skills

Business intelligence database development

SQL

Reporting and dashboard design

Data visualization tools

Query optimization

Communication skills

Education

Bachelor’s Degree in Computer Science or related field

Tools

Microsoft BI Stack (SQL Server, SSRS, SSIS, SSAS)

Microsoft Dynamics AX

Job description

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

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.

Additional Information

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.