Expert Application Developer

Responsibilities:
Seeking an Expert Application Developer to support our state client with a custom-built system. The consultant is expected to provide web-based programming support (including modifications analytical, testing and payment services). Consultant 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 will also supporting a Mobile App that provides accessibility to claimants and employers and is available in iOS and Android platforms.
Qualifications:
Education and Years of Experience: 

• Bachelor’s degree in computer science, Information Technology, or a related field.
• 10 years of overall experience with 8 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:

• Mastery of software development methodologies, advanced problem-solving skills, and deep expertise in multiple programming languages and frameworks.
• Leads complex software development projects.
• Designs and architects high-performance, scalable applications.
• Provides strategic guidance on technology selection and best practices.
• Conducts code reviews and ensures adherence to security and compliance standards.
• Mentors and guides senior and junior developers.
• Acts as a subject matter expert (SME) and may lead development teams.
• Makes high-level technical decisions and contributes to overall IT strategy.
• 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

 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, semi[1]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