Data Analyst II

Remote Jobs; Tarentum (Allegheny County); On-site; USD 70,000 - 110,000; Full time

Job summary

Management Science Associates, Inc. (MSA) in the United States seeks a data-focused professional to translate client requirements into concrete tasks, load and query data, and prepare client reports and deliverables. You will refresh databases, validate data, and identify automation opportunities for improved efficiency.

The role requires 2+ years in data management/QA, proficiency in SQL, Python, Power BI, Oracle/Unix, and strong communication and multitasking skills.

Qualifications

• Bachelor's degree in Computer Science or related discipline or equivalent experience.
• Minimum two years related experience performing data management, quality assurance, and operational database support tasks
• Microsoft Office
• SQL
• Relational database and data analysis
• Oracle and Unix
• Python
• Power BI
• Knowledge of database structures and data models
• Interpersonal and communication skills
• Multi-tasking skills

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

Education

Bachelor's degree in Computer Science or related discipline

Master's degree may substitute for one year of experience

Microsoft Office

SQL

Relational database and data analysis

Oracle and Unix

Python

Power BI

Knowledge of database structures and data models

Interpersonal and communication skills

Multi-tasking skills

Job description

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
• Minimum two years related experience performing data management, quality assurance, and operational database support tasks
• Microsoft Office
• SQL
• Relational database and data analysis
• Oracle and Unix
• Python
• Power BI
• 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

About Us

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.