Data Analyst

Data Analyst

Onsite and Virtual Interviews

Hybrid

1-2 Rounds of interview

6+ Months

Philadelphia, PA

Work activities:

Gather data from identified systems in various formats, including databases, spreadsheets, and external systems

Review data for accuracy and completeness

Identify inconsistencies and anomalies within data

Clean data to eliminate duplicates, correct errors and fill missing values

Standardize data formats for consistency

Prepare data for integration into data lake

Collaborate with department analysts/business owners to understand data of identified systems

Collaborate with engineers, analysts and developers to assist in understanding and both upstream and downstream uses of data

Create comprehensive data mapping documents

Create data review and cleaning report

Create comprehensive reports and dashboards to present data findings to stakeholders.

Utilize data visualization tools (e.g., Power BI) to create interactive and intuitive visual representations of data

Communicate complex data insights in a clear and concise manner to non-technical audiences

Skills/experience of the assigned staff:

Required

Strong SQL skills

Strong Analytical skills

Excellent Microsoft Excel skills

Aptitude for learning other analytical tools

3 years' experience as data analyst or similar role

Excellent communication and presentation skills.

Attention to detail and a commitment to data accuracy

Highly Desired/Preferred

Experience with cloud platforms

Experience using Azure Data Factory

Experience using Python

Experience using AWS S3

Experience with data visualization tools (e.g., Power BI).