Data Warehouse Analyst Job at Brien Center for Mental Health, Pittsfield, MA

OUo2RTRTcGF2UGcrR3V2NDZqa1ZDYU5RSnc9PQ==
  • Brien Center for Mental Health
  • Pittsfield, MA

Job Description

Weekdays, 1st Shift

Job Summary

The Data Warehouse Data 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.

Essential Job Functions

  • Design and Management:
    • 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.
  • 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.

Qualifications, Experience, and Education:

  • 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 and equivalent experience.
  • Preferred: Proficiency in data analysis, project management, and EHR/technology platform configuration.
  • Strong organizational skills with the ability to manage multiple projects simultaneously.

Skills and Knowledge:

  • 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.
  • Proficiency in relevant tools like Python, Tableau, Power BI, or equivalent reporting platforms.

Working Environment and Physical Requirements:

  • This is primarily an office-based role with the 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.

Job Tags

Work at office, Day shift, Weekday work,

Similar Jobs

Mid-Plains Community College

Nurse Educator Job at Mid-Plains Community College

 ...Responsible for teaching nursing theory and clinical in the LPN and ADN programs at North Platte Community College. MPCC is looking...  ...have five years of nursing experience. Current experience with educational technologies including online instruction and Distance... 

Elite Contracting Group

Concrete Truck Driver - CDL A Job at Elite Contracting Group

 ...Company Overview Heartland Concrete is a specialty concrete producer supplying DOT and...  ...immediate opening for an experienced CDL-A driver willing to train on the operation of our...  ...Duties Drive both CDL Class A and Class B trucks safely using ELD software Understands... 

Top Level Promotions

Office Administration Assistant - Work from Home Job at Top Level Promotions

 ...Work from Home Data Entry & Office Administration Flexible Online Role About the Job...  ...computer and typing skills Independent time management Effective written communication...  ... work from home Flexible hours, part-time or full-time Paid online training... 

Aramark

1st shift Journeyman Plumber - General Motors Technical Center - GM Warren Annex C - Skilled Trades Job at Aramark

 ...safety and housekeeping standards At Aramark, developing new skills and doing what it takes to get the job done make a positive impact...  ...~ Ability to work independently or as part of a skilled trades team ~ High school diploma or equivalent ~ Ability to lift up... 

Sephora

Store Manager Job at Sephora

Sephora is seeking a Store Manager in Whitehall, USA to lead store operations, inspire a high-performing team, and enhance client experiences. This role requires previous management experience in a high-volume retail environment, strong leadership skills, and a client-centric...