Job Description
Job Description
Data Engineer/Analyst
Position Summary
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.
KEY RESPONSIBILITIES
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.
QUALIFICATIONS
Knowledge, Skills and Abilities
Required:
- 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.