Digital Solutions - Data Engineer at LightBox Employer in Irvine, California

Job Description:

About LightBox

LightBox is the world’s leading platform for commercial real estate information and technology. We empower decision-makers with authoritative data, integrated workflows, and unparalleled industry connections. Our clientele includes commercial and government agencies, brokers, developers, investors, lenders, insurers, technology providers, environmental consultants, and valuation professionals—all requiring definitive real estate data and robust workflow solutions.

Our expertise enables us to deliver the highest quality data, workflow tools, technology, and analytics to support location-based decision-making. There has never been a better time to make an impact. Join us on this journey and help shape the future of real estate.

 

About Digital Solutions

The Digital Solutions ("Professional Services") team at LightBox plays a crucial role in delivering tailored solutions and support to our clients. We ensure seamless integration and optimal use of LightBox's data and technology platforms, providing expert guidance and ongoing support to maximize the value of our tools. Leveraging industry knowledge and technical expertise, the Digital Solutions team helps clients streamline workflows, enhance data accuracy, and achieve superior decision-making outcomes.

Position Overview

As a Digital Solutions Data Engineer at LightBox, you will be responsible for designing, building, validating, and delivering data solutions to our customers.

You will collaborate with a highly motivated team of experienced data and software engineers, focusing on data creation, quality assurance, modeling, and architecting to address diverse use case scenarios. Your role involves developing scalable data ingestion pipelines, maintaining processes for ingesting, building, and validating spatial datasets, and leveraging your expertise in database management and Python to enhance client data solutions and ensure high-quality outputs. Data is typically delivered as standalone deliverables or within defined LightBox or client software environments.

LightBox data solutions are created using client data inputs, the LightBox data platform, and industry-standard GIS and data transformation/enrichment toolsets. These solutions provide property insights to the lending, insurance, real estate, environmental, and government sectors.

 

 

 

 

 

 

 

What you will do and achieve

Reporting to the Director of Digital Solutions, the Data Engineer will:

• Fulfill LightBox’s custom data deliveries to clients.


• Develop an in-depth understanding of LightBox data assets, infrastructure, and software, such as LandVision and SpatialStream.


• Analyze use cases and propose solutions to meet business objectives.


• Assess client requirements and develop data/software solutions accordingly.


• Model and architect data to address business problems.


• Analyze and resolve technical data and application issues.


• Create and maintain data pipelines to prepare and manage data for specific use cases.


• Develop, test, and document automated ETL (extract, transform, load) processes to meet business needs.


• Adhere to high-quality development principles while delivering solutions on time and within budget.


• Migrate existing workflows to newer infrastructures.


• Utilize SQL, ESRI ArcGIS, and other open-source GIS software to transform, enrich, and extend LightBox data assets for client delivery.


• Document data processing methodologies, best practices, and workflows concisely.


• Aggregate data from various sources and apply analytical techniques to uncover valuable insights and solve complex issues.


• Provide support, troubleshooting, modifications, enhancements, and maintenance for existing geospatial data processing scripts and tools.


• Develop data acceptance criteria, quality assurance plans, and automated testing routines.


• Investigate data-related issues and develop resolutions.


• Create tools and workflows to automate existing processes.

Education

 

• Bachelor’s degree or certificate in GIS, Geography, Computer Science, or a related discipline.


• Strong academic record with a solid foundation in GIS and Data Engineering.


• Familiarity with GIS standards, principles, best practices, open-source tools, and public domain data.
  
   

Experience

 

• 2-5 years of experience as a GIS Analyst, Data Engineer, or Data Analyst (qualified recent graduates will also be considered).
  
   

Key Knowledge & Skills

 

• Outstanding organizational, communication, analytical, and interpersonal skills.


• Ability to quickly understand technical products and explain concepts to non-technical audiences.


• Experience with project management techniques like Agile and Scrum


• Proven track record of meeting deadlines and managing multiple varied tasks.


• Fundamental knowledge in SQL (spatial), Python, ETL, and data management to aggregate, gather, manipulate, or validate data.


• Proficiency with GIS software packages and open-source tools (e.g., QGIS, ESRI, GRASS, GDAL, OGR).


• Experience utilizing Python modules, packages, and libraries.


• Experience with pipeline orchestration technology (e.g., Prefect, AirFlow).


• Proficiency with pipeline transformation tools, using Python and the Pandas library.


• Scripting experience.


• Ability to document workflows concisely.


• Commitment to exceeding assigned tasks and project expectations.

• Experience with cloud infrastructure (AWS), Git, Docker, Apigee, and Kubernetes


• Has knowledge of data security best practices (when handling sensitive data)

Core Competencies

 

• Keen interest in data engineering with a “tinkering” mindset.


• Excellent interpersonal, written, and oral communication skills.


• Driven to continually learn about and incorporate new technologies.


• Experience with implementing new technologies and continuous improvement of processes and workflows


• Thrive in a self-driven environment.


• Understanding and integrating human and machine workflows.


• Team player with the ability to work collaboratively and take on new tasks.


• Reliable problem solver with the ability to work efficiently and independently.


• Embraces challenges with a positive attitude.


• Passion for learning new concepts and skills.

 

Other Desirable Attributes

• 3+ years of experience in database design, data manipulation, and/or software engineering roles using SQL Server or similar RDBMS environments, including proficiency in stored procedures, views, optimizing queries and processes and ETL processes (Extract, Transform, Load).


• Proven experience in developing complex SQL queries to generate datasets for customers.


• Experience maintaining data quality across all stages of acquisition and processing, from data sourcing/collection to normalization and transformation.

LightBox's Diversity Commitment

At LightBox, we are dedicated to fostering a diverse workforce and creating an inclusive work environment that values everyone’s unique contributions, experiences, and perspectives. We believe in unity through diversity, cultivating a collaborative atmosphere that encourages creativity, initiative, and professional development. Our commitment includes offering a competitive salary and benefits package.

LightBox and its subsidiaries are equal opportunity employers, committed to prohibiting discrimination of any kind and providing equal employment opportunities to all employees and applicants, regardless of race, color, religion, sex, national origin, age, disability, or veteran status.

We believe that we are stronger together when we support, recognize, and embrace our differences.

Additional Information

This job description outlines the primary tasks and expectations of the position and does not encompass all responsibilities that may be assigned. Employees are expected to undertake additional tasks, responsibilities, and training as directed by their supervisors. Duties and responsibilities may evolve with business needs, with or without prior notice.

This role may require occasional overtime, including evenings, weekends, and holidays, to meet deadlines or accommodate customer requirements.

The position involves regular activities such as talking, hearing, walking, using hands, kneeling, crouching, and lifting up to 25 pounds. Reasonable accommodations will be considered for individuals with disabilities to facilitate the essential job functions.

We appreciate all applicants for their interest; however, only candidates selected for an interview will be contacted. 

NO TELEPHONE CALLS OR AGENCY SOLICITATION PLEASE.

Apply Now