LERETA, LLC

Senior Data Engineer

LERETA, LLC  •  $114k - $140k/yr  •  Pomona, CA (Onsite)  •  1 month ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

The Senior Data Engineer leads the design, modernization, and operational support of the enterprise data platform. This role is responsible for architecting, optimizing, and supporting enterprise data integration, warehousing, reporting, and automation solutions across Azure, Snowflake, Microsoft BI technologies, and the Power Platform.

Key Responsibilities:

  • Defines and implements enterprise data architecture leveraging Azure Data Factory (ADF), Azure Data Lake Storage (ADLS Gen2), Azure SQL, Snowflake, Snowflake OpenFlow, SSIS, SSRS, Power BI, Power Automate, and Power Query.
  • Leads conversion of SSIS packages to Azure Data Factory, Snowflake OpenFlow and modern ELT frameworks
  • Designs scalable ingestion patterns to prevent duplicate extracts and enable incremental loading
  • Optimizes long-running data extractions and improves pipeline performance
  • Manages and tunes Snowflake warehouses for performance and cost efficiency
  • Develops and supports Power BI datasets, data models, and enterprise reporting solutions
  • Supports and modernizes SSRS reporting and downstream Power Platform dependencies
  • Develops automation workflows using Power Automate to streamline operational processes
  • Utilizes advanced Excel capabilities for analysis, reconciliation, validation, and business support
  • Establishes best practices for data modeling, environment promotion (Dev/QA/Prod), naming conventions, monitoring, and operational support
  • Provides Tier 2 / Tier 3 production support for data integration and reporting platforms
  • Participates in Agile/Scrum ceremonies including sprint planning, backlog refinement, and progress reporting.
  • Identifies obsolete fact tables, unused reports, and redundant processes to streamline the data ecosystem
  • Partners with leadership to provide visibility into sprint progress, platform health, and modernization initiatives
  • Leverages Ataccama ONE for governance, data quality monitoring, and metadata management
    • Integrates and maintain Ataccama data quality workflows to support enterprise data governance

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

Salary range: $114,280 - $140,000

Core Competencies:

  • Strong communication skills with the ability to translate technical concepts to business stakeholders
  • Strong analytical and problem-solving abilities
  • High attention to detail and data accuracy
  • Strong work ethic with a sense of ownership and accountability
  • Ability to prioritize effectively in a production support and development environment
  • Collaborative team player with the ability to work cross-functionally

Required Education & Experience:

  • Bachelor’s degree in Computer Science, Information Systems, or equivalent field
  • 10+ years of experience in software design and development, with the majority of time focused in a data engineering role
  • Required Technical Skills:
    • Azure Data Factory
    • Azure Data Lake Storage (Gen2)
    • Snowflake (data modeling, performance tuning, streams & tasks)
    • Snowflake OpenFlow
    • SQL Server Integration Services (SSIS)
    • SQL Server Reporting Services (SSRS)
    • Power BI (data modeling, DAX, report optimization)
    • Power Automate
    • Power Query
    • Visual Studio
    • Azure DevOps
    • Advanced SQL development and tuning
    • Microsoft Excel (advanced formulas, pivot tables, data validation)
    • Git-based version control and CI/CD practices
    • Agile / Scrum methodology
    • Enterprise production support experience
LERETA, LLC

About LERETA, LLC

Since 1986, LERETA has provided a full suite of national real estate tax services for residential and commercial loans, including automated online research and certification, tax bill processing, a suite of delinquent tax services, and customized tax outsourcing service programs. In addition, LERETA provides real-time flood zone determination services that include flexible levels of service based on our customers’ needs - from simple delivery of flood zone determinations to complete portfolio life-of-loan tracking. Our innovative technologies and dedicated team of real estate tax and flood service professionals provide the mortgage and insurance industries the fastest, most accurate and complete access to property tax and flood information across the country.

However, it's our EXTRAORDINARY customer service that differentiates LERETA from other real estate property tax providers. Our most fundamental core objective is to “make a positive difference” in the businesses of our customers and strategic partners. By assisting customers in reducing costs, increasing the efficiency of their businesses and through our customer focus, LERETA has established a reputation as the highest quality provider of real estate tax and flood services in the industry.

Industry
Finance & Insurance
Company Size
501-1,000 employees
Headquarters
Pomona, CA
Year Founded
1986
Social Media