Benefits:

Dental insurance

Health insurance

Paid time off

Domain experience preference: payment modules for insurance systems

Location: 100 S. Charles Street, Baltimore, MD. This is a hybrid role, 2 days in office 3 days work from home. Candidates must live within a commutable distance of Baltimore, MD.

Key Skills:

.Net, C#, Azure Cloud Services, SQL, Stored Procedures, Experience with HTTPS, ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) processes, Interactive Dashboards and Reports,

Background:

The BEACON System is built on a custom framework that is based on Microsoft .NET and hosted on Microsoft Azure Cloud

Services (Azure) cloud platform. The front-end language used is C#. The back-end database for BEACON is Microsoft SQL

server. BEACON interfaces with various state, federal and private entities (like banks) via File based and Web Service based

interfaces. There are various state agencies that can access BEACON via the Partner portal to review UI data.

Job Description:

Provide support for design, development, testing, and deployment activities for a comprehensive reporting module.

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.

• Knowledge of using HTTPS with at least five (5) years of experience.

Preferred Experience:

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

Job Duties:

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 drilldown capabilities to explore data at various levels of

1.1. Data Integration and Transformation

1.1.1. The reporting module must integrate with existing data sources, including structured, semi-

structured, and

unstructured data.

1.1.2. Support for ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) processes,

allowing efficient data

extraction, transformation, and loading.

1.1.3. The system should handle large volumes of data, providing quick access and insights.

1.2. Report Design

1.2.1. Implement a drag-and-drop interface for report creation, allowing users to design reports easily.

1.2.2. Include visual elements such as graphs, charts, widgets, and maps to enhance report readability and

impact.

1.2.3. Support both static and dynamic images, animations, and filters within reports.

1.2.4. Ensure reports are pixel-perfect, reflecting the intended design accurately.

Detail

1.2.5. Allow data filtering based on key performance indicators (KPIs) for targeted insights.

1.3. Interactive Dashboards and Reports

1.3.1. Develop interactive dashboards that allow users to manipulate data, perform queries, and personalize

their views.

1.3.2. Include features for automated reporting, reducing the need for manual report distribution.

1.3.3. Ensure dashboards and reports are responsive and adaptable to various devices, including mobile.

1.4. Report Types

1.4.1. Ad-hoc Reports: Enable users to create reports on-the-fly, particularly for fast-paced environments

like social

media analytics and financial analysis.

1.4.2. Scheduled Reports: Generate and distribute reports at predefined intervals, following a set format.

1.4.3. Pivot Tables: Provide tools to summarize and analyze large datasets efficiently.

1.4.4. Crosstab Reports: Display relationships between multiple variables in a matrix format.

1.4.5. Informational Reports: Present data metrics as-is, offering a unified view of information.

1.4.6. Analytical Reports: Provide insights, interpretations, and recommendations based on selected data.

1.4.7. Transactional Reports: Capture and display detailed information about customer interactions.

1.5. Mobile BI Reporting

1.5.1. Develop mobile-compatible reporting applications with user-friendly interfaces and responsive dashboards.

1.5.2. Include collaboration features within mobile reports, supporting teamwork regardless of location.

1.5.3. Implement push notifications, alerts, and offline mode capabilities to enhance productivity for remote users.

1.5.4. Ensure robust security measures are in place to protect sensitive data.

Flexible work from home options available.