Hampton Roads Transit
The successful candidate will have a wide range of data and Business Intelligence skills to develop and maintain the Hampton Roads Transit Agency Reports Library and Enterprise Data Warehouse. They will be able to execute the full Business Intelligence Development life cycle and will work closely with the Director of Enterprise Technology Solutions to create an Enterprise Business Intelligence Data Warehouse for HRT. Duties will include, but are not limited to, requirement gathering, documentation, analysis, design, ETL development, dimensional modelling, report, and dashboard creation. The successful candidate will work closely and collaborate with business stakeholders, business leaders, and subject matter experts, to understand and document the current business processes and key Agency metrics. The incumbent will work with IT staff to acquire the data, create the necessary SQL Server database structures (tables, views, stored procedures and functions), develop the ETL packages, dimensionally model the data, and build the necessary reports and dashboards for Enterprise Agency consumption via canned reports and self-service business intelligence. Tools currently used, but not limited to include, SSIS (including custom C# script tasks), SQL Server Management Studio, Tableau Online, and Tableau Public, SSRS, Excel, Web APIs, Access Databases, and Power BI. The successful candidate will be part of an agile software development team and will be responsible for taking deliverables through all phases of the Software Development Life Cycle and change management process. This position also manages the BI and Data Warehouse report data repositories, software and Servers, and supports deployment to cloud-based and enterprise environments.
Essential Job Functions: (Duties listed are not intended to be all inclusive nor to limit duties that might reasonably be assigned.)
Required Knowledge, Abilities and Skills essential to Job Functions:
Required Software Knowledge and Skills Essential to Job Functions:
Proficiency in using computer systems and the listed software applications associated with performance of assigned work is essential. Strong problem-solving skills associated with software applications used is expected.
Training and/or Education:
Bachelor’s degree in computer science, information technology, computer programming, analytics, or business. Background in databases and data reporting.
Minimum of 8+ years’ data base development including database object creation and report development experience with 3-5 years Tableau-specific experience with strong understanding of database structures, theories, principles, and practices.
Licenses or Certificates:
This position is classified as essential personnel.
Virginia Driver’s License
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Work involves meeting multiple demands on a timely basis. Duties may require some overtime. The nature of the job may require providing assistance to Enterprise Application users (primarily by phone, but occasionally in person) in the evenings and on weekends.