BI Developer (On-Site Position)

This position opportunity is located in the Hampton Roads, VA offices and requires on-site presence.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 lifecycle 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 modeling, 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.Essential Job Functions:Strong database understanding and data programming skills.Excellent TSQL database coding skills to include stored procedures, functions, tables, views, triggers and synonym creation.Executes full business intelligence life cycle including requirements gathering, documentation, analysis, design, ETL development, dimensional modeling, report, and dashboard creation.Ability to listen to user requirements and convey messages in a clear, concise manner.Design and develop new reports and reporting solutions from requirements and from an understanding of organizational business needs in Tableau Desktop, and SSRS.Use SQL Server SSIS and SQL Management Studio to extract data from source, transform data as necessary, and create all database objects needed to store the data.Strong SSIS skills to include understanding of control flow and data flow tasks, with package auditing of data as it moves through the data pipeline. Ability to program some custom C# scripting tasks for complex assignments.Strong knowledge of all SQL Server database tasks including jobs, data backups and redundancy, database maintenance (indexing and statistics), to serve as the SQL Server backup DBA as necessary.Work closely with the SQL Server DBA on data warehouse object creation, query performance tuning, and reporting in Tableau and SSRS environments.Work closely with business owners to develop and present reports and dashboard data in a manner and stylistic flare that matches the intended audience.Manage Tableau users, permissions and groups, folders and reporting library using the Tableau Online management interface, and Tableau bridge client.Work with the DBA to configure SSRS and Tableau configuration management tools.Manage SSRS report manager including report deployment, folders and permissions.Work closely with the Web Development team to import data from custom web applications forms into the BI environment for agency report creation.Deploy reports, dashboards and stories using Tableau Online, Tableau Public, and SSRS.Work within the agile framework and follow the best practices of the software development life cycle.Assist in development of project definitions, including proposals, estimates, planning, schedules and documentation.Promote the use of self-service products.Provide support to the development of training materials and training activities related to the BI tools and applications.Strong ability to learn new skills as needed to complete assignments.Manage records created and received in compliance with the Hampton Roads Transit Records Management Policy and Procedures.Required Knowledge, Abilities and Skills essential to Job Functions:Experience developing automated reports and dashboards using Tableau Online, Tableau Public, SSRS, and Power BI.8+ years in database development experience in a BI and data warehouse environment using the full Microsoft Development stack, and Tableau reporting tools.Ability to analyze data databases and transform it to meet reporting requirements in relational and dimensional form.Ability to plan, organize and manage multiple tasks during normal agile sprint environment.Excellent customer service skills required to relate to a large range of business users and gather requirements to present data in formats relative to the audience.Demonstrated proficiency in extracting data from and analyzing data in relational database systems – specifically SQL Server, Oracle RDBMS, MySQL, flat files, and API calls.Experience with data modeling both relational and dimensional, ETL development, and TSQL database programming skills required.Ability to communicate effectively with different levels of management and within the business administrative, maintenance, functional and technical communities.Ability to multi-task, troubleshoot and solve problems quickly and completely.Ability to effectively prioritize and execute tasking to deploy useful solutions to the production environment.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:Microsoft SQL Server 2017SQL Management StudioTableauDesktop 10.5 and 2019.3Tableau Management Tool and Bridge ClientMicrosoft Office

TeamsPlannerExcelAccess DatabaseVisioPowerPoint

Power BI helpful, but not requiredTraining 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:Possess a valid Driver's License. Acquire a Virginia Driver's License within 60 days after the date of hire (in instances when an out of state license is not the applicant's current state of residence).FLSA Status:ExemptPhysical 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.

#J-18808-Ljbffr