Apply on Employer Site

State of Missouri · 1 day ago

Senior Data Specialist #1999022

Jefferson City, MO

Full-time

Onsite

Senior Level, Lead/Staff

9+ years exp

The State of Missouri is seeking a Senior Data Specialist to join their Office of Administration, Information Technology Services Division (ITSD). This role focuses on architecting, configuring, analyzing, and maintaining data structures, while also designing solutions to integrate data between on-premises and cloud technologies.

AgricultureGovernmentInformation Technology

No H1B

Responsibilities

Primarily responsible for architecting, configuring, analyzing, and maintaining data structures

Design and implement solutions to integrate data between on-premises and cloud technologies

Learn and demonstrate software products and prototype functionality to stakeholders

Create, adhere to, and advise team members of best practices, standards, and methodologies

Support the integration of enterprise application databases and real-time processing into the data warehouse

Responsible for the full life cycle development, implementation, support, architecture and tuning of databases, data warehouses, and data pipelines

Write technical policies, procedures, and documentation for the systems, including data flow diagrams, architecture diagrams, etc

Effectively prioritize and execute tasks in a high-pressure environment using Agile methodology

Mentor database team members

Critical thinking and problem-solving skills

Develop and maintain ETL processes using Microsoft SSIS and SQL agent jobs

Develop and support complex stored procedures and custom functions

Familiar with Azure DevOps and Agile development concepts

Knowledge of data warehousing, data architecture, and design concepts with practical experience in the implementation of these concepts

Be self-motivated and have the desire to continually develop new skills and improve existing skills

Strong written and verbal communication skills and organization skills

Qualification

Database developmentData architectureETL processesMicrosoft SSISAzure DevOpsAgile methodologyTechnical documentationCritical thinkingProblem-solvingCommunication skillsOrganizational skills

Required

Authorization to work in the United States is a prerequisite of employment

Minimum 9 years in IT industry with emphasis in database development and architecture