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.
Software applications:
Training and/or Education:
Bachelor’s degree in computer science, information technology, computer programming, analytics, or business. Background in databases and data reporting.
Required Experience:
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.
Special Requirements:
Virginia Driver’s License
FLSA Status:
Exempt
Physical Demands:
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.
Unusual Demands:
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.
As a Field Service Technician you will assists with on-site installations, troubleshooting, repairs, and maintenance of telecommunications products and equipment...
Apply For This JobFIND YOUR PURPOSE. JOIN OUR MISSION As one of the largest credit unions in the region and top performing in...
Apply For This Jobbr{display:none;}.css-58vpdc ul > li{margin-left:0;}.css-58vpdc li{padding:0;}]]> Background and drug screen required. Techforce is currently looking for a few Data Center Technicians....
Apply For This JobCompany Overview GovCIO is a team of transformers—people who are passionate about transforming government I.T. We believe in making a...
Apply For This Jobbr{display:none;}.css-58vpdc ul > li{margin-left:0;}.css-58vpdc li{padding:0;}]]> Description Job Description: Leidos is seeking an Enterprise Telecommunications Supervisor that will serve as the...
Apply For This JobRole: Database Developer -2 Location: CT/NC/NY – remote optional Duration: 1+ Year Design, development and enhancements of data related requirements...
Apply For This Job