Data Engineer

Data Engineer

Company Summary

LCPtracker Inc. is a cloud-based software (SaaS) provider specializing in labor compliance for public works construction 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 of clients and over 100000 contractors use LCPtracker for their certified payroll and construction site compliance has been recognized year afteryear since2017 as one of the Best Places to Work in Orange County by the Orange County Register.

PositionSummary

The Data Engineeris responsible fordesigning building andmaintainingscalable data solutions that support reporting analytics and business decision-making across the organization. This role focuses on developing andoptimizingdatabase objects building reliable ETL pipelines and deliveringhighqualityreports 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 andmaintainSQLServerdatabase objects including tables views stored procedures and functions.

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

• Build andmaintaina centralized Data Warehouse to support analytics reporting and downstream data consumption.

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

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

• Analyze andoptimizeSQL 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: Pleasenotethis job description is not designed to cover orcontaina comprehensive list of activities duties or responsibilities that arerequired ofthe 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 fromour Orange CA orNew Braunfels TX office. The roleoperatesin a professional officeenvironment and routinely uses standard office equipment such as computers phones mobile devices andrelated technology.

Physical Requirements

While performing the functions of this job the employeeis regularly required tosit;frequentlyrequiredto talk and hear use hands and fingers to type scroll and use computer equipment. The employeeis required tohave close visual acuity to perform an activity such as preparing and analyzing data andfigures; 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 afull-time exemptposition. Days and hours worked are dependent on business needs and workload. General availability during regular business hours Monday through Friday is on the candidateand /or position a hybrid work arrangement may be considered; howevera minimum of three (3) or more days per week in the office isrequiredto support executive collaboration leadership presence and cross-functional engagement. Some flexibility is allowed. Occasional evening and weekend work may berequiredas 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 isrequired. This event is a 2-3-day at our annual User Conference as assigned.

Salary Range

The salary range is$100k - $125kannually. 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 andperksprogram

LCPtracker participates in the E-Verify Program. E-Verify is an internet-based systemoperatedby the Department of Homeland Security and the Social Security Administration. It allows employers to confirm an individuals employment eligibility to work in the United States. View the attached notices available in English and Spanish forimportant informationregardingthe 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. willconsider foremployment 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 keeping with our commitment LCPtracker will take steps toassurethat people with disabilities if reasonable accommodation isrequiredto fullyparticipatein 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

Education and Experience

• Bachelors 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.

• Proficiencywith 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 onpremise Microsoft data technologies.

• Strong analytical problem-solving and communication skills.