Company:
Smart IMS. Inc
Location: Philadelphia
Closing Date: 19/11/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
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).
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).
Share this job
Useful Links