Data Warehouse Analyst jobs in United States
cer-icon
Apply on Employer Site
company-logo

The Brien Center for Mental Health and Substance Abuse Services, Inc. ยท 2 months ago

Data Warehouse Analyst

positionPittsfield, MA
timeFull-time
remoteOnsite
senioritySenior Level
date5+ years exp

The Brien Center for Mental Health and Substance Abuse Services, Inc. is seeking a Data Warehouse Analyst responsible for the design, oversight, and optimization of a comprehensive outsourced data warehouse. This role supports strategic decision-making by ensuring seamless integration across subledger systems and maintains data integrity while ensuring compliance with organizational standards.

Addiction TreatmentAssociationChildrenHealth CareNon Profit

Responsibilities

Collaborate with the outsourced providers to develop and maintain data warehouse architecture that is scalable, secure, and efficient
Establish data governance protocols with CFAO to ensure consistency and accuracy
Develop and manage integrations between the data warehouse and subledger systems
Align data structures with the general ledger system in coordination with IT and finance teams
Optimize ETL (Extract, Transform, Load) processes for performance and synchronization
Create dashboards and visualization tools using Excel, Tableau, Power BI, or similar platforms
Generate regular and ad-hoc reports to support strategic planning, operations, and compliance
Conduct data audits to identify discrepancies and ensure alignment with financial goals
Partner with cross-functional teams to understand data requirements and ensure system compatibility
Provide training and support to end-users on data access and reporting tools
Stay current with emerging technologies and recommend system improvements

Qualification

SQLData modelingETL toolsData analysisExcelTableauPower BICertified Data Management ProfessionalProject managementCommunication skillsCollaboration skillsOrganizational skills

Required

Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field
Minimum of 5 years of experience in data architecture, data analytics, or related roles and equivalent experience
Proficiency in SQL, data modeling, and database design
Strong analytical, problem-solving, and project management skills
Experience with ETL tools and EHR, HCM, and accounting system integrations
Expertise in Excel and reporting platforms like Python, Tableau, or Power BI
Excellent communication and collaboration abilities
Strong organizational skills with the ability to manage multiple projects
Certified Data Management Professional (CDMP) or equivalent

Preferred

Master's degree
Proficiency in data analysis, project management, and EHR/technology platform configuration

Company

The Brien Center for Mental Health and Substance Abuse Services, Inc.

twittertwitter
company-logo
A not for profit social service agency serving children and adults throughout Berkshire County, Massachusetts.
dateFounded in 1916
location
Pittsfield, Massachusetts, USA
people-size201-500 employees
web-link
https://www.briencenter.org

Funding

Current Stage
Growth Stage

Leadership Team

leader-logo
Randy Cartwright
Chief Financial Officer
linkedin
leader-logo
Richard Wilson
Senior Vice President of Finance and Administration/CFO
linkedin
Company data provided by crunchbase