STATEMENT OF WORK
OEC IT DATA SPECIALIST
Position Overview: The position would perform data management tasks such as: Using ETL (extract, transform and load) tools to transform data into a usable and trusted resource; Loading that data into the systems that end-users can access; and, Reporting that data in support of Federal grants.
Job Summary: Extract, transform, and load data from external sources, including Excel
spreadsheets and Google spreadsheets, using Dataloader API into and out of a Salesforce database
using Dataloader API, SQL, or other tools). Create reports for internal and external entities to track
and report on grant applications. Troubleshoot data and system issues. Report and track issues
related to system defects in Jira. Interface with developers as required.
Skills and Experience:
Three years minimum data experience with ETL (using Dataloader API, SQL, and RStudio)
Familiarity with data security standards
Three years (minimum) demonstrated knowledge of and experience using: Excel, Google
Suite, Salesforce CRM, Salesforce Helpdesk, Jira, SQL, RStudio
Excellent analytical and troubleshooting skills
Ability to work both independently and as part of a team
Excellent verbal and written communication skills
Accurate, thorough, and detail oriented
Efficient with time sensitive projects
Preferred: Functional understanding of relevant applications
Preferred: Current Salesforce Administrator Certification in progress
Estimated Duration
01/10/2022 - 08/31/2022
Schedule
Days
Monday Yes Tuesday Yes Wednesday Yes Thursday Yes Friday Yes Saturday No Sunday No
Hours/Day
8
Time Zone
MST Shifts Start Time End Time Description Active Shift 1 8:00 AM 5:00 PM Hours/Day Start/End Date will be discussed on hire Type Category Qualification Description Competency Required Skills Architecture AGILE - Agile Development Methodology Novice (1-3 Years) No Skills Others Mobile Application Support Novice (1-3 Years) Yes Skills Others End User Support Novice (1-3 Years) Yes Skills Others Google Suite Novice (1-3 Years) No Skills Others JIRA Novice (1-3 Years) No Skills Others Salesforce Novice (1-3 Years) Yes Skills Others Screen Sharing & Demonstrations Novice (1-3 Years) Yes Skills Others TRELLO Novice (1-3 Years) No Skills Others Communication skills both verbal and written Proficient (4-6 Years) No Skills Others Learning ability Novice (1-3 Years) No Skills Others Process Flow Analysis Proficient (4-6 Years) No Skills Others Team work No