Cyber Security Programmer Analyst 5

This role is on the CIP Data Analytics Program (CDAP) Team which is responsible for producing a variety of processes, applications, and reports to support DTMB - Cybersecurity & Infrastructure Protection. The CDAP Team deliverables support data migration, automation and analytics that enable leaders to assess cyber threats, comprehend risk exposure, and direct staff on priorities and risk mitigation across the State of Michigan's IT investment in over 20,000+ servers, 80,000+ workstations, mobile devices, etc. The ideal candidate is very strong in PowerBI, Power Automate, Power Apps, and SQL Server. This candidate should also be comfortable with Microsoft Office Suite in general (OneNote, SharePoint, etc.) Some experience in .Net and Python is preferred.

Primary responsibilities:

Actively participate and collaborate with the CIP Data Analytics Program (CDAP) team and others.

Contribute to the development of standards including user interface design, information architecture, naming conventions, labeling, etc.

Consume audience requirements and translate those into prototypes and/or wireframe designs.

Design, develop and implement the delivery mechanisms, including but not limited to, O365 Integration (SharePoint, Teams, etc.), PDF tools/integration, Power Platform tools, etc.

Develop necessary and agreed upon documentation and artifacts to support the CIP Data Analytics Program (CDAP) in an operational state.

Power BI Report development, and specifically the presentation layer, filtering, and measures with a firm understanding of underlying data architecture concepts.

Some ability to read and modify .Net and Python scripts is preferred.

Desired Experience:

PowerBI Expert Level

Power Automate/Power Apps Intermediate

SQL Server Intermediate

MS Forms/SharePoint Makers Beginner

Must have previous experience with Power Apps/Platforms