Data Engineer/Data Analyst

The Data Engineer/Data Analyst is responsible for designing, building and maintaining our cloud-based data ecosystem while also delivering high-value analytics, reporting, and business insights. You’ll work across the full data lifecycle - from engineering and modeling to visualization and strategic analysis - ensuring the organization has reliable, scalable, and actionable data., Data Engineering & Architecture (Primary Responsibility)

• Design, provision, and configure cloud data warehouse and storage environments (e.g., Azure Synapse, Data Lake, Fabric).
• Develop, test, and maintain scalable ETL/ELT pipelines using SQL, Azure Data Factory, Python, or similar tools.
• Architect and implement dimensional models, data marts, and data cubes to support analytics and reporting needs.
• Ensure data quality, reliability, and performance across all pipelines and data structures.
• Create clear, comprehensive documentation for data systems, pipelines, and processes. * *

Analytics, Reporting & Business Insights (Secondary Focus)

• Build and maintain impactful dashboards, reports, and visualizations using tools such as Power BI, Tableau, or Looker.
• Partner with business stakeholders to understand analytical needs and translate them into technical solutions. * *

Cross-Functional Collaboration & Strategy

• Work closely with the team to ensure alignment on architecture, governance, and best practices.
• Support the evolution of the organization’s data strategy by identifying opportunities for automation, optimization, and improved insight delivery.
• Contribute to the long-term vision of a scalable, modern data ecosystem that empowers business users.

• Expert SQL Skills: Mastery of SQL for complex querying, performance tuning, and data manipulation.
• Cloud Experience: Hands-on experience with at least one major cloud platform (Azure, AWS, or GCP) in relation to data services.
• Programming: Strong proficiency in Python for data manipulation and pipeline development.
• Data Visualization: Experience building reports and dashboards with a major BI tool (e.g., Tableau, Looker, Power BI).
• Strong organizational, planning, and problem-solving skills
• Proven ability to manage deadlines and priorities in a fast-paced environment
• Excellent written and verbal communication skills
• Familiarity with ERP systems (Epicor P21 preferred), WMS, or operational reporting tools
• Execution-focused with strong follow-through
• Detail-oriented while able to see the bigger picture
• Results-driven mindset aligned with business outcomes

Nice-to-Have Skill:

• AI/ML Familiarity: Understanding of data preparation for Artificial Intelligence (AI) and Machine Learning (ML) models and experience with related data tools.

Education and Experience

• Technical Proficiency: 3+ years of professional experience in data engineering, ETL development, and data modeling.
• Experience with specific tools mentioned (Azure Data Factory, Power BI, etc.).
• Experience in Business Analysis or formal requirements gathering.
• Bachelor’s degree in business, Information Systems, Computer Science or related field preferred
• Experience managing cross-functional initiatives with multiple stakeholders a plus
• Experience in industrial distribution, manufacturing, or supply chain environments preferred
• Experience supporting process improvement or operational transformation initiatives

Physical Requirements

• Prolonged periods of sitting at a desk and working on a computer.