Sr. Data Engineer

PFSbrands • Full-time • Holts Summit, MO, US • 1d ago

Description

SPONSORSHIP IS NOT AVAILABLE FOR THIS POSITION

Reports to: Manager, Data and Reporting

FLSA Status: Exempt

Summary

As part of the Data Team, the Sr. Data Engineer plays a vital role in designing, developing, and managing our cloud-based data platform using Matillion and Snowflake. This role requires close collaboration with business units to ensure accurate data integration, as well as working with leadership and analysts to support reporting and analytics needs. The Senior Data Engineer will mentor and support other members of the Data Team, fostering their technical growth. Additionally, the Engineer will help enhance data literacy across the organization by promoting best practices and educating stakeholders on data usage.

Essential Duties And Responsibilities

Database Design & Architecture: Design scalable and optimized Snowflake data structures to support reporting, analytics, and business operations.
Database Administration: Manage, monitor, and maintain database performance, security, and availability. Handle user roles and permissions within Snowflake.
ELT Processes: Create and maintain Extract, Load, Transform (ELT) pipelines.
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.

5+ years of experience in data engineering, database architecture, and large-scale data management
BS/BA in computer science, information systems, data analytics, or a related field
Familiarity with data ingestion (APIs, SQL Server, JDBC/ODBC, etc.)
Understanding of star and snowflake design patterns
Experience creating ERDs
Skilled with ETL/ELT tools (Matillion a plus) and cloud-based databases (Snowflake preferred).
Basic understanding of data visualization tools (Power BI preferred)
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

Related Jobs

Data Engineer

PFSbrands • Full-time • Holts Summit, MO, US • 3d ago

Engineering Software Development

Description THIS POSITION IS NOT ELIGIBLE FOR SPONSORSHIP. Data Engineer Reports to: Manager, Data and Reporting FLSA Status: Exempt As the Database Engineer you will be vital in designing, developing, and man...

3d ago

Apply

Brand Manager

PFSbrands • Full-time • Holts Summit, MO, US • 1d ago

Marketing

Description Reports to: Director of Brand Management FLSA Status: Exempt Summary The Brand Manager for PFSbrands responsible for increasing top line sales, increasing same store sales, increasing same store purch...

1d ago

Apply

Deli Crew Member (part-time)

PFSbrands • Part-time • Ashland, MO, US • 3d ago

Food Service

Description DELI CREW MEMBER Reports to: Deli-Bakery Manager FLSA Status: Non-exempt Summary A Deli Crew Member goes above and beyond to exceed expectations and ensure that all guests experience genuine custom...

3d ago

Apply

Production Operator Blends - Evening Shift

PFSbrands • Full-time • Holts Summit, MO, US • 3d ago

Manufacturing

Description PRODUCTION OPERATOR - Evening Shift (2 p.m. - 10:30 p.m.) Reports to: Production Supervisor FLSA Status: Non-Exempt Summary The Production Operator is accountable for operating and maintaining equi...

3d ago

Apply

PFSbrands • Full-time • Holts Summit, MO, US • 3d ago

Management

Description VICE PRESIDENT - PEOPLE SUCCESS Reports to: Senior Vice President - People Success FLSA Status: Exempt PFSbrands is a dynamic and innovative organization committed to fostering a culture of excellence...

3d ago

Apply