Title:
Data Analyst
Location: Philadelphia, PA
Client: City of Philadelphia
Note: This is a hybrid position
Job Description:
- We are seeking a skilled and detail-oriented Data Analyst for a temporary assignment to join our dynamic team. The primary focus of this role is to participate in mapping and documenting all existing data systems at PHL and well as collecting, reviewing, cleaning and preprocessing data from various systems. The secondary focus will be creating reports and visualizations of data. The ideal candidate will have strong analytic skills, be proficient in data manipulation tools, and possess a keen eye for detail. This position requires 3 or more years of experience working as a Data Analyst.
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
Required Skills
- 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 accurac
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).
If you are: bright, motivated, skilled, a difference-maker, able to get things done, work with minimum direction, enthusiastic, a thinker, able to juggle and multi-task, communicate effectively, and lead, then we would like to hear from you. We need exceptionally capable people for this role for our client, so get back to us and tell us why you think you are a fit.
About Us:
Since 2000, Tri-Force Consulting Services (https://triforce-inc.com) has been an MBE/SDB certified IT Consulting firm in the Philadelphia region. Tri-Force specializes in IT staffing, software development (web and mobile apps), systems integration, data analytics, system automation, cybersecurity, and cloud technology solutions for government and commercial clients. Tri-Force works with clients to overcome obstacles such as increasing productivity, increasing efficiencies through automation, and lowering costs. Our clients benefit from our three distinguishing core values: integrity, diligence, and technological excellence. Tri-Force is a six-time winner among the fastest-growing companies in Philadelphia and a four-time winner on the Inc. 5000 list of the nation's fastest-growing companies.