Senior Data Architect at Radiant Digital

Job Description About UsAt Radiant Digital we empower organizations worldwide with innovative IT and consulting solutions that drive efficiency agility and impact. From federal agencies like NASA and the USDA to leaders in telecom healthcare and energy we help transform challenges into opportunities through technology.Job Description:Position : Senior Data Architect Fisheries Data Systems (CDFW)Location : Sacramento California : hybridPOSITION SUMMARY:We are seeking a Senior Data Architect with direct experience supporting or modernizing Department of Fish and Wildlife (DFW) data systems preferably the Aquatic Surveys Program (ASP) Survey Management Switchboard (SMS) or related fisheries monitoring databases by supplying domain expertise in SQL architecture legacy Access applications lookup table management validation logic and data migration processes.Key ResponsibilitiesThe candidate will contribute to all areas required including:1. SQL Architecture & Legacy System InterpretationAnalyze and interpret schema structures for ASP SMS and related legacy systems.Identify data normalization issues lookup table dependencies key relationships and schema inconsistencies.Provide guidance on schema updates linking tables and structures needed to support CMP population data.2. Data Migration Strategy & Quality ManagementDefine requirements for migrating MS Access CSV Excel and text file datasets into a modern SQL environment.Identify data validation cleansing and transformation requirements aligned with CDFW SOPs.Provide clear migration pathways consistent with business problems and objectives stated in the RFI.3. Data Entry Batch Upload and QA/QC ModelRecommend SQL-backed mechanisms for real-time validation batch upload error handling and reconciliation processes.Translate CDFW workflows into structured technical requirements for Attachment A.4. Web Application Data Services (Custom or COTS Alignment)Support evaluation of COTS vs. custom approaches by mapping data architecture requirements to proposed options.Identify integration requirements (REST APIs ETL workflows middleware).5. Security User Access and Hosting InsightProvide recommendations aligned with role-based access models described in Exhibit 1.Suggest data-layer security controls that align with California SIMM NIST and state hosting expectations.Required Experience & SkillsDirect experience working for or supporting CDFW NOAA PSMFC or related fisheries/environmental data programs.Experience with ASP database structure distributed Access applications SMS lookup tables and SQL Server environments.Expertise in MS SQL Server stored procedures constraints indexing strategies schema design and optimization.Experience modernizing Access-to-SQL systems and managing version control transitions.Familiarity with CMP data collection workflows salmonid monitoring terminology and field-to-database SOPs.Knowledge of data validation rules QA/QC workflows and error reduction strategies used in scientific datasets.Preferred ExperienceExperience working with California state data governance and information security standards.Familiarity with schema-driven mobile form generation and field data synchronization.Experience with ETL tools (SSIS Azure Data Factory Informatica) or API-based integration methods.Education RequirementsBachelors degree in Computer Science Information Systems Data Engineering or related field required.Masters degree preferred (Data Science Information Technology or Environmental Informatics).Required Experience:Senior IC Key Skills Fund Management,Drafting,End User Support,Infrastructure,Airlines,Catia Employment Type : Contract Experience: years Vacancy: 1 Hourly Salary Salary: 65 - 70