Senior Application Developer

DMI is a leading global provider of digital services working at the intersection of public and private sectors. With broad capabilities across IT managed services, cybersecurity, cloud migration and application development, DMI provides on-site and remote support to clients within governments, healthcare, financial services, transportation, manufacturing, and other critical infrastructure sectors. DMI has grown to over 2,100+ employees globally and has been continually recognized as a Top Workplace in both regional and national categories.

DMI is seeking several Senior Application Developers to support our state client with a custom-built system. The consultant(s) are expected to provide web-based programming support (including modifications analytical, testing and payment services). You will perform various tasks including defect fixing, designing, coding, testing new enhancements, and generating ad hoc reports and queries. The system has three major public facing application components, namely, the Claimant Portal, the Employer portal, and Third Party Agents (TPAs). The consultant(s) will also supporting a Mobile App that provides accessibility to claimants and employers and is available in iOS and Android platforms.

Duties and Responsibilities:

Provide 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 Detail
• Data Integration and Transformation
• The reporting module must integrate with existing data sources, including structured, semistructured, 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

Education and Years of Experience:

• Bachelor's degree in computer science, Information Technology, or a related field.
• 8+ years of overall experience with 6+ years working with the technologies required

Required and Desired Skills/Certifications:

• Extensive experience in programming in C#
• Recent experience with projects developed in an Azure Cloud environment
• Extensive Microsoft SQL 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.

Additional Requirements:

• 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.
• Evidence of using each of the above specialized experience within the last five (5) years.

• Preferred ETL tools: Microsoft SQL Server Integration Services

• Reporting Tool: SSRS, SQL Server Reporting Services (SSRS), Power BI, Tableau

Min Citizenship Status Required: H 1B

Physical Requirements: No Physical requirement needed for this position.

Location:100 S. Charles Street, Baltimore, MD 21202/ Hybrid