Data Analyst II: Analytics, QA & Automation

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

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.