Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Tableau VBA Analyst
(Jobs in Waltham, MA)
 
Requirement id 85949
Job title Analyst
Job location in Waltham, MA
Skills required Excel, Tableau, Database Structures, VBA
Open Date 30-Nov-2018
Close Date
Job type Contract
Duration 8 Months
Compensation DOE
Status requirement not found
Job interview type ---
   Email Recruiter: coolsoft
Job Description Analyst: Excel, Tableau, Database Structures, VBA

Candidate must be our own W2 Employee

We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens



Job Description :

Job Purpose:

The Client outsources a significant portion of their construction and maintenance work plan. Capital Delivery (CD) is responsible for overseeing the contractor workforce and managing the contracts governing these arrangements. The Contracts & Commercial department portfolio is comprised of several contracts including but Gas, Electric, Support Services & Engineering.

Contracts & Commercial has several departments including the Process and Performance department. We are responsible for developing, managing, and tracking performance on the entire contract portfolio.

The Business Systems Analyst will be the technical expert who will provide data solutions/integrations, and reports to assist in managing key performance indicators. Gaining a deep understanding of the requirements that drive business processes and performance and the reporting that enables them, he/she will conduct analyses to identify deficiencies, needs, and opportunities for improvement in our metrics and dashboards. The data for these KPIs will need to be mined from multiple databases as well as excel/csv files provided by older systems.

You will partner with members across Capital Delivery and the Contracts & Commercial organization to improve reporting strategies and systems, and provide insight and support to the Manager, Business Systems regarding business case development of business system roadmaps.

Key Accountabilities:

• Manage and develop the system to track and report on contractor performance.
• Most of our KPI programs are currently utilizing an Oracle Database accessed by SQL using Excel VBA for data collection and creating reports. We are on a road map to transfer the KPI programs from Excel to Alteryx and Tableau.
• Manage KPI process, including monitoring and reviewing inputs and producing monthly reports.
• Create the database structure, data input interfaces and the reports using an Oracle database, SQL and Excel VBA automation for older programs and develop new solutions in Alteryx and Tableau.

Storm Management – When planning for significant events, the team is responsible for procuring and processing external crews brought in to aid in the restoration. A home grown application has been developed to facilitate this process.
• Become the owner of the Storm Management System. System uses an Oracle database, SQL and Excel VBA
• Become the expert of the Storm Management System both as a developer and as a user. Continue to evolve the tools to support the Storm contract management process as it is improved.
• Troubleshoot issues during storm events and provide solutions in a potentially high stressful environment
• Support Securing Resources team during major weather events in New York & New England. Responsibilities could include procuring, processing, or tracking contractor crews.
• Develop job aids and provide training
• Storm support is required 365 days a year and may involve weekend and holiday work as needed.

Contract Management
• Understand the challenges of each contract. Suggest and develop technical solutions
• Develop, manage and provide training & support for contract management tools developed in Excel
• Create complex templates and reports in excel using SQL and advanced Excel
• Create presentations in PowerPoint and present during Contractor Quarterly Meetings

Civil Work Validation Tools – In order to validate work for payment the team developed Excel forms that are filled by the contractors and approved by the field supervisors using buttons created in VBA. The information is processed in batches and is stored in an Oracle database.
• Work with the Contract Analyst, Fie
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 85949 while calling.
 
Other jobs in MA: Boston (103), Burlington (1), Cambridge (1), Canton (3), Chelsea (9), Franklin (1), Lexington (2), Malden (10), Marlborough (2), Maynard (2), Newton (1), Quincy (6), Sharon (1), Waltham (1), Welesley (1), Wellesley (6), Westborough (1), Westbourough (1),
Excel job openings in Waltham, MA
Jobs List

Data Analyst - 69384
Create date: 16-Nov-2020
Note :6+ month contract. may go onsite so candidates need to be okay working onsite in the future local candidates strongly preferred.

Candidate must be our W2 Employee.

Job Description :

Position: Data Analyst

Location: Waltham, MA

Duration: 6+ months

Position Description:
CMDB Jobs in MA Waltham Analyst - (in Waltham, MA))

SAP Engineer - 45080
Create date: 22-Mar-2019
Job Description :

Can sit in either Syracuse, NY or Waltham, MA


Position Responsibilities (including but not limited to):
• Lead the design, development and delivery of processes/technical ERP/ BI SAP/ HANA/ Tableau solutions for National Grid supply chain.

• Provide systems support as a functional exp.... (This job is for - job Jobs in MA Waltham Engineer - (in Waltham, MA))
 
 Excel job openings in other states
Jobs List

Legal Assistant - 62306
Create date: 07-Mar-2024
Start date : 03/17/2024

