Sr. Report Developer

  • Los Angeles Homeless Services Authority
  • Los Angeles, CA, USA
  • Dec 07, 2021
Full-time Business Intelligence (BI) Data Reporting Data Visualization Data Warehousing Excel Software Development SQL

Job Description

The Los Angeles Homeless Services Authority (LAHSA) seeks motivated professionals who want to use their talents and skills to make a difference. Our 500+ FTE staff are adaptive problem solvers and passionate about enriching people’s 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, we coordinate and manage over $300 million annually in federal, state, county, and city funds for programs providing shelter, housing, and services to people experiencing homelessness.  
 
Under the direction of the Reports Development Manager, the Senior Report Developer* will be responsible for the development, testing, implementation, and maintenance of ad-hoc and recurring reports as well as dashboards that utilize the underlying data stores for internal and external use.
 
Working with cross-functional teams, the Senior Report Developer will participate to thoroughly analyze and clarify report requirements, make recommendations, and educate when necessary to meet business needs.
 
The Senior Report Developer will also be required to assist the Data Analyst and Report Developer team in providing analytical support for report troubleshooting for end-users in the Los Angeles Continuum of Care (LA CoC).

Essential Job Functions

  • Develop or assist in the development, automation, and upgrading of queries, reports, and dashboards for internal and external users. 
  • Responsible for architecting and developing Business Intelligence (BI) solutions with technologies utilized by the agency.
  • Work with Users to develop strategies to utilize data warehouse to improve business processes.
  • Design and plan new data marts and data warehouses.
  • Provide support as required to ensure availability and performance of developed reports and dashboards for internal and external users. 
  • Other duties and special projects as assigned. 

Knowledge, Skills & Abilities

  • Intermediate or Advanced knowledge of T-SQL, SQL Server Data Tools, and SQL Server Management Studio. 
  • Performance tuning experience related to reporting queries. 
  • Intermediate or Advanced knowledge of relational database management systems. 
  • Programming/Scripting experience and knowledge of data/system analysis, software development life cycle. 
  • Knowledge of HMIS preferred, but not required. 
  • Intermediate to advanced skills of Excel, including VBA.  
  • Strong verbal and written communication skills. 
  • Ability to work independently, be proactive, and exercise good judgment. 
  • Flexibility to work with individuals with varying work styles. 
  • Excellent time management and prioritization skills. 
  • Open to new ideas and approaches. 
  • Attention to detail. 
  • Analytical thinker. 

Training & Experience

  • Proven professional experience and educational background.


* Term:  Full-time, Exempt, Temporary ending June 2023.  A continuation of employment contingent upon funding availability.

 

COVID-19 Vaccines  

  • Effective November 1, 2021, LAHSA will require proof of vaccination for all employees. This requirement is in response to the public health emergency and is intended to reduce the spread of COVID-19 among LAHSA employees, our stakeholders and those we serve – it will remain in effect for the duration of the public health emergency.  
  • Employees may apply for an exemption if they cannot be vaccinated due to complicating medical conditions or sincerely held religious beliefs. If the exemption is approved, then the employees will be subject to weekly COVID-19 testing.



Appointments are typically made between the minimum and the midpoint of the range, depending on qualifications.


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

Job ID

DMD10403

Salary

$59,987.20 - $86,831.08 Annually