BI Developer at Sonoma Consulting in Portland, OR

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.