As part of the OnCall Analytics team, you will contribute to the creation and enhancement of our OnCall Analytics suite of products, a comprehensive public safety analytics suite that gives more users the tools they need to unlock their data and turn it into invaluable insights.
As a suite of public safety data visualization and analytics products, HxGN OnCall Analytics creates a single source of truth all users can explore, analyze, and share.
It quickly turns raw, fragmented data into knowledge, enabling agencies to respond more effectively to incidents and major events.
As part of the OnCall Analytics team, you will contribute to the creation and enhancement of our OnCall Analytics product lines.
Your responsibilities will include :
Participating in the development of Analytics solutions using agile methodologies
Design and implement efficient data warehouse
Creating and deploying semantic layers
Creating and deploying Reports
Optimizing database performance
Support database administration, including database archiving, specific data integrity issues, troubleshooting, performance improvements and general system administration;
Creating cloud offerings of the OnCall Analytics Solution (optional)
Provide ad-hoc analytics support and activities in a collaborative work environment
Working with other analytical teams across the business to learn and share best practice.
Bachelor’s or Master's degree in a technical discipline computer systems or information systems desired;
4-6 years of experience in ETL Development
Advanced analytical and technical skills;
Experience working in a Windows client-server environment;
Experience with Oracle or SQL server, preferably on mid to large sized installations;
Experience with data warehousing and dimensional modelling concepts
Experience programming with Microsoft SQL Server SSIS, SSAS
Ability to design and develop logical and physical data flow models for ETL applications.
Ability to design and develop semantic layers and dimensional models for complex BI projects
Excellent communications skills, both oral and written;
Ability to work independently and as part of a team;
Experience creating Software as a Service solutions is an asset
Knowledge of other Business Intelligence or Analytic products is an asset.