OVERVIEW: Management Science Associates, Inc., (MSA) is a diversified information management company that for over half a century has given market leaders the competitive edge in data management, analytics and technology. We are seeking an experienced Data Analyst II to join the MSA Information Management Solutions (IMS) division which has been offering data and insight solutions to the Consumer Package Goods industry since the early 1980s.

As a Data Analyst II you will be working closely with a cross sectional team of IT, Client Relations and Operational personnel to manage and deliver data directly to our clients.  This will include data loading, cleansing, master data management and extraction as well as building data warehouses and reporting.  You will work across multiple IT groups to ensure system releases are successfully migrated to production and that all deliverables reach our clients on time and correct.  This position is a great way to build skills in master data management, SQL and data analysis.

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
• HYBRID IN-OFFICE AND REMOTE WORK WITH MAJORITY OF TIME BEING REMOTE.  CANDIDATES MUST CURRENTLY LIVE IN THE PITTSBURGH REGION OR BE WILLING TO RELOCATE DUE TO OCCASIONAL IN-OFFICE WORK

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

• Knowledge of database structures and data models

• Interpersonal and communication skills

• Multi-tasking skills

DESIRED SKILLS AND EXPEREINCE

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

Required Experience

• 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

• Knowledge of database structures and data models

• Interpersonal and communication skills

• Multi-tasking skills

DESIRED SKILLS AND EXPEREINCE

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