Data Warehouse Analyst

Join to apply for the Data Warehouse Analyst role at The Brien Center for Mental Health and Substance Abuse Services, Inc.

The Data Warehouse Analyst is 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 (EHR, Billing, HCM) and the general ledger. The analyst maintains data integrity, accuracy, and accessibility while ensuring compliance with organizational standards. Regular reporting (daily, weekly, monthly, annually) is a key function of this position.

• Design and Management:
  • Collaborate with outsourced providers to develop and maintain a scalable, secure, and efficient data warehouse architecture.
  • Establish data governance protocols with CFAO to ensure consistency and accuracy.
• Integration and Development:
  • 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.
• Reporting and Analysis:
  • 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.
• Collaboration and Support:
  • 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.

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field. Master’s degree preferred.
• Minimum of 5 years of experience in data architecture, data analytics, or related roles.
• Proficiency in data analysis, project management, and EHR/technology platform configuration.
• Strong organizational skills with the ability to manage multiple projects simultaneously.

• 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 Tableau, Power BI, or Python.
• Excellent communication and collaboration abilities.
• Certified Data Management Professional (CDMP) or equivalent.
• Proficiency in relevant reporting platforms.

• This is primarily an office‑based role with potential for remote work, at the discretion of the supervisor and based on departmental needs.
• Regular use of computers and other technology is required, with reasonable accommodation available as needed to perform essential functions.