Homewerks Worldwide, LLC, a leading import distributor of home improvement products for major retailers is seeking a Senior Data Engineer to join our Operations Team. Homewerks Worldwide develops, sources, and markets bathroom, kitchen, and plumbing products for home and commercial use. Since its formation in 2006, Homewerks has shown consistent sales growth fueled by a proven track record of bringing innovative, efficient, and high-quality product solutions to homes. We offer a competitive salary and benefits package, as well as the opportunity to contribute to a fast-growing organization. Our corporate office is in Lake Bluff, IL and we have distribution centers in both Lake Bluff and Libertyville, IL.   

Position Summary

The Senior Data Engineer is responsible for designing, developing, and optimizing data pipelines, reporting solutions, and analytics across the organization. Working closely with IT, finance, and other business stakeholders, this role provides accurate, timely insights that support critical decision-making. Responsibilities include acquiring and integrating data from the Infor Data Lake, building out financial statements, cash flow reports, and other operational reporting, and establishing performance monitoring frameworks to ensure data pipeline efficiency and accuracy. The Senior Data Engineer also provides leadership and mentorship to a reporting analyst, ensuring best practices in data acquisition, transformation, and visualization.

Success in this position requires a blend of technical expertise, business acumen, and a collaborative mindset that fosters a data-driven culture throughout the organization.

Responsibilities

• Data Acquisition & Integration

o  Extract, transform, and integrate data from Infor’s Data Lake and other third-party platforms, APIs, and cloud services

o  Collaborate with IT and business stakeholders to design and implement robust ETL/ELT pipelines into an on-premises data warehouse, while also maintaining existing pipelines.

o  Leverage Infor Data Fabric tools (e.g., Data Lake, Data Catalog) to ensure data integrity and efficient data flows

o  Adhere to cybersecurity protocols and implement safeguards to protect data integrity, including secure data transfer methods, encryption strategies, and robust recovery processes.

o  Develop and continuously refine data strategies, staying abreast of emerging tools and technologies to optimize data processes and support evolving business needs

• Reporting & Visualization

o  Develop, maintain, and enhance Power BI dashboards and Excel-based reports that are accurate, timely, and aligned with business requirements

o  Ensure reporting solutions are scalable, user-friendly, and effectively communicate key insights

• Financial, Operational & Business Acumen

o  Drive the build-out of financial statements, cash flow, and other accounting reports to meet organizational and compliance needs

o  Apply core financial and accounting principles (e.g., cash application and reconciliation with retailers) when designing relevant data solutions.

o  Expand and enhance operational reporting to support data-driven decision-making across various functional areas (e.g., supply chain, inventory, logistics)

o  Maintain a foundational understanding of the import/distribution industry, including key performance metrics

• Reporting Leadership & Training

o  Supervise and mentor a reporting analyst, guiding them on data acquisition, data migration, reporting, and visualization best practices

o  Train business users to interact effectively with reports and dashboards to maximize the value of the information provided

Qualifications

• Bachelor’s degree in Computer Science, Data Science, Information Systems, or a related field (Master’s preferred)
• 5+ years of experience in data engineering, data warehousing, or a related analytics role
• Proven track record designing and managing ETL/ELT processes in on-premise data warehouse environments
• Expertise with Infor Data Fabric, including the Infor Data Lake (data ingestion, extraction, and transformation)
• Solid understanding of relational databases, data modeling, and cloud-based data solutions
• Demonstrated ability to work cross-functionally with technical and non-technical teams
• Strong analytical and problem-solving skills, with attention to detail and accuracy
• Robust understanding of operational transactions, process flows, and associated data structures
• Background or experience with financial statements, accounting reports, and cash flow reporting

Required & Preferred Skills

Required:

o  Proficiency in SQL Server or other programming languages commonly used in data engineering

o  Proficiency in SSIS (SQL Server Integration Services) for building and optimizing ETL workflows, and strong familiarity with SQL Reporting Services (SSRS) for designing and delivering interactive reports.

o  Hands-on experience with Infor Data Fabric (e.g., Data Lake, Data Catalog) for data flows and governance

o  Experience building and optimizing data pipelines and architectures to support large-scale data analytics

o  Hands-on build expertise with PowerBI and Excel for visualization and reporting

o  Solid understanding of financial, accounting, and operational fundamentals to effectively design data solutions that align with business requirements.

o  Ability to translate complex data concepts into business-friendly language

o  Strong business perspective, ensuring that technical solutions and data initiatives align seamlessly with the organization’s operational and strategic objectives.

o  Experience with on-premise data warehouse management and hybrid data solutions

o  Experience with Infor ION or other Infor ecosystem integrations

Preferred:

o  Background in import/distribution or retail industries

o  Data governance or master data management experience

o  Certifications in data engineering or cloud technologies (e.g., SQL Server, PowerBi, Data Infrastructure, Data Cubes, or Infor-related certifications)

Personal Profile & Cultural Fit

• Results-Driven: Passionate about extracting actionable insights and driving business value through data
• Collaborative Mindset: Excels at partnering with cross-functional teams and mentoring junior staff
• Detail-Oriented & Analytical: Maintains high standards for data accuracy and reporting integrity
• Strong Communicator: Able to explain technical concepts to both technical and non-technical audiences
• Flexible & Adaptable: Thrives in a rapidly changing environment, continuously exploring new technologies and methods
• Directional Clarity: Prioritizes effectively and maintains clear focus even amid ambiguity, ensuring meaningful progress and outcomes

Physical Demands

These physical demands are representative of those necessary for an employee to successfully perform the essential functions of this position. They include the ability to sit for extended periods, regularly stand and walk, and maintain sufficient manual dexterity to operate a computer keyboard and mouse.

Homewerks Worldwide, LLC is an equal opportunity employer that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws.