Skills Matrix
Skill
Years Used
Last Used
3 Years: Experience with Azure Data Factory as an ETL tool
3 Years: Experience with MS Dataverse is Required
3 Years: Experience with MS SSIS
3 Years: Proven track record of solving real world problems using data. Excellent critical thinking skills is a must have for this role.
3 Years: Bachelor’s Degree or equivalent in a technology related field (e.g. Computer Science, Engineering, etc.) with a focus on data analysis, data structu
3 Years: Outstanding interpersonal and communication skills and experience collaborating and influencing across all levels of the organization.
3 Years: Understanding of different database platforms: Oracle, SQL Server (On-Prem / Azure), DB2, and MS Access.
3 Years: Excellent communication skills including written, verbal, and technology illustrations.
3 Years: Understanding of Data Warehousing and data mining.
3 Years: Understanding of modeling strategies (dimensional, snowflake, relational, unstructured).
3 Years: Experience designing and delivering data mapping specifications for large reporting platforms. Writing and maintaining business rules using SQL logic
3 Years: Demonstrated experience in writing ad-hoc SQL statements
3 Years: Strong interest in playing a technical data steward role across our business and technology partners to understand and detail our data, appropriate
3 Years: Proven experience with ERD/Data Modelling tools (Toad or others).
3 Years: Experience in executing projects in an Agile / Hybrid environment
3 Years: Ability to challenge the legacy design and seek opportunities to design better models and better code.
3 Years: Demonstrated technical ability in learning new technologies and adapting to frequent changes in the technical environment
3 Years: Ability to look at data in various formats, organize data for the agency to meet the needs of unique program areas and enable the programs to effect
3 Years: Experience with architecting, designing, and administering Azure SQL Database
3 Years: Experience with data reporting tools (Power BI, others)
3 Years: Experience conceptualizing and visualizing data structures before they are drawn.
3 Years: Experience migrating data from various legacy platforms
3 Years: Experience leading a small team of developers using Agile
3 Years: Experience with Business Intelligence development with Azure Analysis Services
3 Years: Experience designing and developing technical queries that produce exact search requests
3 Years: Experience designing and developing technical queries that produce exact search requests
3 Years: Experience translating data into simple business terms and formatted to fit an enterprise model