BI Developer

3 weeks ago

Norfolk, United States Hampton Roads Transit Full time

Hampton Roads Transit is looking for dynamic, customer service oriented, and energetic people to become part of a committed team providing excellent and effective public transportation to the Hampton Roads region. In addition to rewarding careers and professional development opportunities, we offer unmatched benefits and competitive wages in a stimulating environment that will provide you with the flexibility and training tools to grow.


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.

  • GIS Analyst

    1 week ago

    Norfolk, United States Ardent Services Full time

    Why do you need to choose between doing important work and having a fulfilling life? At Ardent, we have both. Ardent employees are committed to solving our customers' most difficult problems-and we are committed to the well-being, personal goals, and professional development of our employee. We are "All In." We put forth our strongest effort possible to get...

  • GIS Analyst

    2 days ago

    Norfolk, United States Ardent Services Full time

    Why do you need to choose between doing important work and having a fulfilling life? At Ardent, we have both. Ardent employees are committed to solving our customers' most difficult problems-and we are committed to the well-being, personal goals, and professional development of our employee. We are "All In." We put forth our strongest effort possible to get...

  • Visual Analytics Specialist

    4 days ago

    Norfolk, United States Xylem I LLC Full time

    Job DescriptionJob DescriptionStart your career at Xylem-Kendall as a Visual Analytics Specialist!About Our Company: Xylem-Kendall is a leading provider of Vegetation Management and Utility Line Clearing Services throughout the Mid-Atlantic and Southeast United States. At Xylem, we know that our employees are the foundation of our success. Xylem-Kendall is...

  • Associate Director of Job Training

    7 days ago

    Norfolk, United States Northeast Community College Full time

    The purpose of this position is to assist the director in managing, developing, and directing the Job Training and Safety Program, which serves the Nebraska Rural Electric Association, the League of Nebraska Municipalities, the Nebraska Municipal Power Pool, and other entities. Responsibilities include but aren't limited to the following: Assist in...

  • Senior TBM Analyst

    4 weeks ago

    Norfolk, Virginia, United States Humana Full time

    Become a part of our caring community and help us put health firstManagement (TBM) cost and data model using Apptio.Create and maintain the TBM cost and data model in Apptio.Configure, test, and document Apptio and Cloudability dashboards and reports to meet functional specifications.Load, transform, and rationalize data from systems of record (e.g., General...

  • Microsoft Dynamics 365 Systems Administrator

    1 week ago

    Norfolk, United States Abacus Full time

    Job Description Position: Microsoft Dynamics 365 Systems Administrator (& Developer) Department: Technology Reports To: Director ERP Services Job Summary: The Microsoft Dynamics 365 System Administrator primary responsibility will be to provide support for the system configuration, upgrade, security administration, change management, monitoring,...

  • Microsoft Dynamics 365 Systems Administrator

    2 days ago

    Norfolk, United States Abacus Full time

    Job Description Position: Microsoft Dynamics 365 Systems Administrator (& Developer) Department: Technology Reports To: Director ERP Services Job Summary: The Microsoft Dynamics 365 System Administrator primary responsibility will be to provide support for the system configuration, upgrade, security administration, change management, monitoring,...

  • Associate Director of Job Training

    7 days ago

    Norfolk, United States Northeast Community College Full time

    The purpose of this position is to assist the director in managing, developing, and directing the Job Training and Safety Program, which serves the Nebraska Rural Electric Association, the League of Nebraska Municipalities, the Nebraska Municipal Power Pool, and other entities. Responsibilities include but aren't limited to the following: Assist in...

  • Data Visualization Analyst

    1 week ago

    Norfolk, United States Gridiron IT Full time

    Gridiron IT is seeking aData Visualization Analystto join our team. This a U.S.-based role, not eligible for visa sponsorship. Hybrid role. Must be local toNorfolk, VA,or have active plans to relocate (please include this with your application). No relocation support is available. Interim or ActiveDoD SECRET Clearanceis required. Job Description Summary:...

  • Data Visualization Analyst

    2 days ago

    Norfolk, United States Gridiron IT Full time

    Gridiron IT is seeking aData Visualization Analystto join our team. This a U.S.-based role, not eligible for visa sponsorship. Hybrid role. Must be local toNorfolk, VA,or have active plans to relocate (please include this with your application). No relocation support is available. Interim or ActiveDoD SECRET Clearanceis required. Job Description Summary:...

  • Data Analyst

    4 weeks ago

    Norfolk, United States LMI Full time

    OverviewThis position supports LMI's work with the emerging Navy Surface Maintenance Operations Center (S-MOC) in Norfolk, VA. Candidate will provide in-depth data analysis, data visualization (dashboard development) regarding fleet readiness, maintenance, etc. to our prime and client as part of a multiparty team in a dynamic environment. Dashboard expertise...

  • NSNE Electrical Engineer

    2 weeks ago

    Norfolk, United States Nucor Harris Rebar Full time

    Nucor is North America's largest recycler and most diversified steel and steel products company. Since 1969, we've led the industry in developing innovative technologies for recycling scrap into high-quality steels that are all around us, from bridges and buildings to cars and appliances.Basic Job Functions: Nucor Steel-Nebraska is a division of North...

  • NSNE Electrical Engineer

    1 week ago

    Norfolk, United States Nucor Harris Rebar Full time

    Nucor is North America's largest recycler and most diversified steel and steel products company. Since 1969, we've led the industry in developing innovative technologies for recycling scrap into high-quality steels that are all around us, from bridges and buildings to cars and appliances. Basic Job Functions: Nucor Steel-Nebraska is a division of North...

  • Analyst-Senior

    5 days ago

    Norfolk, United States SilverEdge Full time

    Overview SilverEdge is seeking a Senior level Analyst-Enterprise-wide knowledge and experience in one or more designated functional and/or concentration areas. Provides support to the customer on program/project operations. Experience developing and executing successful strategic plans. Possesses demonstrated knowledge, extensive experience in the...

  • Qualified Mental Health Professional

    1 week ago

    Norfolk, United States New Pathways Youth Services INC. Full time

    Benefits: Flexible schedule Opportunity for advancement Paid time off Training & development We are in search of licensed Qualified Mental Health Professionals- Adult/Child/Trainees' who are dedicated to working with adults, children and their families in their home or their community to provide them with training, support and resources. Job Duties will...

  • Qualified Mental Health Professional

    3 weeks ago

    Norfolk, United States New Pathways Youth Services Inc Full time

    Job DescriptionJob DescriptionBenefits:Flexible scheduleOpportunity for advancementPaid time offTraining & development We are in search of licensed Qualified Mental Health Professionals- Adult/Child/Trainees' who are dedicated to working with adults, children and their families in their home or their community to provide them with training, support and...

  • Private Investigator

    3 weeks ago

    Norfolk, United States Lemieux & Associates LLC Full time

    Job DescriptionJob DescriptionCome grow with us! Lemieux & Associates, a national leader in the investigative industry, is seeking experienced SIU/Claims Investigators in the Norfolk or surrounding area. This is a part-time position to start with the ability to turn into a full-time position for the right individual. The owners are entrepreneurial,...

  • Senior Program Analyst

    1 week ago

    Norfolk, United States SAIC Full time

    Description SAIC has an opening for aNaval Aviation Enterprise (NAE) Senior Program Analyst supporting the Current Readiness Team and Total Force Team in Norfolk, Virginia .Applicant should possess specific subject matter expertise in manning and personnel readiness across the entire process from recruitment to retirement to support CVN and Type/Model/Series...

  • Data Scientist with Security Clearance

    2 days ago

    Norfolk, United States ClearanceJobs Full time

    Overview Systems Planning and Analysis, Inc. (SPA) delivers high-impact, technical solutions to complex national security issues. With over 50 years of business expertise and consistent growth, we are known for continuous innovation for our government customers, in both the US and abroad. Our exceptionally talented team is highly collaborative in spirit and...

  • SharePoint Portal Administrator

    1 week ago

    Norfolk, United States PROSOFT Full time

    SharePoint Portal Administrator a. Manage and maintain all servers that support SharePoint deployed at USFF HQ. b. Implement and manage SharePoint features, applications, and functionalities to include: • monitor and analyze system workload daily to ensure optimum performance • provide systems reports usage and activity • move, copy or restore sites...