Data Analyst

SPECTRAFORCE; Columbia (SC); On-site; USD 60,000 - 85,000; Full time

Job summary

SPECTRAFOR in Columbia, South Carolina is seeking a qualified professional responsible for creating and analyzing reports that support operations, ensuring data accuracy for decision-making.

Applicants should have a Bachelor's degree in a relevant field and at least 4 years of research and analysis experience. The role requires advanced skills in Microsoft Office, SQL, and PowerBI, with the opportunity to engage in a typical office environment and travel as needed.

Qualifications

• Strong organizational, customer service, communications, and analytical skills.
• Advanced experience in mathematical and statistical concepts.
• Ability to train subordinate staff in reporting design and execution.

Responsibilities

• Create and analyze reports to support operations.
• Ensure accuracy of data for financial and operational decisions.
• Communicate and train employees on complex database programs.

Skills

Organizational skills

Customer service

Analytical skills

Communication skills

Education

Bachelor's degree in Statistics, Computer Science, Mathematics, Business, or Healthcare

Tools

Microsoft Office

DB2

SQL

PowerBI

Job description

Responsibilities

• Creates and analyzes reports to support operations.
• Ensures correctness of analysis, and reports findings in a concise manner to senior management.
• Directly responsible for accuracy of data as financial and operational decisions are made based on the data provided.
• 30% Generates internal and external reports to support management in determining productivity and efficiencies of programs or operational processes.
• Revises existing reports and develops new reports based on changing methodologies.
• 30% Analyzes reports to ensure accuracy and quality.
• Tracks and verifies all reporting statistics.
• 20% Communicates and trains employees and managers on the complex database programs used to generate analytical data.
• 20% Designs, codes, and maintains complex database programs for the extraction and analysis of data to support financial and operational decisions.

Required Skills and Abilities

• Strong organizational, customer service, communications, and analytical skills.
• Advanced experience using complex mathematical calculations and understand mathematical and statistical concepts.
• Knowledge of relevant computer support systems.
• Ability to train subordinate staff including provide assistance/guidance to staff in design/execution of reporting needs.
• Proven experience with report writing and technical requirements analysis, data and business process modeling/mapping, and methodology development.
• Strong understanding of relational database structures, theories, principles, and practices.

Required Software and Other Tools

• Advanced knowledge of Microsoft Office.
• Knowledge of programming languages across various software platforms, using DB2, SQL, and/or relational databases.
• Knowledge of tools such as Visual Basic and Macros useful in automating reporting processes.

Preferred Skills and Abilities

• Negotiation or persuasion skills.
• Knowledge of ICD9/CPT4 coding.
• Knowledge of the healthcare delivery system.

Preferred Software and Other Tools

• SAS experience.

Work Environment

Typical office environment. Some travel between buildings and out of town.

Education

Bachelor's degree in Statistics, Computer Science, Mathematics, Business, Healthcare, or other related field. Degree equivalency: 2 year degree in Computer Science, Business or related field and 2 years of reporting and data analysis work experience. OR 4 years reporting and data analysis experience.

Required Work Experience

4 Years Research and analysis experience. Preferred Work Experience: 6 Years-Research and analysis experience.

Required Technologies

• Excel
• PowerBI

Nice To Have

• Access
• Power Query
• SharePoint
• Power Automate

Day To Day

• Assisting customers (I/S employees) with adhoc analysis and recurring work related primary to work planning and resource allocation using an internal tool (MPS) in conjunction with the backend database (SQL Server) through Access, Excel, PowerBi, exc.
• Utilizing a consultative mindset to help customers reach intended outcomes, driving process schedules, and process improvements to sustain the high level of quality that is expected of our department.
• Able to understand the data at the lowest level, but also talk to the story and summarize for an executive audience.
• Position is more people oriented than technical.

Soft Skills

• Crisp and clear verbal communication is paramount.