SQL Server DBA & BI/Data Integration Specialist

Benchmark Senior Living; Waltham (MA); On-site; USD 90,000 - 120,000; Full time

Job summary

Benchmark Senior Living seeks a data-focused professional to join our IT team in Massachusetts. You will manage SQL Server environments, build SSIS pipelines, and develop data extraction routines to support reporting and analytics.

The role emphasizes query optimization, performance tuning, and collaboration on cross-site projects in a high-transaction setting. Strong communication and multitasking are essential.

Qualifications

• 2-4 years’ experience with advanced SQL (stored procedures, triggers, views, indexing, partitioning).
• Experience with MDX, virtual environments, and strong customer service/communication skills.
• Ability to multitask and manage priorities in a fast-paced setting.

Responsibilities

• Experience working with SQL Server Integration Services (SSIS).
• Create SQL statements, triggers, stored procedures, and data extraction routines to import/export data.
• Demonstrates expertise in Query Optimization and Tuning.
• Support large scale database environments (1+ TB) under high transaction volumes.
• Participate in integration projects across off-site/on-site environments and 24x7x365 systems.
• Knowledge of backups, indexing, integrity, and consistency checking.
• Administer SQL Server environments, including clustering, replication, log shipping, and recovery.
• Experience in virtualized database development a plus.
• Strong analytical skills to support complex business requirements.
• Experience with Power Suite (Power BI, etc.) and SSRS; SSAS cubes.
• Independence and quick problem-solving to isolate production performance issues.

Skills

SQL Server

SSIS

Stored procedures

Triggers

Query optimization

Power BI

Data extraction

MDX

SSRS

SSAS

Performance tuning

Education

BS/BA in Computer Science or equivalent experience

Tools

Power BI

SQL Server

MDX

Job description

Benchmark Senior Living seeks a data-focused professional to join our IT team in Massachusetts. You will manage SQL Server environments, build SSIS pipelines, and develop data extraction routines to support reporting and analytics.

The role emphasizes query optimization, performance tuning, and collaboration on cross-site projects in a high-transaction setting. Strong communication and multitasking are essential.