Data Analyst

JPC Partners; Lower Providence Township, Northern (PA, KY); Hybrid; USD 55,000 - 75,000; Full time

Job summary

JPC Partners is seeking a Data Analyst I to provide expertise in developing solutions and creating reports, focusing on analytical evaluation and data-driven insights.

In this role you will identify data requirements, cleanse and transform data, optimize storage, and support dashboards and analytics applications with SQL, Tableau, and Databricks. Strong communication and collaboration skills are essential.

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

SQL

Oracle PL/SQL

Data analysis

Data modeling

Big data

Data cleansing

Education

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

Tools

Tableau

Databricks

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:

• 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

Requirements and Skills:

• 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

Desired Qualities:

• Open mindset, ability to quickly adapt to new technologies and learn new practices
• Communication, Collaboration, Presentation skills