Senior SQL Server SSIS/SSAS Architect

SmartRecruiters, Inc.

Redmond (WA)

On-site

USD 120,000 - 180,000

Full time

3 days ago

Be an early applicant

Application generator

An application made for this job — a tailored resume and cover letter that speak straight to the posting.

Get past ATS filters

Job summary

SmartRecruiters, Inc. in Redmond, WA seeks an experienced SQL Server Developer to lead performance optimization and OLTP data solutions. You will design and optimize T-SQL objects, implement MDX/DAX for OLAP cubes, and contribute to security and governance of databases.

Must have a Master's degree and 8+ years of experience in CS/Engineering related field; strong collaboration with cross-functional teams. The role requires handling terabyte-scale datasets, implementing complex partitioning, and

Qualifications

Master’s degree in CS, Math, Engineering or related field with 8+ years of experience.
Expert in SQL Server performance optimization and stored procedures.
Experience with T-SQL debugging and SQL security management.
Experience with MDX/DAX and star/snowflake schemas.
Experience with large OLTP databases (TB scale).
Familiarity with SSAS/SSIS for cubes and data analysis.

Responsibilities

Build and maintain SQL Server ETL/OLAP solutions for business needs.
Perform deep query tuning, indexing, and plan analysis to optimize performance.
Develop and maintain OLAP cubes using SSAS and related tooling.
Collaborate with developers, BI teams, and DBAs to deliver scalable data platforms.