- 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 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 ...
-
Intel / Opfor Developer
1 week 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 · - ...
-
Data Intelligence Developer
5 days 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 ...
-
Salesforce Developer/administrator
2 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. ...
-
Golang Backend Developer
1 week 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 ...
-
Senior Backend Software Developer
2 weeks 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 ...
-
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 ...
-
Peoplesoft Developer
6 days ago
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 ...
-
Peoplesoft Developer
1 week 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 ...
-
Excel Developer
5 days 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
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 ...
-
Appian Developer
1 week 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 ...
-
Software Developer
19 hours ago
California Medical Systems Newport Beach, United StatesRequirements: 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 ...
-
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 ...
-
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 ...
-
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 ...
-
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, ...
-
Program Director
2 weeks ago
Exceptional People Plus, LLC Norfolk, United StatesJob 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 ...
-
Manager of Visitor Marketing
1 week ago
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 ...
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.)