Data Analyst

HTC Global Services wants you. Come build new things with us and advance your career. At HTC Global you'll collaborate with experts. You'll join successful teams contributing to our clients' success. You'll work side by side with our clients and have long-term opportunities to advance your career with the latest emerging technologies.

At HTC Global Services our consultants have access to a comprehensive benefits package. Benefits can include Paid-Time-Off, Paid Holidays, 401K matching, Life and Accidental Death Insurance, Short & Long Term Disability Insurance, and a variety of other perks.

Job Description:

Aims to modernize its data infrastructure by mapping all existing systems and migrating the data to a centralized data lake on Amazon S3 and Redshift. This project will involve a Data Analyst to gather, review, clean, and preprocess data, and a Data Integration Specialist to create and maintain the data pipelines for smooth data migration.

Position overview:

• 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.

Skills/Experience 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).

Education:

• Bachelor's degree or equivalent practical experience.

Benefits:
At HTC Global Services our associates have access to a comprehensive benefits package that includes Health, Dental, Vision, Paid-Time-Off, Paid Holidays, 401K matching, Life and Accidental Death Insurance, Short- & Long-Term Disability Insurance, and a variety of other offerings.

Diversity & Inclusion:
Our success as a company is built on practicing inclusion and embracing diversity. HTC Global Services is committed to providing a work environment free from discrimination and harassment, where all employees are treated with respect and dignity. Together we work to create and maintain an environment where everyone feels valued, included, and respected. At HTC Global Services, our differences are embraced and celebrated. HTC is an Equal Opportunity Employer. We respect and seek to empower each individual and support the diverse cultures, perspectives, skills, and experiences within our workforce. HTC is proud to be recognized as a National Minority Supplier.