Database & Data Warehouse Specialist II

State of Ohio; Columbus (OH); On-site; USD 55,000 - 83,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Tuition reimbursement

Health and wellness programs

Work-life balance initiatives

Career advancement opportunities

Job summary

The Ohio Department of Taxation is seeking a Database Administration Specialist 2 in the Information Technology Division to design, implement, and support ELT pipelines and data warehouse environments using SQL Server, Snowflake, Python, and SAS.

You will provide Tier II database support, assist in BI design and reporting, and collaborate with leadership to meet enterprise needs while ensuring data integrity and security. The position is located at Northland, Columbus, OH, with full-time hours.

Qualifications

• 60 months combined work experience in performance tuning, configuration, data modeling, and Tier II database support.
• 12 months work experience in the primary technology specified by the agency in the position description.
• Completion of associate core program in computer science or information systems; or 42 months combined work experience in the required areas; or undergraduate CS/IS core program with matching experience.

Responsibilities

• Design, develop, test, implement, and support ELT code using Python, SQL, Snowflake, StreamSets, AWS Glue and SAS.
• Perform data migrations and design monitoring solutions; support development, UAT, performance and production environments.
• Implement high-availability and disaster-resilient solutions across multiple data warehouse and reporting environments.
• Monitor load balancing and tune system parameters to optimize performance for databases (SQL Server, Oracle, Snowflake).
• Provide Tier II support for database and ELT issues, including performance, availability, data integrity, and security.
• Define and support Data Warehouse BI designs; assist in implementing Data Warehouses and data marts.
• Build and support enterprise reporting, dashboards, scorecards, and analytic applications.
• Develop and maintain documentation, including installation procedures, monitoring guides, security policies, configuration changes, and migration processes.
• Collaborate with leadership to design solutions that meet enterprise requirements and evolving business needs.
• Create, monitor, and resolve trouble tickets with timely remediation progress.

Skills

Python

SQL

Snowflake

StreamSets

AWS Glue

SAS

SQL Server

Oracle

Education

Associate degree in computer science or information systems

Undergraduate core program in computer science or information systems

Tools

SQL Server

Oracle

Snowflake

Job description

The Ohio Department of Taxation is seeking a Database Administration Specialist 2 in the Information Technology Division to design, implement, and support ELT pipelines and data warehouse environments using SQL Server, Snowflake, Python, and SAS.

You will provide Tier II database support, assist in BI design and reporting, and collaborate with leadership to meet enterprise needs while ensuring data integrity and security. The position is located at Northland, Columbus, OH, with full-time hours.