Data Analyst II in Harrisburg, PA at CBIZ

Date Posted: 12/1/2020

Job Snapshot

Job Description

With over 100 offices and nearly 5,000 associates throughout the U.S. CBIZ (NYSE: CBZ) delivers top-level financial and employee business services to organizations of all sizes, as well as individual clients, by providing national-caliber expertise combined with highly personalized service delivered at the local level.  

CBIZ has been honored to be the recipient of several national recognitions:  

  • 2020 Best Workplaces in Consulting & Professional Services by Great Place to Work®  
  • 2019 America’s Best Mid-Size Employers by Forbes 
  • 2019 Workplace Excellence Seal of Approval by the Alliance for Workplace Excellence 
  • Top 101 highest scoring companies in the country for Best and Brightest Companies to Work For in the Nation by the National Association for Business Resources  

Together, CBIZ and Mayer Hoffman McCann P.C. (MHM) are ranked as one of the top providers of accounting services in the United States. MHM is an independent CPA firm that provides audit, review and attest services, while CBIZ provides, business consulting, tax and financial services.   

Essential Functions and Primary Duties

  • Develop and distribute standard reports, custom reports, and data files
  • Using SAS Enterprise Guide, AQT, and MS Office tools.
  • Knowledge in data analytics and data structures particularly DB2, SQL, and Mongo.
  • Knowledge in SQL query language
  • Expert level experience in Excel
  • Intermediate experience in data analytics tools. (Examples include IDEA, ACL, Alteryx, Tableau and Power BI)
  • Interpret data and analyze results using statistical techniques and provide ongoing reports
  • Identify, analyze, and interpret trends or patterns in complex data sets
  • Work closely with management to prioritize business and information needs
  • Initially validate results to ensure data integrity of the reports and/or files produced
  • Work with internal customers on custom data reporting and file requests to define requirements, create queries to meet requirements, conduct testing, and execute import/export processes

Preferred Qualifications

  • 2+ years of experience using SAS for the querying and analysis of data
  • Ability to use Base SAS to write programs using data steps (in addition to general PROC SQL) with oversight from senior data analysts
  • Ability to work independently to construct queries and review output to create initial trend identification
  • Ability to effectively communicate analysis results to technical and non-technical audiences
  • Advanced Excel skills including formulas, pivot tables, charting, and data tables
  • Knowledge of relational databases and database querying language (e.g. SQL)
  • Current federal 6C government clearance

Minimum Qualifications

  • Equivalent experience-Mathematics, Economics, Computer Science, Information Management, Economics, Statistics or a related field
  • 2-4  years of experience
  • Knowledge of relational databases and database querying language (e.g. SQL)
  • Intermediate level of proficiency with Microsoft Excel, Word, and PowerPoint
  • Working knowledge of database architecture and ability to effectively map data, as well as run basic SQL queries to analyze large complex data sets and troubleshoot
  • Acute attention to detail and strong analytical and critical thinking skills
  • Strong written and verbal communication skills including the ability to communicate results of data analysis to a variety of stakeholders
  • Motivation to achieve individual and team goals, must be able to work independently and in a team environment
  • Ability to learn and apply industry-specific concepts
  • Adaptable to change and able to work independently and as part of a team
  • Strong problem analysis skills to include the use of mathematical concepts to validate results


  1. Business Analyst Jobs
  2. Business Management Jobs

not ready to apply ?

Joining our Talent Network will enhance your job search and application process. Whether you choose to apply or just leave your information, we look forward to staying connected with you.