Lead Data Analyst

Title: Lead Data Analyst
Location: Columbia, SC (Onsite - Tuesday, Wednesday and Thursday)
Duration: 12 Months
Mi\n Pay Rate: $40/hr W2

C2 Clearance eligibility is required

Required Education: Bachelor's degree in Statistics, Computer Science, Mathematics, Business, Healthcare, or other related field or 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: 6 Years Research and analysis experience.

Preferred Work Experience: 8 Years Research and analysis experience.

Required Technologies:
* Advanced Data Analytics/Dashboarding
* Advanced Microsoft PowerBI, PowerAutomate, Advanced Excel, SQL
* Tableau

Nice to Have:
* Business Objects
* Python

Day to Day:

• The role supports daily, weekly, monthly, and ad-hoc reports for end users and management use in performance monitoring and decision making.
• The role also works with other areas in the department and supporting other departments creating or updating reports/dashboards to meet business needs.
• This role advises management on best practices when developing or updating reports and creates/maintains procedures/instructions related to report design and execution.

Soft Skills:

• Communication skills - the ability to translate what the data means and to various audiences.
• Attention to detail - as the output and analysis delivered will be used to make organizational and management decisions driving strategy and future initiatives, excellence in finished product is necessary.
• Creative thinking - being able to identify the best way to report or deliver information so it is digestible and easily consumable.
• Teamwork - being able to work with others to share knowledge and continue to build the department.

Responsibilities:

• Serves in a lead capacity as an expert data analyst and may also lead a team.
• Creates and analyzes reports to support operations.
• Presents report findings in a concise manner to appropriate management level.
• Directly responsible for accuracy of data as financial and operational decisions are made based on the data provided.
• 40% Reviews, extracts and analyzes data to be used in formulation of procedures, processes and other requirements, including data integrity and quality control.
• Provides reports of relevant activity to be used to identify problematic areas and data anomalies, in order to provide basis for modification and/or elimination of operations issues.
• Revises existing reports and develops new reports based on changing methodologies.
• Analyzes reports to ensure accuracy and quality.
• Tracks and verifies all reporting statistics and/or metrics.
• 30% Develops complex analysis and sophisticated data compilation, verification, and interpretations to guide divisional efforts.
• Creates data tools used to identify/modify pertinent data needed to provide supporting documentation for system or operational regulatory reporting.
• 20% Communicates with and/or trains employees and managers on the complex database programs used to generate analytical data.
• Documents reporting procedures so other staff can run ad hoc reports independently.
• Designs, codes, and maintains complex database programs for the extraction and analysis of data to support financial and operational decisions.
• 10% Monitors data for compliance with all applicable regulations, and communicates and updates data as necessary.
• Provide assistance throughout internal and external audits.

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.
• Knowledge of the healthcare delivery system.

Required Software and 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.

Preferred Software and Tools: SAS experience.

Work Environment: Typical office environment.

Below is the brief introduction of SPECTRAFORCE, the benefits we offer and the disclaimers:
Established in 2004, SPECTRAFORCE is one of the largest and fastest-growing diversity-owned staffing firms in the US. The growth of our company is a direct result of our global client service delivery model that is powered by our state-of-the-art A.I. proprietary talent acquisition platform, robust ISO 9001:2015/ISO 27001 certified processes, and strong and passionate client engaged teams.

We have built our business by providing talent and project-based solutions, including Contingent, Permanent, and Statement of Work (SOW) services to over 130 clients in the US, Canada, Puerto Rico, Costa Rica, and India. Key industries that we service include Technology, Financial Services, Life Sciences, Healthcare, Telecom, Retail, Utilities and Transportation.

SPECTRAFORCE is built on a concept of "human connection," defined by our branding attitude of NEWJOBPHORIA, which is the excitement of bringing joy and freedom to the work lifestyle so our people (and clients) can reach their highest potential. Our entire workflow and teams are trained to cultivate the joy of NEWJOBPHORIA with candidates and employees throughout their engagement with SPECTRAFORCE.

Benefits: SPECTRAFORCE offers ACA compliant health benefits as well as dental, vision, accident, and hospital indemnity insurances. Additional benefits SPECTRAFORCE offers to the eligible employees include commuter benefits, 401K plan with matching and a referral bonus program. SPECTRAFORCE offers unpaid leave as well as paid sick leave when required by law.

Equal Opportunity Employer: SPECTRAFORCE is an equal opportunity employer and does not discriminate against any employee or applicant for employment because of race, religion, color, sex, national origin, age, sexual orientation, gender identity, genetic information, disability or veteran status, or any other category protected by applicable federal, state, or local laws. Please contact Human Resources at if you require reasonable accommodation.