Harrington Process Solutions is looking for an experienced Senior Data Engineer to join our growing Data, Analytics, and Integration team. This is a senior, hands-on role for someone who can help shape our long-term data architecture while also rolling up their sleeves to build pipelines, develop in Snowflake, write SQL, and solve complex data challenges.
You'll work across our ERP data, Master Data Management (MDM), and Snowflake environments, helping bring these workstreams together into a scalable and reliable enterprise data platform.
What You'll Do- Help design Harrington's long-term data lakehouse/data warehouse architecture.
- Design, build, and optimize our Snowflake data warehouse, including schemas, security, performance, and cost management.
- Develop Bronze, Silver, and Gold data layers using medallion architecture principles.
- Build and maintain data pipelines using Azure Data Factory, Snowflake, and other modern data tools.
- Partner with our MDM team to support Profisee integrations, data quality, and golden-record pipelines.
- Develop complex SQL, views, stored procedures, validation logic, and KPI queries.
- Help migrate downstream applications from direct SQL feeds to a trusted Snowflake data path.
- Provide technical guidance and mentorship to other engineers and developers.
- Establish engineering standards and support data governance, lineage, access controls, and documentation.
- Partner with external vendors and ensure solutions align with Harrington's long-term architecture.
What We're Looking For- 7+ years of data engineering experience with exposure to data architecture.
- Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field, or equivalent experience.
- Strong hands-on experience with Snowflake, including performance tuning, Snowpipe, Streams, Tasks, and cost optimization.
- Experience designing data warehouses/lakehouses and medallion architecture.
- Strong experience with Azure Data Factory, Azure Data Lake, and/or Azure Functions.
- Advanced SQL skills and experience building production data pipelines.
- Strong understanding of data modeling and schema design.
- Ability to communicate technical decisions to both technical and non-technical audiences.
- Experience mentoring or guiding other engineers.
Preferred ExperienceExperience with Profisee or other MDM platforms, Apache Iceberg or Delta Lake, Fivetran, dbt, Python, Power BI, semantic layers, and data governance tools is a plus. Experience supporting a multi-ERP or acquisition-driven organization is also highly valued.
Harrington provides an outstanding benefits package, designed to support our employees' health, financial wellness, and work-life balance, with options that go above and beyond standard offerings!
Insurance:- Medical Plans: Choose from HDHP/HSA (with monthly company contributions) or a PPO option.
- Spousal HRA: SIHRA covers 100% of eligible expenses up to $9,400 per individual or $18,800 per family each calendar year.
- FSAs: Flexible spending options for health and dependent care expenses.
- Dental: Comprehensive, including orthodontic care for both children and adults
- Vision: Includes discounts on Lasik.
- Telehealth & Concierge: 24/7 healthcare access with prescription services for enrolled members.
- Life Insurance and AD&D: Company paid life and AD&D coverage
- Long Term Disability: Company paid LTD program
- Optional Coverages: Short term disability, voluntary pet care, identity protection, voluntary life insurance with optional dependent coverage, plus supplemental critical illness, accident, and hospital indemnity.
- Employee Assistance Program: Professional support for employees during critical times.
- Disability: Options for both short- and long-term coverage.
Retirement:- 401(K) & Roth: 100% company match on the first 3%, plus 0.5 match on the 4th and 5th%
Work/Life Balance:- Paid Time Off: Start with 3 weeks, with the potential to accrue up to 5 weeks per year.
- Holidays: 7 paid holidays, including the day after Thanksgiving.
- Additional Leave: Coverage for jury duty, witness duty, and bereavement leave.
Harrington continuously seeks new ways to enhance benefits to help our employees thrive in every area of their lives.
