Job Description
Job Description
Responsibilities :
Seeking a Senior 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(s) 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.
- 7 years of overall experience with 5 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 environmentExtensive Microsoft SQL experienceExperience 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 ServicesReporting Tool : SSRS, SQL Server Reporting Services (SSRS), Power BI, TableauDuties and Responsibilities :
Provide support for design, development, testing, and deployment activities for acomprehensive 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 DetailData Integration and TransformationThe 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 DesignImplement 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 ReportsDevelop 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 TypesAd-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 ReportingDevelop 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
