SQL Data Analyst

logo

SQL Data Analyst

Cloud Big Data Technologies

icon Miami, FL, US, 33128

icon18 May 2024

Apply Now

Role : SQL Data Analyst

Location : MIAMI,FL

Duration : 6 Months

Rate : $40/hr On C2C (Not Nagotiable)

Job Description :

The IT Consultant will be responsible for all aspects of development and implementation, including design, programming, testing, and configuration. Design requirements will be provided to the vendor following an agile development methodology. Vendors must employ industry best practices for technology project management. The vendor will work as needed with the stakeholders to complete task orders. In addition, the vendor must be capable of developing systems and applications for the .net and java platforms.

The vendors guidance should assist Campus Shield's Intelligence Functions Campus Shield Data Cube will function as the intelligence umbrella for the security and protection of students and staff. Data Cube will collect, store, and analyze criminal intelligence information--while also disseminating actionable information that supports safety in and around schools. Currently has systems that collect information such as a Records Management Systems (RMS), Computer-Aided Dispatch (CAD) file, and the Mobile Field Reporting (MFR) system.

Integrate key intelligence systems with those already deployed in company, Campus Shield personnel will have the ability to collate, and disseminate information to improve safety and climate.
Effectively integrate data from RMS, CAD, and MFR along with data from other law enforcement agencies (including local, county. federal and state), visitor access and video surveillance records.
Integrate with the Blackboard Connect System, student records, and social media.
Data Cube will provide intelligence identifying criminal patterns or trends, suspects and criminal enterprises, and other safety issues via continuous, real-time, comprehensive predictive analysis of the collected intelligence from a variety of systems.
These data should facilitate the identification of potential threats and also lead to sharing of important information. This sharing will include fusion centers that focus on the southeast Florida region the county.
An effective system with enterprise-wide capability for facilitating response for emerging situations and provide linkages between them and other safety systems. Capable of disseminating actionable intelligence.

Model Specifications:

Microsoft Unified Dimensional Model
Cube schemas in a multi-organizational environment
Measures and dimension levels off the cubes schema
Dimensional tables
Hybrid ROLAP/MOLAP deployment

Required Skillset:
ARC GIS
API
C#.NET
WEB API
ENTITY FRAMEWORK
HTML 5
CSS
Angular Bootstrap
Java
JavaScript
Transact-SQL
SSIS
SRSS
MDX

OS Platform
o Server
o Windows Server 2012 R2

Internet Information Services 8.5
Share Point
Microsoft SQL Server 2012 R2

WEB SOLUTION that works on all modern browsers
o Fire Fox
o Safari
o Chrome
o Internet Explorer

Ability to generate reports
o Export to Excel

Client Development Software
o MicroSoft Visual Studio
o Experienced with MicroSoft Team Foundation Server
o Microsoft Analysis Services
o Microsoft SQL Server Business Intelligence
o SQL Server Development Studio
o Microsoft Reporting Services

 

Equal Opportunity Employer

Cloud Big Data Technologies is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. Cloud Big Data Technologies will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will Cloud Big Data Technologies require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract
Apply Now