• Local candidates preferred but will accept remote candidates.
• Chosen candidate will need their own equipment.

***IMPORTANT NOTE*** This is a PART-TIME Position - The selected resource for this role is expected to work 24 hours per week (8 hours per day; 3 days per week). Please ONLY submit candidates who are interested in working in this part time role.

We are soliciting contractors to aid us in connecting disparate data sources using Tableau to provide real-time reporting and dashboards. We currently utilize multiple datasets including QuickBooks, Access, and various other privately and state-run mainframe and cloud-based databases. These all have separate reports and formatting, so we would need assistance creating ETLs to connect these datasets together and create a wholistic picture of the data. Additionally, we need to have Tableau dashboards and canned reports created so that our staff can quickly realize the benefits of modernizing our reporting systems. Additionally, our state is engaged in rolling out a statewide ERP that would modernize our finance, budget, payroll, performance, and time entry functions. Our current systems will still be used for historical reporting, but we will also need to connect seamlessly to the new ERP data. As part of the ERP modernization, our staff has developed crosswalks to tie out the older systems to the new ERP which will aid in creating the ETLs, however we do not have experience in Tableau itself. This process would also need to set up data feeds to automatically sync data to create up to date dashboards with real time data to aid in decision-making. “

RELEVANT WORK EXPERIENCE: 2 to 5 yrs.

Skill Matrix

• Experience setting up reports that pull data from disparate databases Required 3 Years
• Creating dashboards with automatic and daily updates within Tableau Required 3 Years
• Implantation of crosswalks to marry datasets with different languages and formats Required 3 Years
• Experience with Python or other scripting language to automate repetitive tasks Required 3 Years
• Understanding of Tableau's native language Required 2 Years