Lead Data Architect

Essential Duties 

1. Collaboratively build, document, and maintain Business Intelligence reports and dashboards with organizational stakeholders. As well as SQL queries, functions, tables, and stored procedures used by the reports and dashboards.
2. Design, implement, maintain on-premise and cloud databases servers to meet organizational needs while ensuring data and user security, integrity, and performance.
   1. Monitoring, updating software and troubleshooting
   2. Developing and implementing database backup/recovery plans as part of the Agency Disaster Recovery plan
   3. Maintaining documentation
3. Manage data replication from vendors. Create, modify and automate data flow scripts to retrieve data from vendors and copy into a local database or cloud-based database for reporting. Update local and cloud databases with internal financial and clinical data. Maintain vendor relationships and contact them if needed for support.
4. Mentor Data Architect staff, monitoring the performance of assignments and projects. Give input for Data Architect staff performance reviews.
5. Maintain user security for access control regarding Electronic Health Record system, data reporting and database access
6. Support all levels of the organization with the usage of our Electronic Health Record system and HR management systems, including fulfilling help desk tickets pertaining to all data systems, dashboards and reports.
7. Lead and/or participate in projects to improve processes involved in data flow, data capture, and reporting.
8. Provide custom user reports by querying external databases and supporting processes and procedures from other organizational departments.
9. Maintain knowledge in critical organization business rules, workflow and procedures, including:
   1. Mental health billing processes
   2. Clinical documentation, procedures and processes
   3. Usage and setup of Electronic Health Record and HR management systems
   4. Financial and HR operations and structures
10. Explore, and implement new work processes and improvements including software, hardware, workflow, etc.

Qualifications 

• Bachelor's degree in Computer Science, Information Technology or a similar technical discipline
• Driver's License and insurance.
• Minimum Experience: 5 years of experience supporting data systems and report writing
• 3 years or more of data or information systems architecture experience
• Experience developing dashboards and automation in SQL data flow.
• Strong understanding of the principles and practices of relational data structures
• Excellent communication skills including the ability to understand user requirements and to facilitate a discussion of data flow processes
• Experience with working with people across different departments and corporate levels
• Project management experience and team leadership experience
• Understanding and/or experience with Private Healthcare Information (PHI) and HIPAA regulations is preferred.
• Knowledge of non-profit business processes and LACDMH clinical/medical billing processes is preferred.

Compensation Range: $75,888/yr - $107,880/yr

Work culture matters at 5A! We offer a comprehensive benefits package with a medical coverage option as low as $5 with free dental HMO, vision, life insurance, AD&D and disability insurance. We offer a 401k with an annual match up to 3%, annual performance reviews with up to 4% merit (6% for direct service providers), plus annual retention stipends. We offer team building retreats, wellness incentive, 12 paid holidays and flexible work schedules, including remote options for identified positions!