Job Description

Dashboard/Integration Developer

Primary Tool: particularly focusing on tools like ServiceNow (Or equivalent) Software for asset management, process standardization, and dashboard development
• Database Tools: SQL, APIs, ETL Tools (e.g., Informatica, Talend)
• Visualization Tools: Recommended Software Reporting, Power BI (if external visualization is required)
• Form Tools: Recommended Software Form Builder or third-party digital form solutions
• Process Tools: BPMN (Business Process Model and Notation) or equivalent process-mapping tools

Preferred Skills:
• Recommended Software Asset Management Expertise
• Experience in implementing and customizing Recommended Software (Example: ServiceNow) Asset Management modules.
• Knowledge of CMDB (Configuration Management Database) for asset tracking and integration.
• Proficiency in workflows, reporting, and automation.
• Recommended Software Dashboard Development
• Skills in building dynamic dashboards with data visualization features such as heat maps.
• Knowledge of integrating real-time data from external databases into software.
• Expertise in implementing drill-down menus and query-based search functionalities.
• Expertise in integrating Product Software with external databases like WebEOR, SEAM, and OSL via APIs, ETL tools, or data connectors.
• Proficiency in data cleaning, transformation, and consolidation from multiple sources.
• Skills in ensuring data integrity and consistency across systems.
• Strong knowledge of database systems, including SQL and non-SQL databases
• Experience with database integration and querying tools
• Expertise in using ETL (Extract, Transform, Load) tools to connect and process data between systems.
• Proficiency in ensuring real-time data synchronization. "

Day-to-day Responsibilities:

Part 1: Identify and recommend skilled professionals / teams
Targeted talent Proficiencies:
• Asset data integration, dashboard development, and workflow design.
• Tools such as ServiceNow, SQL, And ETL for real-time data management and integration.
• Standardization of processes and form redesign, ensuring compliance with USPS policies.

Part 2: Asset Management System
Data Integration:
• Collect, clean, and consolidate asset data from WebEOR, SEAM, and OSL databases.
• Ensure real-time synchronization of data for accurate and up-to-date asset tracking.

Dashboard Development:
o Design and implement a user-friendly dashboard featuring:
• Heat Map: Visualize asset distribution across the United States, with a legend for easy interpretation (e.g., regional asset density, color-coded by type).
• Query Search Function: Enable users to search for assets using keywords and apply filters.
• Drill-Down Menu: Allow users to refine searches by location, asset type, ownership, status, or other criteria.
• Interactive Selection: Include an interactive selection system (Buttons) to filter by asset type (MPE, Systems, …).
• Asset Detail Display: Once an asset type is selected the dashboard must display a detailed list of the selected assets and their relevant details.
o Include export and reporting functionality for analyzed data.

Dashboard Maintenance:
• Daily Maintenance:
- Monitor data synchronization to ensure real-time updates are reflected accurately.
- Perform error checks and address discrepancies in asset data promptly.
- Verify system uptime and respond to any performance issues.

• Weekly Maintenance:
- Review user access logs and ensure compliance with role-based access controls.
- Conduct minor updates or bug fixes as required.
- Evaluate dashboard performance metrics for optimization opportunities.

• Monthly Maintenance:
- Perform a comprehensive audit of data accuracy across integrated systems (WebEOR, SEAM, OSL).
- Update asset categories or filters based on organizational changes or new requirements.
- Provide a summary report of dashboard usage and performance to stakeholders.

• Yearly Maintenance:
- Conduct a full-scale review and update of the dashboard's features and functionalities.
- Reassess integration workflows for improvements or necessary overhauls.
- Schedule and execute training refreshers for end-users to ensure ongoing proficiency. "

Expected Deliverables:
Part 1 (Technical Resources):
1. Integration of recruited professionals into USPS workflows, ensuring seamless collaboration.
2. Documentation of knowledge sharing plans for USPS teams
3. A team of qualified talent aligned with USPS’s technical and operational requirements

Part 2(Work Output):
4.Fully operational asset management dashboards with:
• United States heat map visualization.
• Search and query functionality with a drill-down menu.
• Integrated data from WebEOR, SEAM, and OSL.

5. Standardized forms template and associated documentation.
6. Comprehensive workflow