Data Warehouse Analyst

The Brien Center for Mental Health and S • Pittsfield, MA • 7h ago

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. For additional information and to apply for open positions at The Brien Center, please click here.{target="blank" rel="noopener noreferrer"}

Similar Jobs

Data Warehouse Analyst

The Brien Center for Mental Health and S • Pittsfield, MA • 7h ago

IT & Engineering

7h ago

Go to Apply

AC&L CARE Phone Specialist - Bethlehem, PA or Pittsfield, MA

Guardian Life • Pittsfield, MA • 3w ago

IT & Engineering

Job Descriptio n- AC&L CARE Phone Specialist Please note: This is a hybrid position, to be located in either our Bethlehem, PA or Pittsfield, MA office. It requires the employee to be in the office three days per wee...

3w ago

Go to Apply

Electrical Maintenance Technician

TEC Staffing Services • Adams, MA • 45min ago

Hospital & Medical

Electrical Maintenance Technician Job in Adams, MA Massachusetts Journeyman Electrical License Required (NH license qualifies for reciprocity) Compensation: \$35.08/hr - \$47.36/hr depending on experience Schedule: Mon-F...

45min ago

Go to Apply

Entry Level Caregiver - Part Time

Guardian Angel Senior Services • Pittsfield, MA • 6h ago

Hospital & Medical

Our Mission: Is to provide home care service with love; to enhance the quality of living through our attentive yet subtle style of care; to maintain their dignity and their independence while serving their needs with hon...

6h ago

Go to Apply

Direct Care Support - Entry Level

The Brien Center for Mental Health and S • Pittsfield, MA • 6h ago

2nd and 3rd Shift Differential!!! Will Train! Entry Level! No experience needed! Residential and outreach provides assistance in the population living with a chronic behavioral health disorder with daily living activitie...

6h ago

Go to Apply

Entry Level Caregiver

Guardian Angel Senior Services • Pittsfield, MA • 6h ago

Hospital & Medical

6h ago

Go to Apply

Injection Mold Tech

MOLARI Employment & Healthcare Services • Pittsfield, MA • 7h ago

Hospital & Medical

Well established Injected Mold company located in Pittsfield seeks an Injection Mold Tech for 1st shift. This position will be a general utility worker, trimming injected mold plastic finished products (industrial and el...

7h ago

Go to Apply

Office Manager - Part-Time

TEC Staffing Services • Pittsfield, MA • 8h ago

Management & Administrative

Part Time Office Manager Job in Pittsfield, MA Location: Pittsfield, MA Job Type: Part-Time Pay: \$25/hr Hours/Schedule: Mon & Tues: 8a-4:30p, Wed & Thurs: 8a-12p Job Summary: TEC is seeking a reliable and organi...

8h ago

Go to Apply

Order Processor

MOLARI Employment & Healthcare Services • Lee, MA • 8h ago

Order Processor (Temporary - 5 Months) Lee, MA \$20 - \$22/hour (DOE) Full-Time | Leave of Absence Coverage- Starts April 6th MOLARI Employment & HealthCare Services is seeking a detail-oriented Order Processor for a...

8h ago

Go to Apply

Staff Accountant

Kripalu Center for Yoga and Health • Stockbridge, MA • 9h ago

Finance, Accounting & Banking

JOB SUMMARY: The Staff Accountant provides essential onsite support to the Finance & Accounting team by assisting with daily accounting operations, maintaining accurate financial records, and supporting month-end and...

9h ago

Go to Apply

Subscribe to get new jobs sent directly to you
(no charge, cancel anytime)

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.