Data Engineer And Data Analysis ResourceThis resource will support data engineer and data analysis work for the Integrated Justice System and BI Platform Modernization projects.Typical deliverables include:Creation of IT data models (e.g., conceptual, logical, physical, canonical)Implementation of data design and transformation proceduresCreation of frameworks for representing data elementsResolution of conflicts between data modelsDesign, creation, and maintenance of relational and dimensional databases and data systemsRecommendation and implementation of data reliability, efficiency, and quality improvementsEnhancements to existing database systems to increase operating efficiency or adapt newer requirementsAdherence and contribution to work plan timelines, managing workflows to meet project timeframesDesign and creation of data processing systems that combine core data sources into data repositoriesMap documentation of data elements from UI screens to database, mapping between 2 databasesData conversions, imports, and exports of data within and between internal and external systemsDevelop data migration scripts for loading data from "old" system to "new" target system(s)Develop data transformation and automation processes supporting business systems and data flowsMaintain data repositories quality by adding, modifying, and deleting data as needed and as requestedTroubleshoot data issues and data processing tools, systems, and softwareIdentify and resolve problems related to database management systemsDevelop and maintain a query library to support recurring data requestsMaintain data dictionaries and other related data processing metadataImplement statistical models to identify trends, correlations, and patterns in data setsCatalog data sourcesPerform data cleansing and filteringDesign analytical dashboards and reportsMine and analyze multiple data sets (Dimensional) for trends, insights, problems, etcDocument models, solutions, data mapping, technical specifications, data dictionaries, test cases, etc.Required skills and abilities include:Relational Database Modeling (conceptual, logical, and physical): 3+ years experienceTools: Microsoft Visual Studio, Microsoft SQL Server, Azure SQL Server, SSIS, SSRS, Power BI Report Server, Power BI Service, SSMS: 6-7 years' experienceTools: Quest Erwin or similar data modeling tool – 1 year experience
eRFO-ISD-FY25-0046 Senior Data Analyst/Data Warehouse Consultant in san jose at Unknown Company
This position is listed as full time and onsite.