Lead Data Analyst - Act Consulting

ACT Consulting has an immediate need for a Lead Data Analyst with our direct client.

ACT Consulting is a leader in the staffing industry providing candidates on a national basis for contract, contract to hire, and direct hire engagements while maintaining the highest regard for people, integrity, and customer satisfaction. Our clients are comprised mostly of Fortune 1000 companies, primarily in the areas of Information Technology, Engineering, Professional, Accounting and Finance.

Please take a moment to review the job description. If this is something you are interested in, please send a copy of your resume to jerald@act-info.com or contact me directly at 704-248-8877.

• Job Title: 31405236 - Lead Data Analyst
• Location: Columbia, SC
• Duration: 12 months
• Experience: 6 Years Research and analysis experience.
• Skills: Advanced Data Analytics/Dashboarding, Advanced Microsoft PowerBI, PowerAutomate, Advanced Excel, SQL

Duties:

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

Skills:

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

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.