Sr. Business Intelligence Developer (BID)

The Los Angeles Homeless Services Authority (LAHSA) seeks motivated professionals who want to use their talents and skills to make a difference. Our staff are adaptive problem solvers and passionate about enriching peoples lives. If you are mission-driven dedicated to superior service and support and 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 impact 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.

The Sr. Business Intelligence (BI) Developer is responsible for leading the development testing implementation and maintenance of organizational data sets and reports. The Senior BI Developer will work closely across departments to develop dashboards that meet the needs of the various internal and external stakeholders.

Working with cross-functional teams the Senior BI Developer will take the lead in analyzing clarifying and documenting report requirements making recommendations identifying relevant data points and educating when necessary to meet business needs.

The ideal candidate will have a passion for driving creative technology-based solutions to address homelessness. They will be a creative thinker who is passionate not only about data and dashboards but also about the homeless service landscape or other social service landscape and is eager to design products to move the industry forward to help house more individuals.

The functions listed below are intended to describe the general nature and level of work being performed and are not to be interpreted as an exhaustive list of responsibilities.

• 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 of 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.

• 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
• Ensure standardization of datasets and data metrics used across queries reports dashboards and data feeds.

• Analyze business requirements and functional specifications for technical implementation (SSRS reports dashboards data services).
• Be a primary knowledge holder and resource for how homeless service data is collected stored and analyzed.
• Support developers and other members of the Data Infrastructure team with complex projects.
• Compile and update documentation for all datasets dashboards processes and any other work assigned.
• Think critically about reviewing business operations identify opportunities for improvement and collaborate with internal departments and stakeholders to complete requests.
• Collaborate with senior staff and team members in assessing and improving business operations and processes.
• Communicate with and anticipate needs of stakeholders on a technical and programmatic level.
• 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 Power BI PowerPivot) preferably Tableau
• Intermediate or advanced knowledge of T-SQL SSRS SSIS SQL Server Data Tools and SQL Server Management Studio.
• Intermediate or Advanced knowledge of relational database management systems (RDBMS)
• Programming/Scripting experience and knowledge of data/system analysis software development life cycle (SDLC).
• Intermediate to advanced Excel skills.
• Knowledge of SSAS HMIS CHAMP Looker preferred
• Ability to develop maintain and tune complex stored procedures queries views user-defined functions cursors and common table expressions.
• Performance tuning and query optimization knowledge
• Knowledge of data-modeling data warehousing concepts and methodologies
• Knowledge of SQL Server database administration
• Ability to see projects through from start to finish.
• Ability to troubleshoot and problem solve
• Familiarity with Agile development preferred
• Strong critical thinking skills
• Strong verbal and written communications kills
• Strong analytical and organizational skills
• Excellent focus and attention to details
• Ability to work collaboratively and independently
• Excellent time management and prioritization skills
• Open to new ideas and approaches

• 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