Data Warehouse Analyst
Share
Job Location:
Pittsfield, MA - USA
Hourly Salary:
$ 28 - 28
Posted on:
09-11-2025
Vacancies:
1 Vacancy
Job Summary
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:
- Bachelors degree in Computer Science Information Systems Data Analytics or a related field. Masters 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.
Required Experience:
IC
Key Skills
- Data Analytics
- Microsoft Access
- SQL
- Power BI
- R
- Data Visualization
- Tableau
- Data Management
- Data Mining
- SAS
- Data Analysis Skills
- Analytics
About Company
Effective January 16th, 2023, all employees, interns, subcontractors, and volunteers are strongly encouraged to have received at least one dose of a COVID -19 Vaccination at the time of hire or placement. If you have been vaccinated, Human Resources will ask you to provide a copy of ... View more
