What are the responsibilities and job description for the Junior Database Architect and Administrator position at Pro Food Systems Inc (PFSbrands)?
JUNIOR DATABASE ARCHITECT AND ADMINISTRATOR
Location: Holts Summit, MO
Reports to: Manager, Data and Reporting
FLSA Status: Exempt
SUMMARY
As the Junior Database Architect / Administrator, you will be vital in designing, developing, and managing our cloud-based data platform using Snowflake. You’ll also collaborate closely with our analytics and operations teams to ensure seamless data flow across tools like Matillion and Power BI. This is a perfect opportunity for a recent graduate or someone with up to 2 years of experience in data management or database administration to learn and grow with us. We’re seeking someone passionate about learning and a continuous improvement mindset.
ESSENTIAL DUTIES AND RESPONSIBILITIES
- Database Design & Architecture: Assist in designing scalable and optimized Snowflake data structures to support re- porting, analytics, and business operations. You will be accountable for documentation and systems maintenance and work with other managers on data governance and security.
- Database Administration: Manage, monitor, and maintain database performance, security, and availability. Handle user roles and permissions within Snowflake.
- ELT Processes: Work with Matillion to manage Extract, Load, Transform (ELT) workflows, ensuring efficient data movement and transformation. Other tools may become part of our data stack as needed. You will be expected to become an expert user of them and will be involved in the vetting process for onboarding any new BI software.
- Data Integration: Collaborate with various teams to ensure timely, accurate data integration from multiple sources.
- Reporting & Analytics Support: support analysts and business teams by ensuring Power BI dashboards are fed with accurate and up-to-date data.
- Process Improvement: Proactively identify opportunities to enhance data quality, performance, and process efficiency.
- Documentation: Maintain detailed documentation of processes, data models, and architecture decisions.
- Support & Troubleshooting: Assist with troubleshooting and resolving data-related issues quickly to support business operations. Maintain system performance levels to ensure adherence to performance criteria approved by review and senior management.
- Embrace the PFSbrands’ mission, work toward our vision statement, and live according to our core values.
- Perform all other as requested or assigned
QUALIFICATIONS
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, experience and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- 0-2 years of experience in database architecture, administration, or data management
- BS/BA in computer science, information systems, data analytics, or a related field
- Skilled in SQL and cloud-based databases (Snowflake preferred).
- Familiarity with data integration or ETL/ELT tools (Matillion a plus).
- Basic understanding of data visualization tools (Power BI preferred) and database schema.
- Proficient with data analysis
- Strong problem-solving skills and attention to detail
- Willingness to learn and grow in a fast-paced environment
- Effective communication and collaboration abilities
- Ability to quickly process information and make decisions
- Excellent time-management with the ability to meet tight deadlines
- Detail-oriented and excellent follow through
- Must be dependable and able to work independently with little supervision as well as with a team of individuals.
WORKING CONDITIONS
- Work is typically performed in normal office conditions.
- Position requires occasional overnight travel.
PHYSICAL DEMANDS
The physical demands described here are representative of those that must be met by an employee To successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- While performing the duties of this job, the employee is required to use hands to fingers, reach, climb stairs, walk, sit for long periods of time, talk and hear.
- Must be able to sit for prolonged periods of time in front of a computer daily.
- Must have visual and hearing acuity.
- Digital dexterity and hand/eye coordination in operation of office equipment
- Ability to speak to and hear customers and/or employees via phone and in person in English
- Ability to use hands and fingers to reach, lift and carry 25 pounds on an infrequent basis
