The primary purpose of this position is to develop modernized, scalable efficient data management systems that serves the North Carolina Community College System. This position will work within the Data Management and Integration team to design, deploy and integrate processes that extract, transform, load data into a data warehouse and to create reporting frameworks for data that is collected from multiple sources that include all 58 community colleges and other state and local agencies. The position will use knowledge, creative thinking, scientific/statistical methods, processes, and algorithms to create a data infrastructure that supports business intelligence and advanced analytics.

The analyst will need to be adept at using data to find opportunities for product/process efficiency and using models to simulate outcomes of different courses of action. The analyst will have training and experience using a variety of data extraction tools, using/creating methods that address data quality and to build analytical reports and dashboards. The position will collaborate with business to integrate and improve data quality and reporting systems and will require advanced use of business intelligence and reporting software.

The Applications Systems Analyst must have excellent written and verbal communication skills for coordinating across teams, giving presentations to audiences of varying sizes and facilitating meetings. The position will require strong critical thinking and problem-solving skills paired with an ability to communicate complex ideas to non-technical users.

KNOWLEDGE/SKILLS/AND ABILITIES

• Knowledge of one or more programming language including SQL, Python, SAS and R.
• Knowledge of BI and analytics, and experience visualizing/presenting data for stakeholders using at least one of the following: SAS,Tableau, Microsoft PowerBI, Entrinsik Informer, etc.
• Knowledge of database management system (DBMS) physical implementation, including tables, joins and SQL querying.
• Ability to collaborate with others; including providing support and/or cross-training to others team members.
• Advanced experience with MS Office 365 Suite (Excel, Visio, Skype, SharePoint, and Teams).
• Knowledge of security protocols for systems utilized.
• Knowledge of structured data, such as entities, classes, hierarchies, relationships and metadata.
• Ability to effectively communicate and convey technical/complex ideas in written and oral form with users/stakeholders and executive management.
• Ability to work well autonomously, within teams, and lead focused efforts to establish effective working relationships and to produce successful outcomes.
• Ability to organize and implement a variety of both short- and long-term projects and initiatives.
• Ability to understand current architecture of systems and assist with troubleshooting problems.
• Understanding of the business functions and system needs of unit to develop working specifications for technical solutions.

PREFERENCES:

• Agile/Scrum methodology knowledge.
• Experience querying databases and using statistical models and machine learning languages in at least two of the following: R, Python, SQL.
• Experience with ServiceNow or similar ITSM solution.
• Ability to work collaboratively with people from diverse backgrounds.