Data Analyst (Hybrid) Job at Symmetrio, Philadelphia, PA

OElyU1hVdFRyOURwV2orNXJqblE5eHZzMlE9PQ==
  • Symmetrio
  • Philadelphia, PA

Job Description

Symmetrio is actively recruiting for a Data Analyst for our customer, a large government organization in Philadelphia, PA. The primary focus of this role is to participate in mapping and documenting all existing data systems, as well as collecting, reviewing, cleaning, and preprocessing data from various systems. The secondary focus will be creating reports and visualizations of data. This position is part of a larger initiative to modernize the our client's data infrastructure by migrating data to a centralized data lake on Amazon S3 and Redshift.

This is hybrid role in Philadelphia

Responsibilities

  • 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 and business owners to understand data of identified systems
  • Collaborate with engineers, analysts, and developers to assist in understanding both upstream and downstream uses of data
  • Create comprehensive data mapping documents
  • Create data review and cleaning reports
  • Develop 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

Requirements

  • 3+ years of experience working as a Data Analyst or in a similar role
  • Strong SQL skills
  • Excellent analytical skills
  • Advanced proficiency in Microsoft Excel
  • Aptitude for learning other analytical tools
  • Excellent communication and presentation skills
  • Strong attention to detail and commitment to data accuracy

Preferred Qualifications

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

Benefits

  • Health Care Plan (Medical, Dental & Vision)
  • Retirement Plan (401k, IRA)
  • Paid Time Off (Vacation, Sick & Public Holidays)

Job Tags

Holiday work, Full time,

Similar Jobs

Lane Valente Industries

Traveling Journeyman Electrician Job at Lane Valente Industries

 ...driven to be highly productive members of the team with an emphasis on integrity and learning. CURRENT OPPORTUNITY: Traveling Journeyman Electrician Responsible for the installation of electrical systems in the commercial construction markets at job sites and... 

Lipscomb University

Paralegal/Executive Assistant | Lipscomb University Job at Lipscomb University

 ...greater than shaping the minds of children; we guide children to discover their God-given gifts and passions, to develop as a whole person and to become a positive influence in their local and the greater global community. Throughout its existence, the Academy has... 

Allied / All-City Inc.

Truck Mechanic Job at Allied / All-City Inc.

 ...Experienced, diversified truck and equipment fleet mechanic. We are looking for a seasoned fleet mechanic that has engine troubleshooting experience...  ...with various types models and brands of trucks, trailers and construction equipment. This position also includes... 

Princeton University

Executive Assistant to the Chief Research Officer and Deputy Chief Research Officer | Princeton University Job at Princeton University

 ...Executive Assistant to the Chief Research Officer and Deputy Chief Research Officer US-NJ-Princeton Job ID: 2024-19909 Type: Full-Time # of Openings: 1 Category: Administrative Support Overview... 

Palm Healthcare

Urgent Care / Nurse Practitioner Job at Palm Healthcare

 ...Salary: $0.00 - $0.00 We are seeking an experienced and passionate Urgent Care Nurse Practitioner to join our team. The ideal candidate will have experience in providing care to patients in an urgent care setting, and will be able to work independently with minimal supervision...