What are the responsibilities and job description for the Data Engineer position at PFSbrands?
Job Description
Job Description
Description :
Reports to : Manager, Data and Reporting
FLSA Status : Exempt
SUMMARY
As the Database Engineer 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 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.
WORKING CONDITIONS
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.
Requirements :
