What are the responsibilities and job description for the SQL Developer (SSIS & SSAS) position at VeridianTech?
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.