Lead Data Architect

• Collaboratively build, document, and maintain Business Intelligence reports and dashboards with organizational stakeholders, including SQL queries, functions, tables, and stored procedures.
• Design, implement, and maintain on-premise and cloud database servers to meet organizational needs while ensuring data and user security, integrity, and performance.
• Monitor, update software, and troubleshoot issues.
• Develop and implement database backup/recovery plans as part of the Agency Disaster Recovery plan.
• Maintain documentation.
• Manage data replication from vendors; create, modify, and automate data flow scripts to retrieve vendor data and update local or cloud-based databases with internal financial and clinical information; maintain vendor relationships for support.
• Mentor Data Architect staff, monitor assignment performance, and provide input for performance reviews.
• Maintain user security for access control regarding Electronic Health Record systems, data reporting, and database access.
• Support all levels of the organization with the usage of Electronic Health Record and HR management systems, including help desk ticket resolution for data systems, dashboards, and reports.
• Lead and participate in projects to improve data flow, capture, and reporting processes.
• Provide custom user reports by querying external databases and supporting cross-departmental processes.
• Maintain knowledge of critical organizational business rules, workflow, and procedures, including mental health billing processes, clinical documentation, Electronic Health Record and HR management system usage, and financial/HR operations.
• Explore and implement new work processes and improvements including software, hardware, and workflow enhancements.

• Bachelor's degree in Computer Science, Information Technology, or a similar technical discipline.
• Driver's License and insurance.
• Minimum 5 years of experience supporting data systems and report writing.
• 3+ years of data or information systems architecture experience.
• Experience developing dashboards and automating SQL data flows.
• Strong understanding of the principles and practices of relational data structures.
• Excellent communication skills with an ability to understand user requirements and facilitate data flow discussions.
• Experience collaborating with people across different departments and corporate levels.
• Project management and team leadership experience.

• Understanding and/or experience with Private Healthcare Information (PHI) and HIPAA regulations.
• Knowledge of non-profit business processes and LACDMH clinical/medical billing processes.

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

• Comprehensive benefits package including a medical coverage option as low as $5 with free dental HMO, vision, life insurance, AD&D, and disability insurance.
• 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.
• Team building retreats, wellness incentives, 12 paid holidays, and flexible work schedules including remote options for identified positions.