BI Developer (On-Site Position)
Hampton Roads Transit
- Norfolk, VA
- Permanent
- Full-time
- 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.
- 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.
- Microsoft SQL Server 2017
- Visual Studio SQL Server Data Tools (SSIS, SSRS, SSAS as necessary)
- SQL Management Studio
- Tableau
- Desktop 10.5 and 2019.3
- Tableau Online
- Tableau Public
- Tableau Management Tool and Bridge Client
- Microsoft Office
- Teams
- Planner
- Excel
- Access Database
- Visio
- PowerPoint
- Power BI helpful, but not required