Data Analyst

UGI Hvac Services, Inc.; Norwalk, Northern (CT, KY); Hybrid; USD 101,000 - 135,000; Full time

Benefits offered by this job

Annual bonus

Job summary

HomeServe USA is seeking a Data Analyst to bridge business goals and technical data solutions. You will gather and analyze requirements, work with SMEs to explore data, and develop data models while deconstructing Alteryx workflows and Tableau reports.

The role emphasizes strong communication, problem solving, and analytical skills, with travel up to 10% as needed and an annual bonus potential of 10%.

Qualifications

• Bachelor’s degree or equivalent experience.
• Minimum of 3-5 years of experience in a data-focused role.
• Hands-on experience with SQL, Alteryx and Tableau reporting.
• Knowledgeable with conceptual, logical and physical data models.
• Familiarity with Transactional and Data Warehouse.

Responsibilities

• Understand current and future data requirements with SMEs and business analysts.
• Profile and analyze data from various sources using SQL and ensure data quality.
• Deconstruct Alteryx workflows and understand transformations from the business perspective.
• Document data flows and communicate steps of data analysis to stakeholders.
• Identify opportunities to improve efficiency and suggest solutions.
• Collaborate with Data Engineering to review design code and test plans.
• Identify relevant data attributes and document inputs/outputs.
• Document data acquisition, integration, cleansing and monitoring processes.
• Perform routine ad-hoc data runs and respond to queries.
• Establish data validation frameworks to ensure accuracy and reliability.

Skills

SQL

Alteryx

Tableau

Data modeling

MS Office

Education

Bachelor’s degree or equivalent experience

Tools

MS Word

MS Outlook

MS Windows

Job description

Job Category: Non-Union Non-Contact Center

The Data Analyst bridges business goals and technical solutions by gathering, documenting, and analyzing requirements. They work closely with SMEs to explore and analyze data, identify opportunities for process improvement, understand data transformation and develop data models Strong communication, problem solving, and analytical skills are crucial for this role. The Data Analyst utilizes analytical skills, SQL, ETL/ELT and understanding data modeling and will play a key role in the deconstructions of existing Alteryx workflows and Tableau reports.

Responsibilities:

• Working closely with Business Analysts and SMEs from various business functions to understand current and future data requirements.
• Using SQL to profile and analyze data from various sources, ensuring data quality by identifying gaps or inaccurate data, and how to prepare it for curation.
• Responsible for deconstruction of existing Alteryx workflows and understand the transformation from the business perspective.
• Assist in documentation of source to end-point data flows using MS-video and effectively communicating to stakeholders the steps of data analysis process.
• Identify opportunities for improving efficiency and effectiveness, recommending solutions where appropriate.
• Work with Data Engineering to review design code and test plans to increase knowledge and application of key frameworks and methodologies.
• Identify relevant data attributes from internal data sources and document inputs/outputs.
• Document key processes and workflows around data acquisition, integration cleansing and monitoring.
• Conduct routine ad-hoc data runs and prepare write-ups in response to data queries.
• Establish data validation frameworks to verify and ensure that data is accurate, consistent, and reliable.

Essential Functions:

% of Time on Function

Data exploration and analysis

35%

15%

Deconstruction of existing Alteryx workflows and Tableau reports

35%

Data validation

15%

Total

100%

Job Requirements:

• Bachelor’s degree or equivalent experience.
• Minimum of 3-5 years of experience in Data focused role.
• Strong analytical, verbal and written communication and interpersonal skills.
• Hands-on experience with SQL, Alteryx and Tableau reporting.
• Knowledgeable with conceptual, logical and physical data models.
• Familiarity with Transactional and Data Warehouse.
• Well organized detail oriented with ability to work under pressure and meet deadlines while managing multiple concurrent tasks.
• Competency in MS windows, MS Word, and MS Outlook.
• Strong work ethic and willingness to take ownership.
• Ability to work independently.
• Ad-hoc responsibilities assigned.
• Travel up to 10% as needed.

Minimum Physical Requirements:

The physical demands described represent those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the functions of the position for which they work. While performing the duties of this position, the employee is regularly required to listen, talk and hear. The employee frequently is required to use hands or fingers, handle or feel objects, tools, or controls while executing tasks like working on a computer or talking on the telephone. The employee is occasionally required to stand; walk; sit; and reach with hands and arms. The employee must occasionally lift and/or move up to 15 pounds. Specific vision abilities required by this position include close vision, distance vision, and the ability to adjust focus. The noise level in the work environment is usually moderate to low.

This job description is intended to provide guidelines for job expectations and the employee's ability to perform the position described. It is not intended to be construed as an exhaustive list of all functions, responsibilities, skills, and abilities. Additional functions and requirements may be assigned by supervisors as deemed appropriate.

Salary Range (Chattanooga, TN): $82,759.65 - $110,346.20

Salary Range (Norwalk, CT): $101,150.69 - $134,867.58

Annual Bonus Potential: 10%

HomeServe USA is an equal opportunity employer.

#HUSA #LI-NM1 #LI-ONSITE

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.