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:
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
|
Spectraforce Technologies
Mar 13, 2025