Data Analyst III at Spectraforce Technologies

Job Title-: Data Analyst III
Duration-: 12 months
Location-: Columbia, SC (Onsite 3x per week)
Schedule: 8:30am to 5pm with a 30 minute lunch or 8 to 5 with an hour lunch - Potential OT. This would be an exception, not a standard.

Job Description:
Duties:

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

Day to day:

• There is a development and recurring or operational focus for the analyst. The development work is consultative, customer-facing, and requires understanding I/S business processes.
• Work involves facilitating meetings, gathering and documenting requirements, interacting with management and multiple teams to complete work, designing and developing a solution, and presenting outcomes to customers.
• This work requires a technical focus as well as a business perspective and consultative mindset.
• The recurring or operational work is recurring, repeatable tasks and includes one-time ad-hoc requests. Recurring reports and data entry are well defined and are as automated as possible.
• Recurring work is reviewed annually at a minimum to ensure it continues to meet business needs.
• This work requires knowledge of reporting and data tools and communication with customers.
• The operations focuses on timeliness, accuracy, consistency, and providing the key customer insights and analysis to help with business needs and decisions

The Team:
I/S Business Analysis Department (aka I/S BAD) The team size is around 10 team members. The team is extremely collaborative, working together to design and build cohesive solutions for our customers.

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: Computer programming skills. 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.

Job Requirement:
Required 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: Strong SQL knowledge, PowerBI, Microsoft Excel Preferred Technologies: Tableau, Power Automate, Python, GitHub, MS Access