Recent Searches

You haven't searched anything yet.

2 BI Developer (On-Site Position) Jobs in Norfolk, VA

SET JOB ALERT
Details...
Hampton Roads Transit
Norfolk, VA | Full Time
$91k-116k (estimate)
3 Weeks Ago
CGS Federal
Norfolk, VA | Full Time
$91k-116k (estimate)
3 Weeks Ago
BI Developer (On-Site Position)
$91k-116k (estimate)
Full Time | Transportation 3 Weeks Ago
Save

Hampton Roads Transit is Hiring a BI Developer (On-Site Position) Near Norfolk, VA

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. 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.)

  • 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 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

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 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:

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.

Job Summary

JOB TYPE

Full Time

INDUSTRY

Transportation

SALARY

$91k-116k (estimate)

POST DATE

05/22/2024

EXPIRATION DATE

07/20/2024

WEBSITE

gohrt.com

HEADQUARTERS

NORFOLK, VA

SIZE

500 - 1,000

FOUNDED

1999

TYPE

Private

CEO

W RANDY WRIGHT

REVENUE

$50M - $200M

INDUSTRY

Transportation

Show more

Hampton Roads Transit
Full Time
$68k-85k (estimate)
Just Posted
Hampton Roads Transit
Full Time
$56k-66k (estimate)
1 Week Ago

The job skills required for BI Developer (On-Site Position) include BI, Business Intelligence, SQL, Analysis, Data Warehouse, Tableau, etc. Having related job skills and expertise will give you an advantage when applying to be a BI Developer (On-Site Position). That makes you unique and can impact how much salary you can get paid. Below are job openings related to skills required by BI Developer (On-Site Position). Select any job title you are interested in and start to search job requirements.

For the skill of  BI
Esvee Technologies Inc
Full Time
$96k-123k (estimate)
3 Days Ago
For the skill of  Business Intelligence
Swift Strategic Solutions Inc
Full Time
$59k-89k (estimate)
2 Days Ago
For the skill of  SQL
Accroid Inc
Contractor
$105k-126k (estimate)
3 Weeks Ago
Show more

The following is the career advancement route for BI Developer (On-Site Position) positions, which can be used as a reference in future career path planning. As a BI Developer (On-Site Position), it can be promoted into senior positions as a Business Intelligence Specialist IV that are expected to handle more key tasks, people in this role will get a higher salary paid than an ordinary BI Developer (On-Site Position). You can explore the career advancement for a BI Developer (On-Site Position) below and select your interested title to get hiring information.

CGS Federal
Full Time
$91k-116k (estimate)
3 Weeks Ago

If you are interested in becoming a BI Developer, you need to understand the job requirements and the detailed related responsibilities. Of course, a good educational background and an applicable major will also help in job hunting. Below are some tips on how to become a BI Developer for your reference.

Step 1: Understand the job description and responsibilities of an Accountant.

Quotes from people on BI Developer job description and responsibilities

From planning projects to developing software, BI developers have an array of job roles and responsibilities which require a broad set of skills.

01/25/2022: Jamestown, NY

BI developer can be analyzing all sorts of data – past, current, or future/predictive.

04/09/2022: Anderson, IN

Creates an ultimate solution for business data visualization.

04/09/2022: Parkersburg, WV

BI developers are responsible for building OLAP, or online analytical processing.

02/22/2022: Bellingham, WA

Also apply data mining algorithms and create and design tables.

03/28/2022: Phoenix, AZ

Step 2: Knowing the best tips for becoming an Accountant can help you explore the needs of the position and prepare for the job-related knowledge well ahead of time.

Career tips from people on BI Developer jobs

Hiring managers typically look for BI developers who have received some formal training in the field.

04/02/2022: Richland, WA

Hold at least a bachelor’s degree in computer science, math, statistics, physics, or a related field, although this isn’t a prerequisite for working in business intelligence.

04/04/2022: Atlantic City, NJ

Learn the necessary programming languages.

02/19/2022: San Francisco, CA

Certifications such as those offered by TDWI, or vendor-specific certifications offered by Oracle, Microsoft, and IBM can help set job applicants apart.

02/19/2022: Biloxi, MS

To get a leg-up on the competition, consider earning business intelligence certifications.

01/30/2022: Queens Village, NY

Step 3: View the best colleges and universities for BI Developer.

Butler University
Carroll College
Cooper Union
High Point University
Princeton University
Providence College
Show more