Snowflake DBA & Data Pipeline Specialist (Onsite)

Rose International; Chillicothe (IL); On-site; USD 48,000 - 54,000; Full time

Job summary

Rose International is seeking a Snowflake Database Administrator for an onsite, temporary role in Chillicothe, IL. The position focuses on Snowflake administration, data governance, and ETL development within a small analytics team, with modernization to a new BI framework.

The role requires strong SQL, data modeling, and experience with data pipelines, plus proficiency in Python and cloud scheduling tools such as AWS Lambda. Education includes an Associate’s degree, with a Bachelor’s preferred.

Qualifications

• Minimum: Associate’s degree in computer programming or a relevant field.
• Preferred: Bachelor’s degree.
• Internship Experience: Accepted if skills can be clearly demonstrated.

Responsibilities

• Test programs or databases, correct errors, and make necessary modifications.
• Modify existing databases and database management systems.
• Work as part of a project team to coordinate database development and determine project scope and limitations.
• Write and code logical and physical database descriptions and specify identifiers to the management system.
• Review project requests describing user needs to estimate time and cost required to accomplish the project.
• Fill the Database Administrator (DBA) role for a small analytics team (team of 6), maintaining the intended data architecture, implementing data governance, creating and managing database objects, and documenting architecture and program specific flows.
• Own end to end user access management – triage access requests, obtain approvals/denials, communicate results, grant access, and administer role based access controls to keep users accountable and compliant.
• Serve as the Data/Product Owner for multiple analytics programs and datasets, collaborating continuously with the team to ensure consistent architecture and user experience.
• Support the Analytics team’s modernization initiative, migrating from a legacy SAS central platform to a modern reporting framework.
• Coordinate, test, and implement changes to Snowflake databases, correcting errors and modifying databases/DBMS as needed.
• Author, troubleshoot, and performance tune SQL views and queries, and build/maintain data pipelines (ETL) and job orchestration (including cloud scheduling such as AWS Lambda).
• Build and improve data sets and reporting for owned programs, and support customer inquiries on available data, enhancements, and general support.
• Advise and support the data needs of Data Specialists/Scientists and report builders, and perform joint planning to avoid duplicative or conflicting outputs.

Skills

ETL

Python

Snowflake

SQL

Education

Associate’s Degree

Bachelor’s Degree

Tools

AWS Lambda

Git

Job description

Rose International is seeking a Snowflake Database Administrator for an onsite, temporary role in Chillicothe, IL. The position focuses on Snowflake administration, data governance, and ETL development within a small analytics team, with modernization to a new BI framework.

The role requires strong SQL, data modeling, and experience with data pipelines, plus proficiency in Python and cloud scheduling tools such as AWS Lambda. Education includes an Associate’s degree, with a Bachelor’s preferred.