Data Analyst

HomeServe USA; Winnipauk (CT); On-site; USD 101,000 - 135,000; Full time

Job summary

HomeServe USA in Norwalk, CT seeks a Data Analyst to bridge business goals and technical solutions by gathering, documenting, and analyzing data with a focus on ETL/ELT, data modeling, and reporting in Tableau.

The role emphasizes collaboration with SMEs, data validation, and deconstructing Alteryx workflows while ensuring data quality and timely delivery. Travel is not specified.

Qualifications

• Bachelor’s degree or equivalent experience.
• 3-5 years of experience in a 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.

Responsibilities

• Collaborate with Business Analysts and SMEs to understand current and future data requirements.
• Profile and analyze data from various sources using SQL; ensure data quality and prepare it for curation.
• Deconstruct existing Alteryx workflows and understand transformations from a business perspective.
• Document source-to-endpoint data flows and communicate steps to stakeholders.
• Identify opportunities to improve efficiency and effectiveness; propose solutions.
• Work with Data Engineering to review design, code, and test plans.
• Identify relevant data attributes from internal sources and document inputs/outputs.
• Document key processes and workflows around data acquisition, integration, cleansing and monitoring.
• Conduct routine ad-hoc data runs and respond to data queries.
• Establish data validation frameworks to ensure accuracy and reliability.

Skills

SQL

Alteryx

Tableau

Education

Bachelor’s degree or equivalent experience

Tools

MS Windows

MS Word

MS Outlook

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.

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.

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