Developer - BI

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

Job summary

Benchmark Senior Living in Waltham, MA is seeking a BI Developer to join our analytics team. You will assist in back end and front end development of Benchmark’s BI platform and support BI initiatives across departments, delivering reliable data and insights for operations and care decisions.

Ideal candidates will have hands-on experience with SSIS, SQL Server, and the Microsoft Power BI suite, along with strong SQL skills and the ability to work with minimal supervision in a fast-paced,

Qualifications

• BS/BA in Computer Science or equivalent experience.
• 2-4 years’ experience with data platforms and BI tooling.
• Strong SQL skills and data modeling experience.

Responsibilities

• Back end and front-end development of Benchmark’s BI platform.
• Support BI initiatives across departments and ensure data reliability.
• Create and optimize data extraction routines and reports.
• Collaborate with small, rapid development teams to meet deadlines.

Skills

Analytical skills

Communication skills

Self-motivation

Problem-solving

Team collaboration

Education

BS/BA in Computer Science or equivalent experience

Tools

SSIS

SQL Server

MDX

Power BI

Power Pivot

Power Query

Power BI/SSRS/SSAS suite

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!

The BI Developer assists in back end and front-end development of Benchmark’s BI platform and assists in the Business Intelligence initiatives where required.

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.