Columbia Distributing · 2 days ago

Business Intelligence Developer

Kent, WA

Full-time

Onsite

Mid Level

$82K/yr - $107K/yr

2+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

Food and Beverage

Insider Connection @Columbia Distributing

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Provide technical and business expertise and lead discussions and facilitate meetings to elicit requirements and thoroughly understand business needs and issues

Participate in the design and development of enterprise-wide solutions and data repositories

Consult with end users to refine and enhance existing Business Intelligence and Data Analytics solutions

Define and implement overall ELT and ETL architecture including key designs on integration standards such as loading, streaming/near real time/batch, CDC, data validation, parallelization, etc.

Participate in large-scale database migration, and acquisition projects

Develop multi-dimensional models, as well as extract, transformation, and load (ETL) processes to convert operational transactional data into dimensions and fact tables

Schedule and coordinate infrastructure maintenance activities such as hardware and software upgrades and maintenance

Build and maintain positive business relationships with business users, management, and other technical groups across the organization

Proficient in Columbia Distributing's business processes and applications within an area of expertise (e.g. Financials, Operations, Sales)

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQL ServerETLMicrosoft BI StackSSASSSRSPower BIPower AutomatePower QueryPower PivotRDLsSSIST-SQLData ModelingData ArchitectureBusiness IntelligenceMicrosoft Power PlatformsPower AppsAzure Analysis ServicesDataflowPower BI EmbeddedPower BI Rest APIs

Required

Bachelor's degree in Computer Science / Computer Engineering or equivalent experience

Minimum of 2 years' experience with SQL Server database systems including complex warehouse design, experience with designing ETL extracts from various data sources

Minimum of 2 years Microsoft BI Stack (SQL Server, SSAS, SSRS, Power BI, Power Automate, Power Query, Power Pivot, etc.), including development of reports (RDLs, complex stored procedures, subscriptions, ETL packages using SSIS & T-SQL queries)

Preferred

Experience analyzing, recommending tuning steps, and implementing performance enhancements to optimize data model, data architecture, and business intelligence performance

Knowledge and hands-on experience of Power BI and other Microsoft Power Platforms like Power Apps/Power Automate (development and administration)

Experience working with Azure Analysis Services, Dataflow, Power BI Embedded, Power BI Rest APIs