Data Consultant

ApTask

Charlotte, NC, United States

23 days ago

Apply on www.indeed.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Compensation

$99,840.0 - $104,000.0

Working hours

Regular working hours

Job source

www.indeed.com

Tech stack

Microsoft Excel Data Analysis Data Mining Data Normalization Standard Sql Serial Peripheral Interface Macros Sql Optimization Vba Programming Language Data Analytics

Job description

The role provides critical end to end production support of metric reporting routines. The reports/dashboards are shared with senior executives within and outside of the organization to drive proper risk culture and business strategy. Given the level of the audience, report dashboards and executive summaries must be pristine and error free.
Data analytics responsibilities may include, and are not limited to, trending analysis, and success analytics to identify areas of discrepancy and possible at-risk controls. The work includes data mining, data aggregation, business metrics, SPI inventory output analysis, risk program metrics analysis, and performance/milestone analytics.

Primary Skill: -

Excel (advanced functions, power queries, and macros/VBA)
Secondary Skill: moderate/advanced SQL

Requirements

Success measures for this role include:
Advanced, expert Excel skills is mandatory (5+ years
Moderate-to-advanced SQL skills is also mandatory (5+ years)
Data mining experience (7+ years)
Analytics experience - dissect, distill, and simplify data (7+ years
Consistent, timely delivery of reporting requirements using existing macros and code
Proactive identification of code or macro breaks
Successful application of macro/code fixes and creation
Demonstrated ability capture, manipulate and clean data from multiple sources and systems of record
Applied critical eye to catch errors or discrepancies
Reliable application of advanced Excel and SQL skills to produce reporting in an efficient, timesaving manner
Ability to remain nimble and positive when priorities change and Adhoc needs arise
Shows a sense of urgency and attention to detail as standard work practice
Strong collaboration
Significant attention to detail
Effective prioritization of workbench deliverables
Timely follow-up on reporting requests and questions
Experience working in a highly regulated industry or financial institution
Has previously interacted with senior level managers
Created dashboard reports or analytics