Job TitleJob DescriptionAt least 3-5 years' experience with Microsoft Office Suite BasicsAdvanced Excel experience including pivot tables, formulas, macros, and conditional formattingCreating data visualizations using Power BIUsing DAX formulas to create calculated columns in Power BIUsing Power Automate to write and/or transfer dataCreating/Using MS Forms to capture data or related software is preferableExperience in development using Red Hat OpenShift, Java, Angular, HTML, SharePoint, Power BI, PowerApps is a plusExperience in SQLSummary of the Function/RoleThis position is to perform detailed spreadsheet analysis for the purpose of statistical decision making, and support Director Data Information and Analysis needs. The Security Data Analyst will directly log, analyze, code, transform, and visualize agency data using Microsoft Office 365 applications and other 3rd party database applications.ResponsibilitiesAnalyse sources of data for usable informationInput data from available sources into relevant fieldsCode data into groups that provide insightsTransform data into actionable informationMaintain records as requested by Director Data Information and AnalysisAnalyse data to identify trends and notable changesDevelop visual representations of quantitative and qualitative dataDevelop dashboards that automatically represent key dataEnsures security of system and integrity of master documents by implementing document and system access rights and revision controlsEnsures company complies with applicable laws and regulations regarding data security and document managementLiaise with IT systems experts on hardware and software issues that affect the availability and accessibility of content management systems