SQL Developer (SSIS & SSAS)

Job Title:

SQL Developer (SSIS & SSAS)

Duration:

6+ Months Contract (possibility for extension)

Location :

Bellevue, WA 98004 (Hybrid schedule: 3 days onsite & 2 days Remote per week)

Relocation:

Open to candidates willing to relocate to

Bellevue, WA Job Description:

Role Overview:

We are seeking a Senior SQL Developer with deep expertise in SSAS to support a major Utility sector project. This role focuses on designing high-performance business intelligence solutions and managing complex data models. The ideal candidate must be a subject matter expert in Analysis Services (SSAS).

Key Responsibilities:

SSAS Modeling:

Design, develop, and implement complex Multidimensional and Tabular models using

SSAS. ETL

Engineering:

Build and maintain robust SSIS packages for seamless data integration from multiple sources.

Performance Optimization:

Tune and optimize SQL queries, stored procedures, and SSAS cubes to ensure scalability and speed.

BI Solution Design:

Translate business requirements into scalable technical specifications within the Microsoft BI stack.

Data Governance:

Ensure data accuracy, security, and consistency across all analytical platforms.

Technical Requirements:

Minimum 8 12 years of core SQL Development experience.

Mandatory Skill:

Exceptional hands-on experience with SSAS (Tabular and Multidimensional). Strong proficiency in T-SQL and SSIS. Experience in designing cubes, DAX, and MDX queries. Strong communication skills for interacting with cross-functional teams.

Work Policy:

Candidates must be willing to work 3 days onsite per week in Bellevue, WA. Non-local candidates must be ready to relocate to the Bellevue/Greater Seattle area.