Senior Business / Data AnalystThe Senior Business / Data Analyst will provide analysis leadership on several complex data analysis projects with diverse scopes across the DEQ enterprise. The DEQ enterprise is a complex and multi-platform data environment. Your objective will be to assist a wide variety of DEQ program managers and environmental engineers to understand, identify, and document the critical data they collect and manage. In addition, you will provide the insight to other data analysts, data architect, and application developers to create an enterprise data model that meets the business and technical requirements. This enterprise data model will serve as the foundation for modern DEQ solutions.Skill - Required / Desired - Amount - of ExperienceBachelor’s Degree or equivalent in a technology related field (e.g.
Computer Science, Engineering, etc.) with a focus on data analysis, data structu - Required - 3 - YearsProven track record of solving real world problems using data. Excellent critical thinking skills is a must have for this role. - Required - 3 - YearsOutstanding interpersonal and communication skills and experience collaborating and influencing across all levels of the organization. - Required - 3 - YearsExcellent communication skills including written, verbal, and technology illustrations. - Required - 3 - YearsUnderstanding of different database platforms: Oracle, SQL Server (On-Prem / Azure), DB2, and MS Access.
- Required - 3 - YearsUnderstanding of Data Warehousing and data mining. - Required - 3 - YearsUnderstanding of modeling strategies (dimensional, snowflake, relational, unstructured). - Required - 3 - YearsExperience designing and delivering data mapping specifications for large reporting platforms. Writing and maintaining business rules using SQL logic - Required - 3 - YearsDemonstrated experience in writing ad-hoc SQL statements - Required - 3 - YearsProven experience with ERD/Data Modelling tools (Toad or others). - Required - 3 - YearsExperience in executing projects in an Agile / Hybrid environment - Required - 3 - YearsExperience with MS Dynamics Dataverse is a plus.
- Required - 3 - YearsAbility to challenge the legacy design and seek opportunities to design better models and better code. - Required - 3 - YearsDemonstrated technical ability in learning new technologies and adapting to frequent changes in the technical environment - Required - 3 - YearsExperience with data reporting tools (Power BI, others) - Required - 3 - YearsExperience migrating data from various legacy platforms - Required - 3 - YearsExperience conceptualizing and visualizing data structures before they are drawn.