END ABUSE Mission: END ABUSE promotes social change that transforms societal attitudes, practices and policies to prevent and eliminate domestic violence, abuse and oppression.
Lethality Assessment Program Web-Based Database Developer
End Domestic Abuse Wisconsin: the WI Coalition Against Domestic Violence
Are you a technology wizard with the desire to create social change? Do you have experience with databases that help analyze and solve complicated social problems? If you answered yes to these questions, this is the project for you!
End Domestic Abuse Wisconsin is searching for an experienced database developer with some background working with non-profits or social science research to develop a Domestic Violence Homicide Prevention – Lethality Assessment Program Database.
The Homicide Prevention Program at End Domestic Abuse Wisconsin collects data on domestic violence homicides that happen in our state as well as data from jurisdictions around Wisconsin that are implementing an evidence-based homicide prevention strategy called the Lethality Assessment Program - Maryland Model (LAP). This project will streamline the process for how data gets submitted to us from law enforcement and domestic violence programs. The collection of lethality assessment data will allow us to measure the impact of our efforts over time. This analysis will be critical to helping us prevent domestic violence homicides throughout Wisconsin.
Scope of Work
Website should have a landing page with the ability for users to login with an email and password
Programs and Law Enforcement will have the ability to log in to input data as needed
End Abuse staff will have administrative access to maintain user security, as well as to access reporting functions of the database
Tables should be designed to make data as granular as possible.
Reports will be run with filters including but not limited to County, City, Date, and Lethality factors
Must be able to perform summary statistical analysis on all data. Crosstabs would also be nice. Must have an import/export function for excel tables, .csv files. For imports, variable in database must match categories selected on excel form (prototype(s) will be provided).
Would also like a Dashboard that represents current data from each month – could alert End Abuse when # of screens are lower than previous months, etc. Would require database to perform trend analysis in real time.
Other needs may arise which will be discussed collaboratively as the project is developed.
Production of a database with a user-friendly format, that is also capable of sophisticated data analysis and report production before the end of Summer 2018.
A custom website that utilizes a login portal, which will allow users to input data into the created database and administrators to run reports from that data.
Expected Timeline and Consultation
The database must be operational within one to two months of start date. We expect the project to take no more than 120-160 hours to complete.
Consultation is required with End Domestic Abuse Wisconsin’s Technology Coordinator, Homicide Prevention Program Director, and the Policy and Systems Analyst.
Further details with be negotiated and specified in the mutually agreed upon independent contractor agreement.
Expected Pay Range
The pay range for this project will be $4,000-$6,000 at project completion, commensurate with experience. Costs for project start-up will be negotiated in the independent contractor agreement.
Contractual Terms and Conditions
Once a candidate has been selected, the candidate will work with the point of contact and LAP Database project team to develop a mutually agreed upon independent contractor agreement.
Project’s Expected Start Date: June 11, 2018
Proposal Requirements and Applicant Qualifications
All interested candidates must include a resume and an example of recently completed project(s). Evidence of completion for a similar web-based database is preferred but multiple submissions showing a breadth of experience will be considered
Project submission(s) should show experience with website development as well as database development
All interested candidates must also include a brief cover letter explaining why you want to work on this project, as well as a description of what tools and/or software you intend to use to complete this project.
Experience in Project management, either through project example or work experience
Knowledge of web-based language(s) and database programming such as HTML, CSS, PHP/JAVA and MySQL, or other programming language.
Knowledge of building custom sites with WordPress or other software
Knowledge of website hosting, design, and management
Experience translating stated problems and needs into efficient and scalable database design.
Experience working with non-profit organizations, and/or social science research projects.
Proposal Evaluation and Contract Award Process
Proposals are due by 5pm on Monday, May 21, 2018
Proposals evaluated by the Homicide Prevention Program Director, Technology Coordinator, and Policy and Systems Analyst.
The most qualified applicants will be notified by Friday, June 1, 2018. If necessary, in-person interviews may be scheduled for the following week.
Prospective Project Start Date: June 11, 2018
Point of Contact
Please direct questions about your application or the project to Angie Trudell Vasquez, Operations Coordinator at email@example.com, or 608-255-0539 x 303.
Applicants should send a current resume, cover letter, and example of recent database and/or website development work to firstname.lastname@example.org.
Applications that are missing any of the materials listed above will not be considered.
All applications must be submitted by no later than Monday, May 21 for full consideration.