Junior Data Engineer / SSRS Developer

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 Junior Data Engineer/SSRS Developer is responsible for designing, building, and maintaining scalable data solutions that support reporting, analytics, and business decision-making across the organization. The primary focus of this role is on developing SSRS reports. Working in a Microsoft-based data environment, this rolw partners closely with business and technical stakeholders to ensure data accuracy, performance, and usability.

Primary Duties and Responsibilities

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

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

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

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

• SSRS Reporting & Power BI Dashboards

• SQL Server Development & Optimization

• ETL Pipelines (Azure Data Factory)

• Data Warehousing & Data Modeling

• Azure Data Platform (SQL, ADF, Analysis Services)

• Data Quality & Performance Optimization

• Cross-Functional Collaboration & Communication

​​​​​​​

Work Environment

This position performs its duties from the New Braunfels, TX or the Orange, CA 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 non-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 hourly rate is $42.00 - $48.00 per hour. 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. 

Qualifications

Education and Experience

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

• 2+ years of experience working as a SSRS Developer and/or Data Engineer.

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

• Nice to have:

• Experience adopting AI‑first or AI‑assisted development practices