Data Engineer

Reports To : Director, Customer Data and Analytics

Direct Reports : 0

FLSA Status : Exempt (Not eligible for OT)

Employment Type : Full time

Location : Candidates must reside in the U.S. and have U.S. work authorization to be considered.

Position Overview : The Data Engineer will play a critical role in designing, implementing, and maintaining National Safety Apparel’s Snowflake Data Warehouse. This position requires strong technical expertise in Snowflake and ETL processes, with a preference for familiarity with Matillion. The ideal candidate will collaborate closely with cross-functional teams to optimize data infrastructure and ensure that high-quality, secure, and compliant data is available to drive informed decision-making.

Essential Job Functions :

• Data Warehouse Development : Design, build, and maintain a robust Snowflake Data Warehouse tailored to the organization’s needs.
• ETL Development : Create and manage ETL pipelines using Matillion to integrate data from multiple sources into Snowflake.
• Performance Optimization : Optimize Snowflake queries and data models to enhance scalability and efficiency.
• Collaboration : Partner with business stakeholders, analysts, and data scientists to understand data requirements and deliver solutions aligned with strategic goals.
• Data Integration : Ensure seamless integration of diverse data sources into the Snowflake platform.
• Documentation : Develop and maintain clear and comprehensive documentation of data processes, system architecture, and data models.
• Data Quality Assurance : Implement monitoring and validation processes to maintain data integrity and address inconsistencies.

Non-Essential Job Functions : Other duties as assigned

Training : On the job

Qualifications :

Education & Certifications :

Experience : 3 years of experience in data warehousing, ETL development, and data modeling. They should possess strong proficiency in Snowflake, including querying, performance tuning, and data modeling. Familiarity with Matillion or similar ETL tools is preferred, along with hands-on experience in SQL and cloud platforms.

Key Competencies : Advanced Excel and PowerPoint Skills, Team-Oriented, Problem-Solving, Time Management, Flexible, Highly Organized, Detail-Oriented, Professional Communication (written & verbal), Data-Driven, Process-Oriented, Analytical, Strong Business / Financial Acumen

Physical Requirements : Long periods of sitting or standing at an individual workstation, heavy computer work.

Working Conditions : Daily work in a temperature-controlled office environment, heavy computer work, must be able to stand / sit for duration of workday.

EEO Statement : National Safety Apparel provides equal employment opportunities for all persons regardless of race, color, religion, sex, national origin, handicap, disability, ancestry, age, veteran status, marital status, sexual orientation or any other protected group status as defined by law.