Jobs
>
Norfolk

    BI Developer - Norfolk, United States - Hampton Roads Transit

    Default job background
    Technology / Internet
    Description

    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.

  • Hampton Roads Transit

    BI Developer

    1 day ago


    Hampton Roads Transit Norfolk, United States

    **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, function ...


  • Prevailance, Inc Norfolk, United States

    Prevailance is seeking an experienced, mission-focused professional to be an Intel / OPFOR Developer in support of U.S. Fleet Forces (USFF). · **Requirements**: · **Qualifications**: · - Minimum of ten (10) years of Navy Fleet Intelligence and/or Joint intelligence experience · - ...


  • TowneBank Norfolk, United States

    The Data Intelligence Developer will be responsible for driving the evolution of TowneBank's centralized reporting function. They should be proficient in Power BI and help to drive the most efficient technical usage of Power BI along with consistent visualization. Putting togethe ...


  • Spino Inc Portsmouth, United States

    **Job Title: Senior CRM Analyst** · **Location: Portsmouth, NH** · **Job Type: Full-Time** · **Industry: Energy Sector** · **NOTE**: · - Our client is looking to hire someone with a high level of CRM experience (especially **Salesforce**) coupled with Energy Industry experience. ...


  • Spectrum Innovations Chesapeake Beach, United States

    About the Company · The company is a leading player in the financial sector, specializing in capital market technologies and digital and cryptocurrency services. With offices in several European cities, it offers a dynamic work environment that prioritizes innovation and customer ...


  • Cascade Innovations Chesapeake, United States

    About the Company · We are a team of over 200 people with diverse interests and skills. We come from different countries and speak various dialects. But one thing unites us all: our passion for technology and marketing. · As a Senior Backend Developer (m/f/d), you love the archit ...

  • Ruppert Landscape Maintenance

    Business Developer

    6 days ago


    Ruppert Landscape Maintenance Yorktown, United States

    · Position at Ruppert Landscape Maintenance · Business Developer - Landscape Maintenance · Ruppert Landscape is a well-respected and highly regarded commercial landscape management and installation company. Headquartered in a state-of-the-art LEED-certified campus in Montgomer ...


  • Eclipse Technologies St. Pauls, NC, United States Freelance

    **Our secret to success: simply lower the hierarchies.** · **Manager (m/f/d) Development Cockpit, Mounting Carrier & Dashboard**: · - **Reference number**: J · - **Entry level**: Management · - **Location**: Weissach · - **Company**: Dr. Ing. h.c. F. Porsche AG · **Responsibilit ...


  • RM Dream Homes Pvt. Ltd. Newport Beach, United States

    **Title: PeopleSoft Technical Developer** · **Location: Newport Beach, CA** · **Duration: Full-Time** · **Skill: PeopleSoft Technical/Developer** · Roles and Responsibility: · - Work on ITSM tool - Service Now. · - Daily Operations - Solving L2 / L3 level tickets. · - Technical G ...


  • LFT LLC. Newport Beach, United States

    **Role: PeopleSoft Developer** · **Location : Newport Beach, CA Onsite** · **Duration: Fulltime** · Skill: PeopleSoft Technical/Developer · **Roles and Responsibility**: · - Work on ITSM tool - Service Now. · - Daily Operations - Solving L2 / L3 level tickets. · - Technical Gap A ...

  • Brillius

    Excel Developer

    5 days ago


    Brillius Newport Beach, United States

    Position: Excel Developer · Location : Newport Beach, CA · Duration : Long Term · Key responsibilities: · Typical end-users have intermediate MS Excel/Excel VBA skills and require assistance adding advanced functionality to their workbooks. · You will be located in the Front Offi ...

  • ProIT Inc.

    Peoplesoft Developer

    2 weeks ago


    ProIT Inc. Newport Beach, United States

    **Full-Time with TCS (Tata Consultancy Services)** · **GreenCard / US Citizens can apply** · **Skill: PeopleSoft Technical/Developer** · **Roles and Responsibility**: · - Work on ITSM tool - Service Now. · - Daily Operations - Solving L2 / L3 level tickets. · - Technical Gap Asse ...

  • Purple Drive Solution

    Appian Developer

    1 week ago


    Purple Drive Solution Newport Beach, United States

    Skill: Appian Developer · Minimum 6 to 8 years of experience in Appian platform. · Experience in automating business workflows using Appian. · Translate and build the functional requirement into Appian business flows. · Independently deliver Appian based solution. · Involved in g ...

  • California Medical Systems

    Software Developer

    19 hours ago


    California Medical Systems Newport Beach, United States

    Requirements: Master's degree in Computer Science, Computer Engineering, Electrical Engineering, or a related field plus 3 months of experience in the job offered or a related position. Skills/knowledge in Entity Framework,.NET Framework, Microsoft Visual Studio, C#, WPF, Microso ...

  • PenSoft

    Developer

    1 week ago


    PenSoft Newport News, United States

    _**Full-stack web developer**_ · **About us** · Peninsula Software of Virginia, Inc. (PenSoft) manufactures payroll software designed specifically to help small to mid-sized businesses and payroll service providers process virtually any payroll and related tax requirements faster ...

  • DEFTEC Corporation

    Program Coordinator

    19 hours ago


    DEFTEC Corporation Norfolk, United States

    **Program Coordinator** · DEFTEC delivers mission-critical solutions through skillfully delivered services and innovative products. Our clients' critical missions inspire us, and we are driven to provide the most effective solutions to execute their missions, operational challeng ...

  • Ascension Episcopal Day School

    Preschool Teacher

    1 week ago


    Ascension Episcopal Day School Norfolk, United States

    **Summary** · **Ascension Day School **serves children ages 6 weeks thru 5 years. Our program is designed to cultivate the cognitive, social, physical, creative, and emotional development of each child in a caring educational environment**. **The Assistant Teacher will be respons ...

  • Hampton Roads Transit

    Safety Specialist

    2 weeks ago


    Hampton Roads Transit Norfolk, United States

    **Salary Range: $64,146 - $81,786** · The Safety Specialist is responsible for hazard management, safety training, safety data acquisition and analysis, facility inspections and emergency management. This position develops curricula for safety training, conducts safety training, ...

  • Exceptional People Plus, LLC

    Program Director

    2 weeks ago


    Exceptional People Plus, LLC Norfolk, United States

    Job Overview: · We are seeking a highly motivated and experienced Program Director to join our team. The Program Director will be responsible for overseeing the development, implementation, and management of our programs. This role requires strong leadership skills, as well as ex ...


  • City of Norfolk, VA Norfolk, United States

    **Description**: · The City of Norfolk's Slover is currently seeking a Manager of Visitor Marketing. This position develops and implements annual market plan to generate visitation. Meets with potential advertising representatives and purchases local, regional and national print ...