Sr. Business Intelligence (BI) Developer

Salary Range

$76,872.25 - $115,922.77

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 flexible and passionate about enriching people’s 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 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, we coordinate and manage over $800 million annually in federal, state, county, and city funds for programs providing shelter, housing, and services to people experiencing homelessness.

The Senior 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.

Schedule

The Executive Director or designee may change the schedule of positions between hybrid and onsite, as necessary to accomplish LAHSA business.

Essential Job Functions

• 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, respond 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 team’s 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.
  • Ensure 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).
  • 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 to review 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 LAHSA's values.

Knowledge, Skills & Abilities

• Passion for working on creative, technology forward solutions to address homelessness.
• Familiarity with SSBI tools (e.g., Tableau, PowerBI, 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.
• Experience working with homeless service providers or other social service providers 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 table expressions.
• Performance tuning and query optimization knowledge.
• Experience with code testing best practices/methodologies.
• Experience working with version control systems (e.g., Git).
• 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 communication skills.
• Strong analytical and organizational skills.
• Excellent focus and attention to detail.
• Ability to work collaboratively and independently.
• Excellent time management and prioritization skills.
• Open to new ideas and approaches.
• Perform other duties as assigned.

Training & Experience

• 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.
• Master’s degree in Public Policy, Social Work, Business Administration, or related field preferred.
• Proven professional experience and educational background.

Applicants may make a reasonable accommodation request for this job by calling the Human Resources Department at (213) 683-3333; or via email at ; or in person.

We want to support all staff in reaching their personal and professional goals. Working for LAHSA has many benefits. Join our LAHSA team!

LAHSA pays a portion of the premiums for medical for all full-time employees and their dependents. Employees are responsible for the difference in the premiums through automatic bi-monthly payroll deductions.

Medical plans are administered through ADP Workforce. The following are enrollment options:

HMO/PPO: Kaiser Permanente, Aetna

LAHSA pays a portion of the premiums for selected dental benefits for all full-time employees and their dependents. Employees are responsible for the difference in the premiums through automatic bi-monthly payroll deductions.

Dental plans are administered through ADP Workforce. The following are enrollment options:

HMO/PPO: Guardian Dental

LAHSA offers this voluntary comprehensive vision plan to all full-time employees through ADP Workforce. It includes yearly comprehensive exams, lenses, frames, and contact lenses. All premiums are pre-taxed and paid 100% by the employee through automatic bi-monthly payroll deductions.

LAHSA offers this voluntary supplemental insurance to all full-time employees. Plan options include personal accident, personal cancer indemnity, personal short-term disability, and personal life insurance plans. Most premiums are pre-taxed and paid 100% by the employee through automatic bi-monthly payroll deductions.

LAHSA offers employees this voluntary flexible spending account plan through ADP Workforce. Employees may elect to participate in dependent care or health care expense accounts. All premiums are pre-taxed and paid 100% by the employee through automatic bi-monthly payroll deductions.

LAHSA pays 100% of the premium for $50,000 basic life insurance coverage through ADP.

LAHSA offers employees this voluntary group life insurance through Lincoln Financial. Employees may elect to participate in dependent care or health care expense accounts. All premiums are pre-taxed and paid 100% by the employee through automatic bi-monthly payroll deductions.

LAHSA pays 100% of the premium for long term disability coverage through ADP.

LAHSA is considered a government employer for the PSLF Program.

LAHSA provides a 401A pension plan through Lincoln Financial. After 6 months of employment, employees are eligible for contributions of 5% of the employee’s salary with a qualification date of 500 hours or 6 months after the date of hire.

LAHSA provides a 457 Deferred Compensation plan through Lincoln Financial. Employees may elect to defer up to IRS maximum limit per year of their earned salary for income tax purposes.

Executive Director, chiefs, and directors receive five (5) days of admin leave each calendar year in addition to the time-off below.

Vacation is earned according to each month of service commencing with the employee’s initial date of hire.

• Less than five (5) years of employment, eighty (80) hours per year.
• Five (5) to ten (10) years of employment, one hundred twenty (120) hours per year.
• More than ten (10) years of employment, the one hundred twenty (120) hour total shall be supplemented by one (1) workday of paid leave for each twelve (12) months greater than one hundred twenty (120) months of employment. This vacation accrual is capped at twenty (20) workdays per year.

Maximum accrual of vacation leave is 200 hours.

Full-time employees accrue sick leave at a rate of 12 days per year. Maximum accrual of sick leave is 160 hours.

All employees receive the following observed company holidays off:

New Year’s Day
Martin Luther King Jr. Day
President’s Day
Cesar Chavez Day
Memorial Day
Juneteenth Day
Independence Day
Labor Day
Indigenous People’s Day
Veteran’s Day
Thanksgiving Day
Day After Thanksgiving
Christmas Day

In addition to the above holidays, full-time regular employees who have completed their 1-year introductory period are entitled to two (2) “Floating Holidays” during the calendar year.