Data Engineer

DescriptionWhat Matters at Magid? YOU do!"The number one key to growth is having good people and that’s what has driven us at every stage of the game." - Greg Cohen, CEOAt Magid, we’re not just passionate about safety—we’re passionate about people. As an industry leader, we’ve built an innovative and collaborative environment where diversity is celebrated, ideas are valued, and personal and professional growth never stops.Job SummaryThe Data Engineer plays a crucial, cross-functional role here at Magid. This is a high-visibility role where your efforts will have impact on all levels of the organization. Our work spans product sourcing, customer journeys, service delivery, sales workflows, and the platforms and SME’s that support them. We have seen a drastic increase in adoption of the Data Engineer’s services. We are embedding data culture into our DNA and are excited to add a new face to that mission.Essential ResponsibilitiesData pipelines and transformations (ingest, clean, vet, test, transform, publish)Well-documented datasets and advanced semantic models that enable reporting and analysisData quality checks (freshness, completeness, validity) and participation in monitoring/alertingDatasets that support machine learning use cases with clear definitionsIncremental improvements to pipeline performance, cost, and reliability with guidanceCollaboration with partners to clarify requirements and iterate on data productsPartner in Data Discovery & Solution ShapingDevelop Power BI Solutions that are iterative while supporting our current ecosystem of analytics driven reportingLearn source systems and data flows; help map entities, identifiers, and key business rulesContribute to data modeling and design decisions with guidance (schemas, grain, slowly changing dimensions, etc.)Propose simpler, more reliable approaches (e.g., reuse shared datasets, standardize definitions) to improve trust and increase adoptionBuild & Maintain Data PipelinesBuild and maintain batch and/or streaming pipelines to ingest data from source systems into our analytical platformDevelop transformations to clean, standardize, and enrich data using agreed-upon patterns and tools (e.g., SQL, Python, Fabric Data Lake, KQL)Support ML workflows by helping produce curated training datasets and feature-ready tables, following established patternsHelp monitor pipeline health and data quality; investigate variances and propose code enhancements to key datasets.Contribute to a Strong Data CultureHelp evolve data standards (naming conventions, modeling patterns, documentation) to improve consistency and reusePromote a culture of data trust through quality checks, clear definitions, and thoughtful change managementWillingness to tackle obscure requests and find ways to solve cumbersome outdated workflowsHow We Work Empowered to solve problems, not just build featuresAccountable for outcomes, not outputCollaborative by default, from discovery through deliveryContinuously learning, using data, AI/ML and customer insight to improveHybrid Work Schedule:Monday - Thursday onsite at our corporate office in Romeoville, IL; Fridays WFH. RequirementsBachelor’s degree in Computer Science, Engineering, or a related fieldEquivalent practical experience is equally valuedStrong SQL fundamentals (joins, aggregation, window functions, performance basics)Data modeling mindset: Cares about clear definitions, grain, and making data usablePragmatic problem solving: Debugs issues, makes sensible tradeoffs, and knows when to ask for helpOwnership: Takes responsibility for assigned datasets/pipelines and follows through to productionCollaboration: Works effectively with product managers to deliver trusted dataKey QualificationsMinimum of 5+ years of experience in data engineering, analytics engineering, or software engineering (including internships or equivalent projects)Ability to write production-quality SQL and create reliable transformations with attention to correctnessUnderstanding of dimensional modeling and/or event modeling concepts (fact/dimension tables, star schemas)Proficiency in Python (or similar) and comfort using Git and code reviews to collaborateFamiliarity with data platforms (data warehouse/lakehouse concepts), and exposure to orchestration/ETL tools (e.g., Airflow, dbt, Spark) is a plusPreferred QualificationsExperience working with a modern data warehouse/lakehouse (e.g., Microsoft Fabric One Lake, Snowflake, BigQuery, Databricks)Exposure to data quality testing, monitoring, or observability conceptsFamiliarity with data governance concepts (Row-Level-Security, Workspace Roles, etc)Exposure to machine learning workflows (training data preparation, feature tables, model experimentation support)Familiarity with modern engineering practices (CI/CD, testing, observability)Magid offers a variety of benefits to our team members including:Health, dental, vision, life and disability insuranceBonus plan401k retirement plan with company matchCompany provided Profit SharingParticipation in Magid Paid Time Off (PTO) Policy 9 Paid HolidaysMagid Glove & Safety is a leading manufacturer, distributor, and importer of hand protection and safety products, e.g., work gloves, fall protection, reusable and disposable respirators. We are an innovative, growing, and privately held business, that has been delivering safety solutions to thousands of companies since 1946. Magid is an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, #state, or local law. The salary range for this position is $96,000.00 - $134,400.00. Actual pay will be adjusted based on job-related factors permitted by law, such as experience and training, geographic location, additional qualifications such as licensure or certifications, market factors, and responsibilities.#IND1Employee Type: Salary Employee