End date : 08/31/2024

Submission deadline : 03/12/2024

Client info : TN DIDD

Note :

* Position Location : On Site

Description :

Ideal candidate will have the following experience and skills: Experien.... (This job is for - job Jobs in TN Knoxville Consultant - (in Knoxville, TN))

Senior Account Manager - Part-Time Accountant
Create date: 15-Nov-2023
Job Title: Client Services Senior Account Manager - Part-Time Accountant

Start date : 12/01/2023

End date :06/03/2024

Submission deadline :11/22/2023

Client info : CT OHS

Note:

* Position Location: Remote

Description : <.... (This job is for - job Jobs in CT Hartford Manager - (in Hartford, CT))

VDOT Business Continuity Planner 3 (711840)
Create date: 02-Jun-2023
Hybrid

start date :06/19/2023

End date :06/30/2023

submission deadline : 6/6/2023

client info :

Description :

-------------------------------------------
**local candidates strongly preferred
*the contract may be extended ann.... (This job is for - job Jobs in VA Richmond Developer - (in Richmond, VA))

NCDIT - Technical Specialist- Junior (707643)
Create date: 13-Apr-2023
Start date :04/01/2023
End Date :09/30/2023

Submission deadline :04/19/2023

Client Info :NCDIT

Note:
* Remote

Description :

Our company is seeking a skilled Power BI Developer with a strong background in financial modeling to join our team. As a Power BI Developer, you will be respons.... (This job is for - VBA Jobs in NC Raleigh Specialist - (in Raleigh, NC))

Accounting Technician 1 - 59975
Create date: 01-Feb-2023
Start Date : 02/27/2023
End Date : 06/30/2023

Submission Deadline : 02/14/2023

Client Info : TN DIDD


Note:
* Position Location On Site

Description :

9831 The candidate should have some accounting experience, and auditing experience is hel.... (This job is for - Spreadsheet Jobs in TN Nashville Consultant - (in Nashville, TN))
 
 Excel job openings in MA
Jobs List

ITS63 Applications Systems Analyst/Programmer -SP
Create date: 27-Apr-2021
Bid Number: BD-21-1107-1107T-TRC01-61809

Note: Online Submission
Note: Maximum number of resumes per ITS63 Vendor: No limit

Submission Deadline: 6/30/2021 12:00 PM EST
Start Date: 7/12/2021
End Date: 1/11/2022

Client: Trial Court

Description:

The Office of Court Management (OCM).... (This job is for - Visio Jobs in MA Boston Analyst - (in Boston, MA))

ITS63 FY21 (1) IT Coordinator And Reporting Analyst -SP
Create date: 22-Jan-2021
Bid Number: BD-21-1042-IT-IT001-57915

Note: Email Submission
Note: Maximum number of resumes per ITS63 Vendors: 1
Note: Total Number of Positions Sought Up to 1

Submission Deadline: 1/25/2021 03:00:00 PM
Start Date: 2/5/2021
End Date: 6/30/2021

Client: Executive Office of Energy and Environmenta.... (This job is for - job Jobs in MA Boston Analyst - (in Boston, MA))

ITS63 FY21 IT Project Coordinator And Reporting Analyst -SP
Create date: 23-Dec-2020
Bid Number: BD-21-1042-IT-IT001-57256

Note: Email Submission

Note: Maximum number of resumes per ITS63 Vendors: 2
Note: Total Number of Positions Sought: Up to 1

Submission Deadline: 12/29/2020 02:00 PM EST
Start Date: 1/11/2021
End Date: 6/30/2021

Client: Executive Office of Energy and Env.... (This job is for - Jira Jobs in MA Boston Analyst - (in Boston, MA))

Workday Integrations Consultant - 68062
Create date: 28-Sep-2020
Job Description :

Description:

• Partner with subject matter experts to understand their functional requirements

o Workday HR Core

o Workday Benefits

• Able to demonstrate critical thinking, ability to analyze and translate large amounts of data

• Must be confident to work indepe.... (This job is for - HCM Jobs in MA Boston Consultant - (in Boston, MA))

Lead Business Systems Analyst - 59480
Create date: 13-Feb-2020
Job Description :
Description: Lead Business Systems Analyst

We are looking for a Lead Business Systems Analyst for our Oral Care Solutions (OCSD) Division, located in Maplewood, MN. The position will work with cross-functional teams to create/document user-centered solutions in support of custom orthodontics.

Primary re.... (This job is for - job Jobs in MA Maplewood Analyst - (in MAPLEWOOD, MA))
(Analyst: Excel, Tableau, Database Structures, VBA in Waltham, MA)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us