BI Developer - Norfolk, United States - Hampton Roads Transit

Hampton Roads Transit

Verified Company

Norfolk, United States

4 weeks ago

Posted by:

Mark Lane

beBee recruiter

Description

Essential Job Functions:
(Duties listed are not intended to be all inclusive nor to limit duties that might reasonably be assigned.)

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.
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 selfservice products.
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 multitask, 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:

Microsoft SQL Server 201
Visual Studio SQL Server Data Tools (SSIS, SSRS, SSAS as necessary)
SQL Management Studio
Tableau
Desktop 10.5 and 201
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

Safety Responsibility:

Perform all job duties and responsibilities in a safe manner to protect one's self, fellow employees, and the public from injury or harm.

Promote safety awareness and follow safety procedures and policies.

Take an active part in reporting unsafe conditions and any hazards within the workplace to their Supervisor, Manager and/or the Safety Department.

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 d