Data Analyst I

Socket.dev; Tarentum (Allegheny County); On-site; USD 70,000 - 90,000; Full time

Benefits offered by this job

Health

Dental & Vision Plans

401(k) Savings Plan

Flexible Benefits Plan

Life & Accidental Death & Dismemberm.

Disability Income Plan

Paid Time Off

Job summary

Management Science Associates, Inc. (MSA) is a diversified data analytics and information management company with a long history of delivering insights to clients across industries.

This role focuses on translating client requirements into actionable tasks and maintaining high data quality. As a full-time analyst, you will load, query, extract, and validate data, refresh databases, and prepare reports for clients.

Qualifications

• Bachelor's degree in Computer Science or related discipline or equivalent experience.
• Proficiency in Microsoft Office, SQL, relational databases, Oracle and Unix.
• Strong interpersonal and communication skills; ability to multitask.
• Knowledge of database structures and data models.

Responsibilities

• Translate client requirements into specific tasks and actions needed to deliver on our commitments
• Load, Query, extract and validate data
• Refresh databases with current data, ensure data is correct and prepare reports and other deliverables for our clients
• Identify problems and proactively look for areas to automate and improve.
• Participate in User Acceptance Testing (UAT) and system implementations. Perform quality assurance functions to validate data, software, hardware, or procedure changes.
• Communicate and work with other IMS cross functional teams

Skills

SQL

Relational databases

Oracle

Unix

Microsoft Office

Data analysis

Interpersonal & communication

Multitasking

Education

Bachelor's degree in Computer Science or related discipline

Tools

Control M

Appworx

Job description

Responsibilities:

• Translate client requirements into specific tasks and actions needed to deliver on our commitments
• Load, Query, extract and validate data
• Refresh databases with current data, ensure data is correct and prepare reports and other deliverables for our clients
• Identify problems and proactively look for areas to automate and improve.
• Participate in User Acceptance Testing (UAT) and system implementations. Perform quality assurance functions to validate data, software, hardware, or procedure changes.
• Communicate and work with other IMS cross functional teams

Required Skills:

• Bachelor's degree in Computer Science or related discipline or equivalent experience. A master's degree in a relevant discipline may substitute for one year of experience
• Microsoft Office
• SQL
• Relational database and data analysis
• Oracle and Unix
• Knowledge of database structures and data models
• Interpersonal and communication skills
• Multi-tasking skills

Desired Skills and Experience

• Scheduling software i.e. Control M or Appworx
• Project management
• Experience with third party reporting and master data management tools
• Training skills

Management Science Associates, Inc. (MSA) is a diversified, dynamic and growing information management company that for over sixty years has partnered with institutional and commercial customers to identify areas in which innovative analytics, data and technology deliver incremental growth and drive efficiency. We have a rich legacy of being first to market, consultative partners, and serial innovators at heart. We’re proud to say that we even won an Emmy!

Our products and solutions are utilized across dozens of industries including Consumer Packaged Goods, Media, Healthcare, Pharmaceuticals, Metals and Advanced Manufacturing, Casino Gaming, Medical Cannabis, Internet Applications and Data Center/Co-location Services. Our client partners range in size with many being some of the largest, well-known corporations in the world.

MSA has distinguished itself as an employer of choice in the high technology software and information management industry. We actively recruit talented graduates and experienced professionals looking for a rewarding career at a company that recognizes employees as their best asset. MSA continuously seeks talent within our business practices: Business Analysis, Information Management Solutions, Media, Life Sciences, Metals & Advanced Manufacturing, Information Technology Systems and Services, and Corporate Information Systems.

MSA employs more than 500 people, working across the United States and world-wide. We have three offices in the Pittsburgh area along with offices in United Kingdom and Malaysia.

All full-time employees are eligible to participate in our comprehensive benefits package which includes:

• Health
• Dental & Vision Plans
• 401(k) Savings Plan
• Flexible Benefits Plan
• Life & Accidental Death & Dismemberment Insurance
• Disability Income Plan
• Paid Time Off (PTO) including Vacation, Sick and Holiday, and more.

We hope you will consider joining our team and become part of our continued growth and success.