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
