Share Email Opening

Senior BI Data Analyst 

About the Organization Since 1986 LERETA's nationwide team of real estate tax and flood professionals has provided the mortgage and insurance industries the fastest, most accurate and complete access to property tax and flood information across the nation. LERETA is an industry leader with an enormous focus on technology, innovation, and commitment to service excellence.  
Open Date 10/25/2023  
Position Senior BI Data Analyst  
Full-Time/Part-Time Full-Time  
Exempt/Non-Exempt Exempt  
Category Information Technology  
Location Pomona  
Req Number INF-23-00028  

The Business Intelligence Team at LERETA is responsible for the development, maintenance, integration, data governance and data reporting of LERETA’s business systems via the EDW (Enterprise Data Warehouse).

As a Senior BI Data Analyst, the position will be expected to help drive the Data Governance Plan and build business processes for the MDM, EDW and across all source systems.


Management of the Data Governance Plan

  • Performs a lead role in managing the Data Governance Plan.
  • Engages the business, encourage learning and adoption of Data Quality practices.
  • Manages the MDM business rules for data migration, automated updates and manual updates.
  • Manages the MDM exception process and work queues.
  • Participates in Data Governance committee meetings.


Support and Maintenance BI-EDW-MDM Intellectual Property

  • Writes and maintains requirements and mappings.
  • Writes and maintains test plans.
  • Maintains defects and bug resolution in TFS.
  • Maintains physical and logical data models.
  • Maintains Data Dictionary.
  • Maintains entities list and meta-data

Establishment and maintenance of the SQL MDS and DQS services in support of company master data

  • Grows and maintains business knowledge for SQL-DQS layer.
  • Identifies and maintains sources for MDM and associated data mappings.

Adherence to established policies and procedures including request process, testing process, release process and coding standards

  • Adheres to company data policies.
  • Adheres to industry best practices.
  • Adheres to naming conventions and structures.

Identification and implementation of process improvements

  • Works with the BI team to implement efficient practices.

Cooperation with subject matter experts and analysts

  • Gathers requirements from SMEs and analysts.
  • Generates QA testing plans per requirements.

This position will perform other duties as assigned based on the needs of the department.

SALARY RANGE : $82,349 - $109,798

Position Requirements
  • At least 5 + years of experience:
  • Expertise in SQL server environments including writing SQL queries.
  • Relevant Business Analyst, Systems Analyst or Data Analyst experience.
  • Minimum 3 years of Data Mining experience.
  • SQL Server 2012, SQL Server Management Studio.
  • Understanding of dimensional modeling and OLAP concepts.
  • Understanding of data warehouse and data mart architecture including Kimball methodology.
  • High school diploma or equivalent.
EOE Statement We are an Equal Employment/ Affirmative Action Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, national origin, disability status, protected veteran status or any other characteristic protected by law.  

This position is currently not accepting applications.

To search for an open position, please go to


Other Jobs Within Same Category
Product Owner I in Pomona, CA
Posted on: 1/17/2024
[Apply Now]

IT Business Analyst I in USA, Remote
Posted on: 1/17/2024
[Apply Now]

Other Jobs Within 60 Miles
Product Owner I in Pomona, CA
Posted on: 1/17/2024
[Apply Now]

Client Success Manager in Pomona, CA
Posted on: 1/26/2024
[Apply Now]


Click here for technical assistance.