Data Analyst I: Insights, Dashboards & Automation

JPC Partners; Pennsylvania; On-site; USD 55,000 - 80,000; Full time

Job summary

JPC Partners is looking for a Data Analyst I that will provide expertise in developing solutions and creating reports and will focus on analytical evaluation and reporting of data.

Responsibilities include identifying and preparing data for analysis, cleansing and transforming data, automating repetitive tasks, and loading data into data warehouses and reporting systems to support analytics applications.

Qualifications

• 2-5 years of relevant experience in data science and/or data analysis.
• Bachelor’s Degree in Computer Science, Information Systems, Computer Engineering or similar.
• Experience working with large and complex data sets; big data projects.
• Knowledge/Experience with SQL and Oracle PL/SQL.
• Knowledge/Experience with Tableau and Databricks preferred.
• Performance/security-oriented data modeling and data design, including partitions, different type of indexes, views, and most effective data management practices preferred.

Responsibilities

• Identifying, creating, and preparing data required for analysis and visualization.
• Assuring that data is cleansed, mapped, transformed, and optimized for storage and use according to business and technical requirements.
• Identifying opportunities for improvement and implementing automation of tasks.
• Loading transformed data into storage and reporting structures such as data warehouses, real-time reporting systems and analytics applications.
• Drawing conclusions from data analysis and assessing recommendations.

Skills

Data analysis

Big data experience

Data cleansing

Automation

Communication skills

Collaboration

Education

Bachelor’s Degree in Computer Science, Information Systems, Computer Engineering or similar

Tools

SQL

Oracle PL/SQL

Tableau

Databricks

Data modeling

Data design

Job description

JPC Partners is looking for a Data Analyst I that will provide expertise in developing solutions and creating reports and will focus on analytical evaluation and reporting of data.

Responsibilities include identifying and preparing data for analysis, cleansing and transforming data, automating repetitive tasks, and loading data into data warehouses and reporting systems to support analytics applications.