Data Engineer

Description

Company Summary 

LCPtracker, Inc. is a leading software service provider specializing in construction site compliance related software, headquartered in Orange, CA. Our main solution, LCPtracker Pro, is a powerful web-based SaaS solution for collecting, verifying, and managing certified payrolls and other labor compliance related documents. Over 200 government agencies and 100,000 contractors have used LCPtracker for their certified payroll reporting.

In 2023, our growth continues at a rapid pace, making LCPtracker one of the fastest growing small companies in Orange County, California, recognized by the Orange County Business Journal. In 2017, 2018, 2019, 2020, 2021 and 2022, LCPtracker was recognized as an Orange County "Best Places to Work" by the Orange County Register.

 

Position Summary 

As a Data Engineer at LCPtracker, you will leverage your experience with SQL, ETL, and reporting to drive the design and development of data-driven solutions.  The position is responsible for performing advanced technical and analytical work in the development and support of standardized and customized reports, as well as the testing and maintaining of data integrity.

Other Duties: Please note this job description is not designed to cover or contain a comprehensive listing 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

• Confidentiality: This role may be privy to confidential and/or sensitive information. Must demonstrate integrity in maintaining confidential and sensitive information and demonstrate strict adherence to organizational policies and procedures.

• Communication Proficiency: uses friendly and proficient communication to interact with a wide range of people, frequently exchanging information about office operations.

• Time Management: Must manage their own time. They use an electronic calendar in an email program to set meetings, to request others to attend and to coordinate their responses. They respond to requests for attendance at various meetings.

• Initiative and Proactivity: Correctly anticipates a need, volunteers readily, and acts without being told to do so. Brings new ideas to the company. Undertakes self-development activities; seeks increased responsibilities; takes calculated risks; looks for and takes advantage of opportunities; asks for and offers help when needed.

• Drive for Results: Is goal-oriented; maintains focus on the objective.

• Problem Solving, Personal Judgment: Identifies and resolves problems in a timely manner; gathers and analyzes information skillfully; develops alternative solutions; works well in group problem-solving situations; uses reason even when dealing with emotional topics. Solicits and applies feedback.

• Quality Management: Looks for ways to improve and promote quality; demonstrates accuracy and thoroughness. Does not cut corners; monitors work to ensure quality; applies feedback to improve performance.

Primary Duties and Responsibilities

• Develop, modify, maintain, and support custom reports (MS SQL, SSRS) for both ad-hoc and ongoing business needs.

• Develop MS SQL objects (tables, stored procedures, functions, views, etc.) as applicable.

• Create and customize weekly, monthly, quarterly, and annual reports using Microsoft Excel or other reporting tools as applicable.

• Ensure high data quality through regular quality checks.

• Extract, filter, and aggregate data through logical queries and programming.

• Maintain a high level of confidentiality and use discretion when needed.

• Perform other work including specific tasks or special projects as required.

• Promote and maintain positive morale through teamwork.

• Other Duties: Please note this job description is not designed to cover or contain a comprehensive listing 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.

 

Salary Range

Data Engineer rate $100,000 to $140,000 annual salary

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

Paid Time Off

9 Paid Holidays

Phantom Stock

401k Plan with up to 4% company match

Medical Benefits  (Health, Vision and Dental)

Life Insurance

LTD & STD

 

Work Environment

This position performs its duties from our New Braunfels, TX office. This position operates in a professional office environment and role routinely uses standard office equipment such as computers, phones, mobile devices, photocopiers, filing cabinets and fax machines.

 

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 terminal; extensive reading; visual inspection of text/data in both print and electronic forms.

Ability to lift and move up to 25 pounds.

Position Type and Expected Hours of Work

This is a full-time exempt position reporting to our New Braunfels, TX office M-F 8am – 5pm. Days/hours worked are dependent on the workload at the time. General availability and presence in the office is expected during regular business hours Monday-Friday. However, 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.

 

LCPtracker, Inc. is an equal opportunity employer of all qualified individuals. All applicants will be afforded equal opportunity without discrimination because of race, color, religion, sex, sexual orientation, marital status, order of protection status, national origin or ancestry, citizenship status, age, physical or mental disability unrelated to ability, military status or an unfavorable discharge from military service. 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

MUST HAVE:

• Bachelor’s degree in software engineering disciplines, computer science or other related field and/or the equivalent combination of education and experience.

• 7 years of experience with SSRS reporting tools and MS SQL server.

• 7 years of experience using ETL tools such as SSIS and/or ADF.

• 7 years of experience in Data Warehousing with SSAS or AAS.

• Experience in applying security to SSAS or AAS models using authentication frameworks such as AAD or Active Directory.

• Adept at queries, report writing and presenting findings.

• Ability to comprehend, analyze, and systematically compile technical, statistical, and information into comprehensive reports or other formats.

• Effective business writing and composition skills with good command of the English language.

• Ability to independently plan, organize, and complete a variety of projects within established standards, objectives and time frames.

• Ability to work in fast-paced, multi-tasking environment with shifting priorities and demanding deadlines.

• Ability to work independently in finding solutions

• Ability to work in an agile work environment

• Ability to work in a team environment

• Must be detailed-oriented and able to effectively prioritize and organize workload, with efficient time management.

• Minimum 1-year experience working on Scrum teams. 

• Basic understanding of the Agile methodology.

• Scrum certifications are a plus.

• Strong interpersonal communication skills.

Salary : $100,000 - $140,000