- 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.
-
BI Developer
1 week 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 ...
-
Data Intelligence Developer
2 weeks ago
TowneBank Norfolk, United StatesThe 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 ...
-
Intel / Opfor Developer
2 weeks ago
Prevailance, Inc Norfolk, United StatesPrevailance 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 · - ...
-
Application Developer
3 days ago
Herdt Consulting Inc Norfolk, United States**Company: Herdt Consulting, Inc.** · **Responsibilities include but are not limited to**: · - The developer should have a strong knowledge of web development best practices, security standards and user interface design. · **Basic Qualifications**: · - 3+ years in multiple SAP di ...
-
Powerapp Developer
4 days ago
DLH Norfolk, United States**About Us** · DLH delivers improved health and national security readiness solutions for federal programs through science research and development, systems engineering and integration, and digital transformation. Our experts in public health, performance evaluation, and health o ...
-
Salesforce Developer/administrator
3 weeks ago
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. ...
-
Business Development Representative
5 days ago
Safe Harbor Recovery Center Portsmouth, United StatesBusiness Development Representative - Local | Safe Harbor Recovery Center | Portsmouth, VirginiaAbout the Job: · PURPOSE STATEMENT: · The Business Development Representative is responsible for growing the facility's lines of service and levels of care as defined by management by ...
-
Business Development Associate
4 days ago
TALON Portsmouth, United States**Please note**: this position requires the ability to work at our office in Portsmouth, NH full-time (5 days a week). · **Overview** · TALON is looking for a Business Development Associate to join our Broker Market Sales team. Work directly with our Chief Channel Officer to lear ...
-
Golang Backend Developer
3 weeks ago
Spectrum Innovations Chesapeake Beach, United StatesAbout 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 ...
-
Didlake, Inc. Norfolk, United StatesStarting pay $47,195 · The Coordinator for the Workforce Support and Development program will carry out the key components of the program by conducting intakes, assessments, writing Employee Support Plans (ESP), and training Supervisors on how to use the Employee Support Plan as ...
-
Software Full Stack Developer
1 week ago
Service Credit Union Portsmouth, United StatesService Credit Union is seeking a Software **Full Stack Developer - Architect** where you will be responsible for working on both front-end and back-end systems, including web UI development, and integrating data sources with Fiserv core banking systems through REST APIs. Your ro ...
-
Associate Director, Business Development
1 week ago
Lonza Portsmouth, United StatesUnited States, Portsmouth (New Hampshire)Today, Lonza is a global leader in life sciences operating across three continents. While we work in science, there's no magic formula to how we do it. Our greatest scientific solution is talented people working together, devising ideas th ...
-
Senior Backend Software Developer
3 days ago
Cascade Innovations Chesapeake, United StatesAbout 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 ...
-
Agilyx Portsmouth, United StatesAre you ready to pioneer the future of sustainable technology? Agilyx is seeking a dynamic Director of Supply Chain and Contract Development to support the company's mission in providing innovative technology and integrated solutions to the chemical recycling industry and address ...
-
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 ...
-
Business Developer
2 weeks 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 ...
-
Peoplesoft Developer
2 weeks ago
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 ...
-
Appian Developer
2 weeks ago
Purple Drive Solution Newport Beach, United StatesSkill: 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 ...
-
Excel Developer
2 weeks ago
Brillius Newport Beach, United StatesPosition: 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 ...
-
Peoplesoft Developer
3 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 ...
BI Developer - Norfolk, United States - Hampton Roads Transit
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.)
