Application Developer, Advanced Technology (Senior)

Role: Application Developer, Advanced Technology (Senior)

Location: Baltimore, MD 21202 --- Hybrid (2 Days in office and 3 days remote)

Duration: 12 Months Contracts

Duties/Responsibilities:

The Senior Application Developer is expected to provide web-based programming support (including modifications analytical, testing and payment services). Perform various tasks including defect fixing, designing, coding, testing new enhancements, and generating ad hoc reports and queries.

Education:

Bachelor s degree in computer science, Information Technology, or a related field. (Years of demonstrated experience will be considered in lieu of a bachelor's degree).

General Experience:

• Experience generating ad hoc reports and queries. Examples are: Scheduled Reports: Automatically generated and distributed reports based on predefined schedules.
  • Ad-hoc Reports: User-generated reports created on demand, supporting real-time data queries and insights.
  • Drilldown Dashboards: Interactive dashboards with drilldown capabilities to explore data at various levels of detail.

Specialized Experience:

• • Knowledge of Structured Query Language (SQL) and Stored Procedures with at least five (5) years of hands-on experience, consecutively.
  • Knowledge of using HTTPS with at least five (5) years of experience, consecutively.

Preferred Experience:

• Evidence of using each of the above specialized experience within the last five (5) years, consecutively.

Scope of Work:

The scope of this work includes support for design, development, testing, and deployment activities for a comprehensive reporting module. The module will consist of the following components:

• Scheduled Reports: Automatically generated and distributed reports based on predefined schedules.
• Ad-hoc Reports: User-generated reports created on demand, supporting real-time data queries and insights.
• Drilldown Dashboards: Interactive dashboards with drill-down capabilities to explore data at various levels of detail.

Data Integration and Transformation.

• The reporting module must integrate with existing data sources, including structured, semi- structured, and unstructured data.
• Support for ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) processes, allowing efficient data extraction, transformation, and loading.
• The system should handle large volumes of data, providing quick access and insights.

Report Design.

• Implement a drag-and-drop interface for report creation, allowing users to design reports easily.
• Include visual elements such as graphs, charts, widgets, and maps to enhance report readability and impact.
• Support both static and dynamic images, animations, and filters within reports.
• Ensure reports are pixel-perfect, reflecting the intended design accurately.
• Allow data filtering based on key performance indicators (KPIs) for targeted insights.
• Interactive Dashboards and Reports.
• Develop interactive dashboards that allow users to manipulate data, perform queries, and personalize their views.
• Include features for automated reporting, reducing the need for manual report distribution.
• Ensure dashboards and reports are responsive and adaptable to various devices, including mobile.

Report Types

• Ad-hoc Reports: Enable users to create reports on-the-fly, particularly for fast-paced environments like social media analytics and financial analysis.
• Scheduled Reports: Generate and distribute reports at predefined intervals, following a set format.
• Pivot Tables: Provide tools to summarize and analyze large datasets efficiently.
• Crosstab Reports: Display relationships between multiple variables in a matrix format.
• Informational Reports: Present data metrics as-is, offering a unified view of information.
• Analytical Reports: Provide insights, interpretations, and recommendations based on selected data.
• Transactional Reports: Capture and display detailed information about customer interactions.

Mobile BI Reporting

• Develop mobile-compatible reporting applications with user-friendly interfaces and responsive dashboards.
• Include collaboration features within mobile reports, supporting teamwork regardless of location.
• Implement push notifications, alerts, and offline mode capabilities to enhance productivity for remote users.
• Ensure robust security measures are in place to protect sensitive data.