Business Intelligence Developer (BID)

TheLos Angeles Homeless Services Authority (LAHSA)seeks motivated professionals who want to use their talents and skills to make a difference. Our 750 FTE staff are adaptive problem solvers and passionate about enriching peoples lives. If you are mission-driven dedicated to superior service and support can diligently work independently and in a collaborative environment join our team. LAHSA is leading the fight to end homelessness in LA County. Here not only would your work have a real impact on the community but we also offer a comprehensive and competitive benefits package.

Created in 1993 LAHSA is a joint powers authority of the city and county of Los Angeles. As the lead agency in the HUD-funded Los Angeles Continuum of Care (CoC) we coordinate and manage federal state county and city funds for programs providing shelter housing and services to people experiencing homelessness.

• Dashboard Creation
  • Build useful well-designed dashboards in Tableau liaising with programs systems government affairs and finance teams as necessary to scope and collect business requirements.
  • Update dashboards be responsive to change requests and ensure dashboards are always operating with full functionality.
  • Explore and keep abreast with emerging BI technologies and best practices that support or enhance the teams processes tools and capabilities.
  • Participate in meetings with cross-functional teams to gather required reporting and dashboard requirements.
• Dataset Creation maintenance and documentation
  • Curate datasets and ensure there are documented procedures and guidelines for data access.
  • Build maintain and update datasets dependent on the needs of internal and external stakeholders
  • Support standardization of datasets and data metrics used across queries reports dashboards and data feeds.
• Serve as an expert in Homeless service data
  • Analyze business requirements and functional specifications for technical implementation(SSRS reports dashboards data services etc.).
  • Be a resource for how homeless service data is collected stored and analyzed.
  • Compile and update documentation for all datasets dashboards processes and any other work assigned.
• Think critically to review business operations identify opportunities for improvement and collaborate with internal departments and stakeholders to complete requests.
• Provide technical assistance and cross-training to other team members.
• Assist in assembling complex ideas issues and observations into useful explanations and clear directions for the team.
• Complete other duties as needed to help drive to our vision fulfill our mission and abide by LAHSAs values.

• Passion for working on creative technology forward solutions to address homelessness
• Familiarity with SSBI tools (e.g. Tableau PowerBI PowerPivot) preferably Tableau
• Intermediate of T-SQL SSRS SSIS SQL Server Data Tools andSQL Server ManagementStudio.
• Intermediate to advanced Excel skills
• Knowledge of SSAS HMIS CHAMP Looker preferred
• Experience working with homeless service provider or other social service provider preferred
• Experience with communicating directly with internal and external stakeholders
• Ability to develop maintain and tune complex stored procedures queries views user-defined functions cursors and common tableexpressions.
• Performance tuning and query optimizationknowledge
• Knowledge of data-modeling data warehousing concepts andmethodologies
• Ability to see projects through from start to finish
• Ability to troubleshoot and problem solve
• Familiarity with Agiledevelopment preferred
• Strong critical thinking skills
• Strong verbal and written communicationskills
• Strong analytical and organizationalskills
• Excellent focus and attention todetails
• Ability to work collaboratively andindependently
• Excellent time management and prioritizationskills
• Open to new ideas andapproaches

• BA/BS in data science business administration or related field is strongly preferred; however an equivalent combination of applicable training and experience will be considered.
• Masters degree in Public Policy Social Work Business Administration or related field preferred.

Schedule:The Chief Executive Officer or designee may change the schedule of positions between hybrid and onsite as necessary to accomplish LAHSAs business needs.

Additional Information:LAHSA has adopted a hybrid telework policy requiring employees to work onsite at our Los Angeles office a minimum of two (2) days per week. Applicants must be able to meet this onsite requirement with or without a reasonable accommodation. LAHSA is committed to providing equal employment opportunities and reasonable accommodations to qualified individuals with disabilities. If you require an accommodation please contact Human Resources at to initiate the interactive process.

Residency Requirement:This position requires the employee to reside within the State of California. Proof of residency may be requested as part of the onboarding process to ensure compliance with organizational and operational requirements.

Applicants may make a reasonable accommodation request for this job by calling the Human Resources Department at ; or via email at

We are an Equal Opportunity / E-Verify Employer