Position Summary Minimum years of experience (check off accordingly for billing):
7-9 Years 10 + Years
Functional Title POWER BI REPORT DEVELOPER
Solicitation/Contract Title MTA Business Process Transformation
Number of positions: 1
Duration in months: 12
Reports to MTA Division and Unit: DOS ENTERPRISE ASSET MANAGEMENT
Reports to Project Manager: CORY SAVORY, SEBASTIAN CACERES
Work Location (full street address): 2 BROADWAY, NY, NY 10004
HYBRID ROLE, 4 days on SITE with 1 day working from home
Days & Hours of Work: 40 hours per week
Desired Start Date: OCTOBER 2024
Critical Key Requirements
- A minimum of 5-7 years experience in using Microsoft's Power BI analytics software.
- Preferable 1-2 years working experience with Railroad/Transit industry
- Preferable 3-4 years hands-on experience with enterprise data analysis.
- Strong analytical and problem-solving skills
Summary Of The Function/Role
The Enterprise Asset Management Department of the NYCT – Department of Subways (DOS) is seeking One (1) temporary consultant to serve as a Power BI report developer.
This position is to provide critical HxGN EAM sustainment support for DOS Enterprise Asset Management (EAM) needs.
Responsibilities
- Support DOS Enterprise Asset Management (EAM) sustainment efforts, with a focus on the scoping of BI solution sessions with business lines to capture business objectives and prioritize opportunities.
- This position will play a primary role in the sustainment of the existing Power BI solutions under the management of the DOS EAM Department, with a focus on availability and maintenance as needs arise.
- Under the direction of the Report Development Lead, extract transform and load data, using SQL.
- Support the scoping of BI solution sessions with business lines to capture business objectives and prioritize opportunities
- Create mock-up reports for proof-of-concept reviews.
- Support and develop activities related to end-to-end data lifecycle management, including the review of data loads for accuracy and completeness.
- Support DOS Business lead in developing system reporting solutions based on business needs.
- Support DOS Business lead in creating, validating, executing and documenting test cases
- Assist in the development of end-user training and reference materials
- Perform or assist in end-user training
- Assist in implementation go-live and post-go-live activities
- Support requests from users to research system problems or errors, and to assist in their resolution
RISKS (required by MTA Risk Management)
- Describe the type of work consultant: Desk work only
- Whether any work will be performed within 50 feet of track right-of-way (yes or no) NO
- Whether the work may involve areas with environmental risks (lead, asbestos) -- substantial or minimal (yes or no). NO
DELIVERABLES & DUE DATES
- Support HxGN integration with Power BI solutions.
- Configure Power BI to communicate valuable information to business lines.
Qualifications Experience & Education
- Minimum 5 years HxGN EAM (or other EAM/enterprise data management software)
experience.
- Minimum 5 years of IT related experience
- Minimum of 2 years of experience developing and implementing Power BI solutions, including modelling, design, development and testing of data visualization or paginated report solutions
- Proficiency in Data Analysis (DAX), M, ETL (Power Query), SQL (or data extraction and integration tools) and performance optimization
- Strong ability to work on multiple initiatives simultaneously and work within tight deadlines
- Microsoft Power BI certifications or Azure certifications are an asset
- Experience working in an Agile project delivery model is an asset
- Understanding of complex relational database organization, design, and functionality.
- Ability to communicate clearly in conversation and in presentations to both technical and non-technical staff and to provide updates to all levels of management and stakeholders
- Ability to effectively prioritize and execute in a high-pressure environment
- Ability to independently set priorities and meet deadlines in a fast-paced environment, a self-starter
- Excellent inter-personal skills including the ability to work with individuals at all levels of the organization