Data Analyst II

Management Science Associates, Inc.; United States; On-site; USD 80,000 - 120,000; Full time

Job summary

Management Science Associates, Inc. is seeking a data analytics professional in the United States to translate client requirements into actionable data tasks, load and validate data, refresh databases with current information, and prepare client deliverables.

The role emphasizes proactive problem solving, automation opportunities, and collaboration with IMS cross functional teams. The candidate should have a BS in Computer Science or related field (MS substitutes for experience), at least two

Qualifications

• Bachelor's degree in Computer Science or related discipline, or equivalent experience.
• Minimum two years related experience in data management, QA, and operational database support.
• Proficiency in Microsoft Office, SQL, and data analysis.

Responsibilities

• Translate client requirements into specific tasks and actions needed to deliver on commitments.
• Load, Query, extract and validate data.
• Refresh databases with current data, ensure data is correct and prepare reports for clients.
• Identify problems and proactively look for areas to automate and improve.
• Participate in User Acceptance Testing and system implementations; perform QA on changes.
• Communicate and work with cross-functional IMS teams.

Skills

SQL

Python

Relational database and data analysis

Interpersonal and communication skills

Multi-tasking skills

Education

Bachelor's degree in Computer Science or related discipline or equivalent experience

Master's degree in a relevant discipline may substitute for one year of experience

Tools

Microsoft Office

Power BI

Oracle

Unix

Job description

• 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

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

JOB DESCRIPTION

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