Data Engineer

Data Engineer 

Company Summary   

LCPtracker, Inc. is a cloud-based software (SaaS) provider specializing in labor compliance for public works construction projects. LCPtracker has offices in New Braunfels, TX, Orange CA, and Fenton, MI, and helps government agencies and prime contractors meet Davis-Bacon/prevailing wage compliance requirements on projects backed by federal, state, and/or local funding. Thousands of clients and over 100,000 contractors use LCPtracker for their certified payroll and construction site compliance needs. LCPtracker has been recognized year after year since 2017 as one of the “Best Places to Work” in Orange County by the Orange County Register. 

Position Summary  

The Data Engineer is responsible for designing, building, and maintaining scalable data solutions that support reporting, analytics, and business decision-making across the organization. This role focuses on developing and optimizing database objects, building reliable ETL pipelines, and delivering high‑quality reports and dashboards. Working in a Microsoft-based data environment, the Data Engineer partners closely with business and technical stakeholders to ensure data accuracy, performance, and usability. 

Primary Duties and Responsibilities 

• Design, create, and maintain SQL Server database objects, including tables, views, stored          procedures, and functions.  

• Develop, maintain, and monitor ETL pipelines using Azure Data Factory (ADF) to ingest, transform, and load data from multiple sources into the data warehouse.  

• Build and maintain a centralized Data Warehouse to support analytics, reporting, and downstream data consumption.  

• Develop and support SSRS reports and Power BI dashboards, ensuring data is accurate, timely, and presented in a clear, business-friendly manner.  

• Implement and manage Azure Analysis Services (AAS) models to support semantic layers and enterprise reporting.  

• Analyze and optimize SQL queries and data models to improve performance, scalability, and reliability.  

• Perform data quality assessments and proactively identify data integrity issues.  

• Collaborate with business users, analysts, and leadership to understand reporting and data requirements.  

• Establish and support data tools and reporting solutions for department and unit managers.  

• Document data pipelines, data models, and reporting solutions following best practices.  

• Stay current with Microsoft data platform features and recommend improvements to existing solutions.  

• Perform other duties as assigned. Duties and responsibilities may change at any time with or without notice. 

Other Duties: Please note this job description is not designed to cover or contain a comprehensive list of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.   

Core Competencies 

• Data engineering and enterprise data warehouse development  

• Advanced SQL Server development and optimization  

• ETL pipeline development using Azure Data Factory  

• Reporting and analytics with Power BI and SSRS  

• Data quality, integrity, and performance optimization  

• Microsoft Azure and SQL-based data platforms  

• Strong collaboration with business and technical stakeholders 

Work Environment 

This position performs its duties from our Orange, CA or New Braunfels, TX office. The role operates in a professional office environment and routinely uses standard office equipment such as computers, phones, mobile devices, and related technology. 

Physical Requirements 

While performing the functions of this job, the employee is regularly required to sit; frequently required to talk and hear, use hands and fingers to type, scroll and use computer equipment. The employee is required to have close visual acuity to perform an activity such as preparing and analyzing data and figures; transcribing; viewing a computer and multiple screens; extensive reading; visual inspection of text/data in both print and electronic forms.   

Position Type and Expected Hours of Work 

This is a full-time exempt position. Days and hours worked are dependent on business needs and workload. General availability during regular business hours, Monday through Friday, is expected. Based on the candidate and /or position, a hybrid work arrangement may be considered; however, a minimum of three (3) or more days per week in the office is required to support executive collaboration, leadership presence, and cross-functional engagement. Some flexibility is allowed. Occasional evening and weekend work may be required as job duties demand.   

Travel 

There is no major travel requirement for this position. However, infrequent travel may be necessary to visit remote office(s), attend conferences/industry events, etc. Attendance at our corporate Staff Retreat is required. This event is a 2-3-day retreat.  Attendance at our annual User Conference as assigned. 

Salary Range 

The salary range is $100k - $125k annually. Pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, and experience. The total compensation package for this position may also include other elements dependent on the position offered. Details of participation in these benefit plans will be provided if an employee receives an offer of employment. 

Benefits 

Along with competitive pay, as a full-time LCPtracker employee, you are eligible for the following benefits: 

• Paid Time Off 

• 10 Paid Holidays 

• Phantom Stock 

• 401k Plan with up to 4% company match 

• Medical Benefits (Health, Vision and Dental) 

• Life Insurance (company paid) 

• Long-Term Disability and Short-Term Disability (company paid) 

• Employee discounts and perks program   

__________________________________________________________________________________________ 

LCPtracker participates in the E-Verify Program. E-Verify is an internet-based system operated by the Department of Homeland Security and the Social Security Administration. It allows employers to confirm an individual’s employment eligibility to work in the United States. View the attached notices, available in English and Spanish, for important information regarding the E-Verify program. E-Verify Notice (PDF); Right to Work Notice (PDF) 

LCPtracker, Inc. is an equal opportunity employer of all qualified individuals, including minorities, women, veterans, and individuals with disabilities, and regardless of sexual orientation or gender identity. LCPtracker, Inc. will consider for employment qualified applicants with criminal histories in a manner consistent with all federal, state, and local ordinances. 

LCPtracker is committed to the full inclusion of all qualified individuals. In keeping with our commitment, LCPtracker will take steps to assure that people with disabilities are provided reasonable accommodations. Accordingly, if reasonable accommodation is required to fully participate in the job application or interview process, to perform the essential functions of the position, and/or to receive all other benefits and privileges of employment, please contact the LCPtracker Human Resources Department at HR@lcptracker.com.  

Education and Experience 

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent practical experience. 

• 3 years of experience working as a Data Engineer or in a similar data-focused role. 

• Strong experience with Microsoft SQL Server, including performance tuning and query optimization. 

• Hands-on experience building ETL solutions using Azure Data Factory (ADF). 

• Experience designing and supporting Data Warehouse solutions. 

• Proficiency with SSRS and Power BI for reporting and dashboard development. 

• Experience with Azure Analysis Services (AAS) or similar semantic modeling tools. 

• Familiarity with cloud-based and on‑premise Microsoft data technologies. 

• Strong analytical, problem-solving, and communication skills. 

Salary : $100,000 - $125,000