BI Developer
At a glance
Mid-level Data Analysis & BI role at Sonoma Consulting Inc. Portland · full-time · no salary stated · we estimate $86,500–$135,038 across the United States.
Sonoma Consulting Inc. has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Turn business users’ needs into reports and dashboards, choosing the reporting approach and visualization tools
- Build and maintain repeatable ETL project files that bring company data together from multiple sources
- Design SSAS cubes, check their accuracy, and create SSRS reports from Microsoft Dynamics AX
- Handle incoming ad hoc report requests and maintain query builds for Salesforce Marketing Cloud
- Document the database environment and set practices that keep data consistent
What you bring
- At least three years developing business intelligence databases or working in a related field
- A bachelor’s degree in computer science or a related area
- Experience with SQL Server, SSRS, SSIS and SSAS, plus the ability to write complex SQL queries
- Strong command of relational and multidimensional database design, query optimization and performance tuning
Who this fits
This mid-level, onsite Portland role suits someone who can work across requirements analysis, SQL development, reporting, visualization and user training. You’ll need to understand business processes and be comfortable working independently, prioritizing assignments and collaborating with others.
From the employer
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.
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.
Data Analysis & BI work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Analysis & BI
Find me workBy the team behind dataroles.