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 Business Analyst 5 - 135502 Create date: 30-Sep-2024 Posting title* : Lansing, MI - IT - DTMB - CTO - Network - Business Analyst 5 No of Submissions : 1 Start date : 10/21/2024 End Date : 1 Years from projected start date Submission deadline : 10/7/2024 10:00:00 AM Client Info : Network Note: * - Interviews: 1st round.... (This job is for - job Jobs in MI Lansing Analyst - (in Lansing, MI)) Business Analyst -132347 Create date: 03-Jul-2024 No of Submissions : 2 Start date : 07/29/2024 End Date : At least 3 Years from projected start date Submission deadline : July 11th at 3 PM CST Client Info : Job Service Note: * Interviews: Virtual (Teams) with camera on * 100% Remote - Candidate must live in the US and e.... (This job is for - CBAP Jobs in ND Bismark Analyst - (in Bismark, ND)) 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))    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)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)