Role Name: Data Analyst II
Location:  Columbia, SC (Tuesday through Thursday onsite and as needed, Monday & Friday remote)
Duration: 12 months
 
Job Summary:
Duties/About the role:

• Analyzes data for creation of statistical reports used for program or process evaluation. Responsible for maintaining databases and extracting data for analysis. Runs and reviews reports, analyzing results in support of operational functions.
• 40% Reviews, extracts and analyzes data to be used in formulation of procedures, processes and other requirements. Provides reports of relevant activity to be used to identify problematic areas and to provide basis for modification and/or elimination of operations issues.
• 35% Assists with development of complex analysis and sophisticated data compilation, verification, and interpretations to guide divisional efforts. Performs focused analyses as needed. Creates data search programs to identify pertinent data needed to provide supporting documentation for system or operational enhancements/changes.
• 5% 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.

 
Day to Day:

• This role will oversee our financial forecasting and budgeting processes, utilizing SQL, Excel, Power BI, and Azure to produce accurate inputs and manage our budget process. A typical day involves updating regular reports and providing new ad hoc reports using SQL and Excel, as well as creating and maintaining Power BI dashboards to visualize data and insights. This customer-facing role requires leading weekly meetings, providing comprehensive reporting, and guiding discussions to ensure smooth operations and resolve any issues. Additionally, this role will function as a consultant, offering guidance to customers on best practices for completing processes and managing work efficiently.

Work environment:

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

 
Team Info:

• Team Name: Commercial Client Analyst team
• Collaborative Environment: tight-knit team of 3 analysts within our small but impactful Client Management department of around 35 members.
• Meaningful Work: support our Client Management organization, which works closely with external business partners to build relationships and drive business success.
• People-Oriented Culture: fun, supportive department that values individual contributions and fosters a positive work environment.

 
Job Requirements:
Required Experience:

• 2 Years Research and analysis experience

Preferred Work Experience:

• 4 Years-Research and analysis experience.

 Required EDU:  

• Bachelor's degree in Statistics, Computer Science, Mathematics, Business, Healthcare, or 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 Software and Tools (Hands on experience required):

• Excel, Access/SQL
• Does not need to be proficient at writing SQL. Building queries visually in Access is sufficient.

Required Skills: 

• MS OFFICE

 
Soft skills:

• Exceptional Communication Skills: As a coordinator for processes involving large groups, you will need to clearly explain tasks and coordinate effectively to ensure smooth operations.
• Process Analysis and Improvement: Focus on making processes more intuitive for users, with a eye on analyzing and improving people processes.
• Strong Business Acumen: Ability to see the bigger picture and understand the broader business context, stepping beyond just the data.
• Meticulous Attention to Detail: Ensure accuracy in information and reporting and correct any errors or mistakes.
• Outstanding Customer Service: Engage directly with customers daily, providing excellent service and collaborating with a diverse range of people.

 
Nice to have/Preferred skills:  

• Power BI/Power Query, Azure, Power Automate

 

About Us: 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 140 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. Learn more at: http://www.spectraforce.com
 
Benefits: SPECTRAFORCE offers ACA compliant health benefits as well as dental, vision, accident, critical illness, voluntary life, and hospital indemnity insurances to eligible employees. Additional benefits offered to eligible employees include commuter benefits, 401K plan with matching, and a referral bonus program. SPECTRAFORCE provides 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 LOA@spectraforce.com if you require reasonable accommodation.
 
California Applicant Notice: SPECTRAFORCE is committed to complying with the California Privacy Rights Act (“CPRA”) effective January 1, 2023; and all data privacy laws in the jurisdictions in which it recruits and hires employees. A Notice to California Job Applicants Regarding the Collection of Personal Information can be located on our website. Applicants with disabilities may access this notice in an alternative format by contacting NAHR@spectraforce.com.
 
LA County, CA Applicant Notice: If you are selected for this position with SPECTRAFORCE, your offer is contingent upon the satisfactory completion of several requirements, including but not limited to, a criminal background check. We consider qualified applicants with arrest or conviction records for employment in accordance with all local ordinances and state laws, including the Los Angeles County Fair Chance Ordinance for Employers (FCO) and the California Fair Chance Act (FCA). The background check assessment will consider whether a criminal history could reasonably have a direct, adverse impact on the job-related safety, security, trust, regulatory compliance, or suitability for this role. Such findings may result in withdrawal of a conditional job offer. 


At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $30.00/hr.