Quick Overview
Seniority
Mid Senior
Work mode
Hybrid
Location
Chillicothe, IL, United States
Posted
Yesterday
OracleSQLSQL ServerAWSETLSnowflakeTableauData PipelineGitPower BIPython
Job Description
Hello,
Hope you are doing well.
I came across your resume on a job portal, and your background appears to be a strong match for an exciting opportunity we are currently hiring for.
Position - Snowflake Database Administrator
Location: Chillicothe, IL
Duration - 12+ Months
Must-Have skills.
- 3+ years in the highlighted skill set
- Snowflake Database Administration – implementing, debugging/troubleshooting/ tracing, and issue resolution
- Data Governance and Architecture – design, implementation, and documentation
- Strong SQL – query/view authoring, troubleshooting, and performance tuning
- Data Pipeline / ETL Development – building and maintaining pipelines and job orchestration (including cloud scheduling like AWS Lambda)
- Python – scripting and automation
- Role-based Access Controls – administering user access and permissions
- Version Control Systems – using Git and participating in code review processes
- Documentation – of architecture and program specific flows
- Strong verbal and written communication
- Customer service and stakeholder orientation
- Independent time management and self direction
- Cross team collaboration and joint planning
- Attention to detail
- Associate’s degree in computer programming or a relevant field
Nice-to-Have Skills
- Bachelor’s degree in Information Technology, Management Information Systems, Computer Science, or a related discipline
- Bachelor’s degree
- BI tooling – Power BI and/or Tableau
- SAS familiarity
- Non Snowflake source integration – DB2, Oracle, Teradata, SQL Server, NAS, SharePoint
- Snowflake cost and storage optimization – warehouse sizing, compute/storage tuning
- GitHub Copilot / Agentic AI experience
- LeanIX – architecture and dependency cataloging
- Comfort with ambiguity during transition and modernization
- Ownership mindset
- Documentation and knowledge transfer discipline
- Mentoring and peer support skills
Description
The main function of this role is to coordinate changes to computer databases (specifically Snowflake), test and implement database changes, and apply knowledge of database management systems. The role involves planning, coordinating, and implementing security measures to safeguard the database.
Key Responsibilities
--
Regards,
Pooja Shikha
+1-
- 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.
- Part of the Strategic Procurement and Planning Division (SPPD), which has re organized to highlight the importance of Data Services.
- The Digital Business Insights team is modernizing its technology stack to develop a sustainable, high velocity platform for Business Insights.
- This role is pivotal to the design, implementation, and sustainable management of that platform, which will shape the BI efforts of Supply Chain and Procurement.
--
Regards,
Pooja Shikha
+1-
Similar jobs
- KA
Automation Engineer
NewKaygen Inc
Irvine, CA🇺🇸$143.8k/yrHybridYesterdayMongoDBSOAPSQL+13Technology - LT
Specialist, Software Engineering with Security Clearance
NewL3Harris Technologies
Clifton, NJ🇺🇸HybridYesterdayAgileC++Jenkins+2Technology - LT
Lead, Systems Engineer- Control Systems Analysis with Security Clearance
NewL3Harris Technologies
Sacramento, CA🇺🇸$127.5k - $236.5k/yrHybridYesterdayMATLABC++Technology - SG
Python Developer - Data Protection Services
NewSoftware Guidance & Assistance
Alpharetta, GA🇺🇸HybridYesterdayDockerExpressFastAPI+15Technology - LT
Business Analyst - Salesforce
NewLTM
Milwaukee, WI🇺🇸HybridYesterdaySalesforceAgileTechnology - CD
Sr Staff Network Engineer - Storage & HPC
NewCloud Destinations LLC
United States🇺🇸HybridYesterdayOpenStackKubernetesTechnology