Data Analyst

Description

*Must be authorized to work in the United States. Sponsorship is not available.

Job Summary

As the Data Analyst at L&S Mechanical, you will play a key role in transforming how the company leverages data to drive decision-making. Reporting to the Chief Transformation Officer, you will spend time with teams throughout the organization to understand how they work, identify pain points and uncover opportunities to improve visibility, efficiency and decision-making through data. You will explore available data, build and test reporting and analytical solutions and help transform successful prototypes into sustainable tools that deliver long-term value to the business.

General Responsibilities

• Consolidate and eliminate manual reporting by developing automated reporting and forecasting tools.
• Create standard and ad-hoc reports.
• Create analytical tools for managers and departments.
• Identify trends or patterns in complex data sets.
• Develop and optimize SQL queries and Power BI solutions that transform company data into actionable reporting, analytics and performance insights while adhering to technical standards and best practices.
• Design, test and refine Power BI reports, dashboards and analytical tools to ensure accuracy, usability and business value.
• Work directly with managers and departments to explore business challenges, identify opportunities and develop reporting and analytical solutions.
• Collaborate with teams to brainstorm, prototype and refine reports, dashboards and analytical tools.
• Identify meaningful comparisons, metrics and performance indicators that help leaders make informed decisions.
• Partner with other IT team members to ensure reporting and analytics solutions are reliable, maintainable and aligned with technical standards and best practices.
• Other duties as assigned

Qualifications

• Extensive experience in: SQL, Power BI, Excel and VBA
• Ability to analyze large datasets.
• Strong verbal and written communication skills.
• Ability to work independently.
• Excited by opportunities to solve problems
• Curious and creative.
• Growth-oriented.
• A track record of acquiring new skills through self-teaching.

Benefits

• Medical, dental and vision insurance
• FSA with debit card
• Employer-paid Short-Term Disability (STD)
• $20K in life insurance and $20K AD&D insurance
• 401(k) employer match
• Paid Vacation
• PTO
• Paid Holidays
• Annualized reviews for merit increases
• Potential for advancement

About L&S Mechanical

Headquartered in Richardson, Texas, L&S Mechanical (“L&S”) is a leading tri-trade provider of turnkey plumbing, HVAC, and electrical installation services in the Texas, South Carolina, North Carolina and Georgia residential housing markets. Founded in 1985, L&S serves large production homebuilders in Dallas / Fort Worth, South Dallas, Houston, San Antonio and Austin through its six production warehouses. Previously owned by management, L&S was acquired by The Sterling Group, a leading middle market private equity firm, in September 2021. L&S is the largest plumbing installer in Texas and has significant opportunity to grow its HVAC and electric offerings while also expanding into new geographies through acquisition and growing its nascent home services business.

The company is backed by The Sterling Group, a private equity firm established in 1982. The Sterling Group specializes in acquiring controlling interests in companies across the manufacturing, distribution, and industrial services sectors, focusing on enterprises with valuations typically between $100 million and $1 billion. To date, the firm has sponsored 67 platform buyouts, along with numerous add-on acquisitions, contributing to a total transaction value exceeding $22 billion. Currently, The Sterling Group manages over $9.4 billion in assets.