*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 advancem