Our team of data modeling experts has been helping states manage NIBRS data with Crime Insight Reporting (formerly known as Crime Perspective) since 2004. Crime Insight is built upon our combined expertise in crime statistics, UCR, NIBRS, data modeling and statistical analysis.
In recognizing significant architectural deficiencies in most state repository systems, Beyond 20/20 added the Repository to Crime Insight in 2013 to make crime data collection and management easier and more useful.
By housing the data in a multi-dimensional structure and pairing it with well-designed, user-friendly interfaces, far more detailed, relevant, complex and efficient analysis becomes possible with Crime Insight.
Why work at Beyond 20/20?
At Beyond 20/20, you’ll be solving interesting problems and have the opportunity to help develop products you can be proud of. We offer competitive salaries and an incredible benefits package.
As an industry leader, we work hard to keep it that way – which means we strongly value both reliability and innovation. It’s a good balance that’s reflected in our office culture and in the people who work here. You’ll find the Beyond 20/20 team to be friendly, productive, and professionally supportive.
Located between Little Italy and the Glebe near Dow’s Lake, our office is easy to get to by public transit, bike or car, and we’re walking distance to terrific restaurants and cafés. (A good thing, because we’re always keen to try a new place to eat.)
If you’re interested in applying to one of the positions listed below, kindly submit your CV and cover letter to firstname.lastname@example.org. We will contact qualified applicants.
About Beyond 20/20
Beyond 20/20 is a software and systems company providing comprehensive data aggregation and transformation solutions. Our primary focus is the collection and analysis of crime data. Our clients are American State Uniform Crime Reporting programs, who collect crime data from the hundreds of police departments within the state, process the information, and pass it on to the FBI.
Our Crime Insight product is the accepted leader in this market for State Repository systems, providing the tools for state agencies to collect and validate crime data submissions and manage the process overall. Crime Insight is primarily a database application, with ETL tools for processing and managing files, along with an OLAP data model for reporting and analysis. There are also two web applications used to interact with the system.
Senior SQL Server Developer
If you love developing databases, solving interesting problems, and pushing technical boundaries, then we have a great opportunity for you!
We are looking for a Senior SQL Server Developer with an expert level knowledge of SQL Server databases, architecture, standards, programming, and optimization techniques. The successful candidate will build and maintain data flows and related processes, continually striving to optimize the product, increase automation, and improve usability.
As Senior SQL Server Developer, you will be expected to:
- Meet programming standards by following production, productivity, quality, and customer-service standards, identifying work process improvements, and implementing new technology.
- Contribute to leading technology decisions, including how products and features should be designed and developed.
- Participate in discussions to understand requirements and estimate development effort.
- Work through all levels of the software development life cycle, from analysis and prototyping, to implementation and support.
- Create, maintain and optimize stored procedures, databases and ETL processes.
- Contribute to or produce relevant documentation as required, including data migration procedures.
Required Skills and Experience
- Bachelor or Master’s degree in Computer Science or related field
- 7+ years of SQL programming experience
- 7+ years of database design and architecture experience
- Expert knowledge of SQL Server component services (SSIS, SSAS, SSRS)
- Experience troubleshooting and resolving database integrity issues, performance issues, security issues, etc.
- Experience with ETL methodologies, and the software development life cycle (SDLC).
- SQL Server database administration services.
- Experience writing complex data migration procedures.
- Experience importing and exporting data from non-SQL data sources such as Excel or delimited flat files.
- Experience using Visual Studio.
- Knowledge of Agile/Scrum
- XML and REST
- C#, VB application development experience