Data Architect / BI Developer - Information Services

Bay Cove Cape Cod; Boston (MA); On-site; USD 120,000 - 160,000; Full time

Job summary

Bay Cove Human Services in Boston, MA is seeking a Data Architect / BI Developer to design, develop, implement, and maintain BI systems and reporting tools. The role collaborates with leadership and subject matter experts to deliver scalable, secure data solutions and enterprise BI infrastructure.

The position focuses on data architecture, data warehousing, and BI tooling on the Microsoft platform, with responsibilities including ETL, dashboards, and end-user training. Exempt role.

Qualifications

• Experience with BI tools on the Microsoft platform.
• Experience with enterprise data architecture, design and implementation.
• Experience with web services and API-based development.
• Ability to quickly learn and adapt to new concepts.
• Innovative thinker with proactive mindset.
• Strong teamwork and collaboration in dynamic environments.

Responsibilities

• Design and maintain the organization’s enterprise data infrastructure and architecture.
• Collaborate to standardize data collection and aggregation strategy, data warehouse, and transactional data repository approach.
• Develop database solutions for SQL Server, including tables, stored procedures, functions, triggers, and indexes.
• Assist with the implementation and use of new BI reporting/dashboard tools.
• Design and build custom data visualization solutions.
• Develop and implement automated data integration processes for interoperability.
• Lead end-user training and create training materials.
• Provide ongoing support for existing systems and applications.
• Stay current with data management, data warehousing, and BI best practices.

Skills

BI tools

Data architecture

SQL Server

API development

Data visualization

Tools

SQL Server

Job description

Boston, MA, USA

Job Description

Posted Wednesday, August 12, 2026 at 4:00 AM

Bay Cove Human Services’ mission is to partner with people to overcome challenges and realize personal potential. Bay Cove pursues this mission by providing individualized and compassionate services to people facing the challenges associated with developmental disabilities, mental illness, substance use disorders, and homelessness at more than 175 program sites throughout Greater Boston and Southeast Massachusetts.

Job Summary:

The Data Architect / BI Developer is responsible for the design, development, implementation, and maintenance of the organization’s Business Intelligence systems and reporting tools. This position will also assist with the design and implementation of enterprise data & business intelligence infrastructure & architecture, while working collaboratively with leadership, end-users, & subject matter experts to create advanced data, integration, & business intelligence solutions that are accessible, scalable, and secure.

This is an exempt positon.

Essential Functions of the Position:

Assists with the design, implementation, & support of the organization’s enterprise data infrastructure and architecture

Collaborate across the organization to determine & standardize a relevant data collection and aggregation strategy, data warehouse, and transactional data repository approach

Develops database solutions for SQL Server, including creating tables, stored procedures, custom user-defined functions, triggers, and indexes

Assists with the implementation and use of new BI reporting/dashboard tools.

Design & build custom data visualization solutions

Develop & implement automated integration processes to support interoperability between internal and external systems

Manages the design and delivery of end-user training, best practices and training materials

On-going support of existing systems & applications

Maintain knowledge of curret research, trends, technology, and best practices related to data management, data warehousing, & business intelligence

Ability to analyze user requirements, make recommendations, and implement solutions

Conduct research and make recommendations on BI & data management products, services, and standards in support of procurement and development efforts.

Assist with special projects (as necessary)

Requirements for the Position:

Experience with BI tools, enterprise data architecture, design and implementation on the Microsoft platform

Experience with web services and API based development

Quickly learn and adapt to new business and technical concepts.

Innovative thinker who is positive, proactive and readily embraces change.

Strong team focus with a genuine interest and ability to work collaboratively in a dynamic team environment and interact at all levels in the organization

Excellent organizational and time management skills and attention to detail.

Utilizes a flexible and responsible work style that meets evolving needs of the agency

Works with integrity and respects the dignity and value of all individuals

Exhibits mission through job knowledge and pride in work role

Works in a collaborative, compassionate manner with stakeholder/ partners

Bay Cove Human Services is an Equal Opportunity Employer and does not discriminate on the basis of race, ethnicity, religion, sex, gender identity or expression, national origin, sexual orientation, disability, age, veteran status, or any other groups as protected by Massachusetts or federal law. All qualified candidates, regardless of background, are encouraged to apply.

Bay Cove Human Services does not offer visa sponsorships at this time and will require candidates to be authorized to work in the United States.