Data Engineer/Data Analyst

Midland Industries; Kansas City (MO); On-site; USD 90,000 - 130,000; Full time

Job summary

Midland Industries is seeking a Data Engineer/Data Analyst to design, build and maintain our cloud-based data ecosystem and deliver high-value analytics, reporting, and insights. You’ll work across the full data lifecycle to ensure reliable, scalable, and actionable data for the business.

You will collaborate with stakeholders to translate analytical needs into robust data solutions, build dashboards in Power BI/Tableau/Looker, and help evolve our data strategy with automation and optimization.

Qualifications

• Expert SQL skills for complex querying and data manipulation.
• Hands-on experience with at least one major cloud platform (Azure, AWS, or GCP).
• Strong proficiency in Python for data manipulation and pipelines.
• Experience building reports/dashboards with BI tools (Tableau/Looker/Power BI).
• Excellent communication and organizational skills.

Responsibilities

• Design, provision, and configure cloud data warehouse and storage environments.
• Develop and maintain scalable ETL/ELT pipelines.
• Architect dimensional models, data marts, and cubes for analytics.
• Ensure data quality, reliability, and performance across pipelines.
• Create documentation for data systems and processes.
• Build dashboards and reports for business insights.
• Collaborate with stakeholders to translate analytics needs into solutions.

Skills

SQL proficiency

Python

Cloud platforms

Data visualization

Communication skills

Education

Bachelor's degree in business

Bachelor's degree in Information Systems

Bachelor's degree in Computer Science

Tools

Azure Data Factory

Power BI

Tableau

Looker

Epicor P21

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.