Data Engineer/Data Analyst

Midland Industries; Kansas City (MO); Hybrid; USD 90,000 - 140,000; Full time

Job summary

Midland Industries seeks a Data Engineer/Data Analyst to design, build, and maintain a cloud-based data ecosystem that delivers high-value analytics, reporting, and insights across the data lifecycle.

You will design cloud data warehouses (Azure Synapse) and ETL/ELT pipelines, model data for analytics, and create dashboards with Power BI/Tableau/Looker while collaborating with business stakeholders to advance data strategy.

Qualifications

• 3+ years of professional experience in data engineering, ETL development, and data modeling.
• Experience with Azure Data Factory, Power BI, Tableau, Looker, or similar tools.
• Bachelor’s degree in business, Information Systems, Computer Science, or a related field.
• Experience in industrial distribution, manufacturing, or supply chain environments preferred.
• Experience supporting process improvement or operational transformation initiatives.

Responsibilities

• Design, provision, and configure cloud data warehouses and storage environments (e.g., Azure Synapse).
• Develop, test, and maintain scalable ETL/ELT pipelines using SQL, Python, or similar tools.
• Architect and implement dimensional models, data marts, and data cubes.
• Ensure data quality, reliability, and performance across pipelines and data structures.
• Create clear documentation for data systems, pipelines, and processes.
• Build and maintain dashboards and reports with Power BI, Tableau, or Looker.
• Collaborate with stakeholders to translate analytics needs into technical solutions.
• Support evolution of data strategy with automation and optimization ideas.
• Contribute to a scalable, modern data ecosystem for business users.

Skills

SQL

Python

Data visualization

Cloud experience

BI tools

Communication

Project management

ERP/WMS familiarity

Attention to detail

Execution-focused

Education

Bachelor's degree in business, Information Systems, Computer Science or related field

Tools

Azure Data Factory

Power BI

Tableau

Looker

Azure Synapse

Job description

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.
• 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.

An Equal Opportunity Employer

We do not discriminate based on race, color, religion, national origin, sex, age, disability, genetic information, or any other status protected by law or regulation. It is our intention that all qualified applicants are given equal opportunity and that selection decisions be based on job-related factors.