Data Analyst - Smart IMS. Inc
Philadelphia, PA 19121
About the Job
Data Analyst
Onsite and Virtual Interviews
Hybrid
1-2 Rounds of interview
6+ Months
Philadelphia, PA
Work activities:
Skills/experience of the assigned staff:
Required
Highly Desired/Preferred
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).
Source : Smart IMS. Inc