Data ArchitectAnalyst

Weekdays 1st Shift! No Nights No Weekends No Holidays!

Job Summary

The Data Architect/Analyst is responsible for designing managing and optimizing a robust data warehouse to support strategic decisionmaking across the organization. This role ensures seamless integration and reporting across existing and new subledger systems (EHR Billing HCM) and the general ledger (Accounting System). The position plays a critical role in maintaining data integrity accuracy and accessibility while adhering to organizational objectives and compliance standards. The position is also tasked with developing and delivering regular reporting (daily weekly monthly and annual) to meet organizational needs and compliance standards.

Primarily officebased with the possibility of occasional remote work opportunities.

Design and Management

• Create and maintain a scalable secure and efficient data warehouse architecture.
• Establish data governance protocols to ensure consistency and accuracy.

Integration and Development

• Develop and manage integrations between the data warehouse and subledger systems (EHR Billing HCM).
• Collaborate with IT and finance teams to align data structures with the general ledger system.
• Optimize ETL (Extract Transform Load) processes for data synchronization and performance.

Reporting and Analysis

• Generate regular and adhoc reports to support strategic planning operational planning and compliance.
• Generate adhoc reports and dashboards as needed.
• Develop dashboards and visualization tools for datadriven decisionmaking.
• Create visualization tools using Excel Tableau or Power BI to support datadriven decisionmaking.
• Conduct data audits to identify discrepancies and ensure alignment with financial and administrative goals.

Collaboration and Support

• Partner with crossfunctional teams to understand data requirements and ensure system compatibility.
• Provide training and support to endusers on data access and reporting tools.
• Stay updated on emerging technologies and recommend system improvements.

Other Duties

• Performs additional duties as directed by management.
• This position does not have direct supervisory responsibilities but collaborates with team members across departments to guide datarelated projects and processes.
• This job description is intended to provide a general overview of the position and does not encompass all duties or responsibilities that may be required.
• Minimal travel for conferences or training may be required.

Qualifications Experience and Education

Education: Bachelors degree in Computer Science Information Systems Data Analytics or other related field. Masters degree preferred.

Experience: Minimum of 5 years of experience in data architecture data analytics or related roles and equivalent experience.

Required Knowledge & Skills:

• Proficiency in data modeling database design and SQL Structured Query Language).
• Strong proficiency in reporting and data visualization tools such as Power BI Tableau or similar platforms with the ability to create insightful dashboards and reports that drive datadriven decisionmaking
• Expertise in Excel for data manipulation and analysis.
• Experience with ETL (Extract Transform Load) tools and processes.
• Knowledge of EHR (Electronic Health Record) HCM (Human Capital Management) and accounting systems integrations.
• Experience with AI Technology including building and testing AI prompts and working with HIPAAcompliant major models like GPT (Generative Pretraining Transformer) and platforms like CoPilotpreferred.
• Experience with NLP (Natural Language Processing)preferred.
• Strong analytical problemsolving and project management skills.
• Excellent communication and collaboration abilities.

Abilities:

• Ability to interact effectively with a diverse population and work collaboratively within the organization.
• Ability to manage complex projects prioritize delegate and meet deadlines.
• Ability to represent the organization professionally in community and stakeholder interactions.