Job description

Position Overview: 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: Essential Job Function % of Time on Function Data exploration and analysis 35% Documenting data requirements 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

Requirements

Must-haves

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 Job Function
% of Time on Function
Data exploration and analysis
Documenting data requirements
Deconstruction of existing Alteryx workflows and Tableau reports
Data validation
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.

Nice-to-haves

Annual Bonus Potential: 10%

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: ukg
Effort: medium

Benefits

Benefits detected in the listing.

Vision