Developer - BI

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

Joining the Benchmark Senior Living team means putting your passion to work. Our associates feel a sense of belonging with the care that they provide, empowered by the open and reliable team that surrounds them. Our diverse and skilled workforce takes immense pride in a shared commitment: a devotion to providing caring and dedicated service. In our supportive environment, associates can learn and grow. With professional and personal training programs, as well as education for career advancement, we empower associates to explore their interests, feed their passion, and pursue growth opportunities. We invite you to connect with your calling, find purpose in your career, and gain lifelong relationships through the power of human connection by transforming the lives of seniors!

Job Responsibilities

• Experience working with SQL Server Integration Services (SSIS).
• Experienced creating SQL statements, triggers, stored procedures, and data extraction routines to import/export data from the repositories.
• Demonstrates expertise in Query Optimization and Tuning
• Experience running and supporting large scale database environments (1+ TB size) under high transaction volumes.
• Experience in integration projects involving off-site/on-site environments and database administration in 24x7x365 high traffic internet applications environment.
• Knowledge of database maintenance activities including backups, indexing, integrity, and consistency checking.
• Knowledge in administration of SQL Server database environments (optimization/tuning/backup/recovery), including SQL Server Integration Services, clustering, partitioning, log shipping, replication, and other advanced SQL Server implementations.
• Experience in database development in virtualized environments a plus
• Strong analytical skills & ability to create and maintain a database environment to support increasingly complex business requirements.
• Demonstrated experience in Microsoft’s Power Suite (Power BI, Power Pivot, Power Query and Power QA) and SQL Server Reporting Services.
• Experience working with SQL Server Analysis Services (cubes).
• Ability to work with minimal supervision.
• Ability to quickly understand advanced business rules (accounting, Human Resources, Legal).
• Thrives in small, rapid development teams and meets deadline requirements. Good oral and written communication skills.
• Able to quickly isolate and resolve production performance problems.
• Strong initiative and problem-solving skills.

Minimum Job Requirements

• BS/BA in Computer Science or equivalent experience
• 2-4 years’ experience. Knowledge of advanced SQL (Stored procedures, triggers, views, indexing, partitioning), MDX, virtual environments, good business acumen, strong customer service and communication skills.
• Ability to multitask and field priorities.