Senior Developer at Rose International
Jefferson City, MO 65109
About the Job
**Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.**
Skills Required
•The contractor would be considered a senior-level developer who can deal with complex and ambiguous scenarios.
•Prior experience working with Client and Client Data Reporting.
•At least 10 years of development experience with Visual Studio 2015 -2022.
•At least 10 years of development experience with C#, VB.NET, CSS, HTML 5, Bootstrap, JQuery and SQL Server Analysis Services (SSAS), which includes Cube and Dimension modeling.
•At least 1 year development experience with Esri ArcGIS javascript API for mapping
•At least five years of combined development experience within Visual Studio Team Services (VSTS) and Azure DevOps (ADO).
•At least ten years of development experience with Microsoft .NET Framework, where 3 of those total years are utilizing 4.6+
Project Goals and Objectives:
The goal of this Client is to provide expansion and enhancement support, assistance, and knowledge transfer as needed for the Client system, including systems that are integrated with Client if applicable.
Deliverables:
LIST OF DELIVERABLES:
•Client was built using the bridged-race categories from the Client. We have learned that the bridged-race line of population estimates will be coming to an end. The contractor must create a tool to modify the new race categories within Client, including a Multiple Race category that must be available. It is unclear if we will have access to a single year of age estimates with the new race. If not, changes to the customization tool for age will also be needed. This modification will affect all Client and Profiles and may require re-loading old files using the new race definition.
•The contractor must include data from the 2022 Client of Profiles. While the basic framework is in place based on past Client surveys, new questions will need to be added. In addition, the Comparisons Profile will need to be modified so that data from 2022 can be compared in one table with past results from 2011 and/or 2016.
•The contractor must implement changes related to the hospital discharge surveillance system. Currently, the Client tool can’t load data using ICD-10 codes/categories. The transition from ICD-9 to ICD-10 occurred in 2016, so an update to keep that system relevant is very much needed. A new user interface for these 2 Client is needed that will allow data from 2016 forward to be displayed.
•The contractor must provide adaptations to the Community Data Profiles (which are more report-like, as opposed to the customizable tables of Client) will also be needed for indicators that use hospital discharge data. Ten of the 20 Profiles maintained by Client include at least some hospital discharge indicators, and in total, there would be approximately 100 indicators that would require some modifications.
•The contractor must provide addition of new indicators related to both birth defects and Client related hospital/ER indicators that cannot be updated without modifications by Client. This includes adding birth defects for city-level geographies.
•The contractor must provide graphics and mapping functionality related to Client enhancements to meet new user needs. The current graphing does not allow for much customization with the graphics titles, and the current titles are often confusing or even misleading. We also wish to make graphics easier to download and provide additional download options.
•The contractor must provide software updates to allow for manual editing of titles. It can often be difficult to decipher the data contained in the graphics with the current information displayed.
•The contractor must develop an updated save query function. The current save query option does not provide any flexibility to revise your saved query to account for a new year of data or a change in geography. We need the tool to allow for modifications so that you aren’t just re-creating the exact query but can adjust for new user needs.
•The contractor must provide an updated Preventable Hospitalizations Client to meet recently updated criteria.
•The contractor must create an ability for users to save customized geographic groupings within Client.
•The current system times out after twenty (20) minutes with no activity by the user. The contractor must update the setting within Client to one (1) hour.
•The contractor must create a ‘Show State Totals’ check box that appears for every available geography on Client.
•The contractor must edit the conditional logic to make exceptions to the current ordering methodology for pie charts. Age, month, and year should not be ordered from highest to lowest.
•The contractor must provide a new customized grouping for population-based Client so that age groups are the same as those used in age-adjusting calculations.
•The contractor must provide a new feature to allow for column sorting for 1x1 tables in Client.
•The contractor must update the reports to freeze the column and row headers so that by scrolling through the table, the user can still easily determine what the count/rate represents.
•The contractor must update the Birth Client to allow for additional variables, such as Gestational Age, that are configured as optional.
•The contractor must provide a new drug overdose indicator(s) to several Profiles, including ER and Leading Causes of Death.
•The contractor must address ICD-10 issues described in #3 so that Client Asthma and Myocardial Infarction data from 2016 forward can be displayed.
•The contractor must synchronize the Client data with the data available through the Client Data Explorer. Data published on Client does not always agree with the data we provide to the CDC for publication on their Data Explorer due to changes over the years in how the data are calculated. This two-portal data mismatch can cause data confusion for users. Potentially create a new Client data generation and storage method to remove the data disagreements that occur when Client data definitions are changed or updated.
•The contractor must provide updated mapping and graphing functionality to Client Air Quality, Water Quality, and COPD. The Air Quality, Water Quality, and COPD queries weren’t built like the other Client queries in Client and used an API to pull data from Client rather than an internal database.
•The contractor must provide new content to Client, such as Housing, Poverty, Heat-Related Illness, Cold-Related Illness, Radon, and Private Well Water queries.
•The contractor must provide new indicators to current Client content, such as the addition of blood lead levels by birth cohort to the blood lead content area.
•The contractor must provide updates to allow for the user to sort table columns.
•The contractor must add the ability to dynamically query and display multiple data sources simultaneously.
•The contractor must add new race categories to Client as described in #1.
•The contractor must provide recordings of all Cubes and Dimensions. Provide a detailed knowledge transfer, including any necessary written documentation.
•The contractor must provide an infrastructure diagram of the Client environment.
•The contractor must provide specifications of the Client environment adherent to the Vendor Product Documentation_Template_Final 3-2024, that is included.
•The contractor must scan the application to ensure there are no Veracode security vulnerabilities; it must score 90 or higher with no Critical or High findings.
•The contractor must ensure the application meets the State of Missouri’s accessibility standards.
Benefits:
For information and details on employment benefits offered with this position, please visit here .Should you have any questions / concerns, please contact our HR Department via our secure website .
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer.All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender(expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law.Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).