Analytic Solutions Developer I

Milbank Manufacturing Company; Kansas City (MO); On-site; USD 90,000 - 130,000; Full time

Job summary

Milbank Manufacturing Company in Kansas City, MO seeks a data engineering and analytics professional to design and maintain data pipelines and BI solutions. You will collaborate with cross-functional teams to improve data quality, support enterprise data models, and deliver actionable insights through dashboards and reports.

The role emphasizes ETL, data integration, and governance, with responsibility for scalable data solutions and strong partnerships with Finance, Operations, and Sales.

Qualifications

• Associate or bachelor's degree in data analytics, information systems, computer science, business intelligence, engineering, mathematics, or related field.
• Two to five years of experience or commensurate experience.
• Minimum of three years working with business data, databases, reporting systems, analytics platforms, or enterprise applications.

Responsibilities

• Develop and maintain data pipelines, ETL processes, dashboards and reports.
• Collaborate with stakeholders to improve data quality and resolve data issues.
• Support ERP, CRM, manufacturing, finance, sales, supply chain, and BI integrations.
• Ensure data accuracy, consistency, and governance across reporting systems.

Skills

Analytical

Problem solving

Judgment

Planning/organizing

Computer skill

Education

Associate or Bachelor's degree in related field

Tools

Power BI

Phocas

Visual Studio Code

SQL

Job description

Job Details

Job Location: Kansas City, MO 64120

Position Type: Exempt

Duties

Data Engineering & Analytics: Develop and maintain data pipelines, integrations, ETL processes, dashboards, reports, and analytical solutions.

Collaborate with stakeholders, improve data quality, resolve data issues, and support enterprise data models.

Systems & Integration: Support ERP, CRM, manufacturing, finance, sales, supply chain, and BI integrations. Implement, test, document, and improve data solutions and automation.

Analytics Solutions

• Develops, maintains, and enhances dashboards, scorecards, reports, and analytical solutions that provide actionable business insights.
• Translates business requirements into scalable reporting, visualization, and data solutions.
• Design and maintains data models, metrics, KPIs, and analytical frameworks that support operational and strategic decision-making.
• Collaborates with business stakeholders to identify opportunities where analytics can improve performance, visibility, and decision-making.

Data Management & Integration

• Designs, develops, and maintains data pipelines, ETL processes, and integrations between enterprise systems and analytical platforms.
• Ensures data accuracy, consistency, and integrity across reporting and business intelligence solutions.
• Researches, diagnoses, and resolves data quality, reporting, and system integration issues.
• Supports the development and maintenance of enterprise data architecture, standards, and governance practices.

Management and Organization

• This individual is a team player and works with business leaders and technical stakeholders to plan and organize analytics, automation, and data-driven business solutions.
• Demonstrates the ability to build strong cross-functional relationships and effectively support Finance, Sales, Operations, Supply Chain, Human Resources, Engineering, and other departments.
• Responsible for the successful execution of analytics, dashboarding, system integration, and process improvement initiatives while meeting project timelines and business objectives.
• Ensures reporting solutions, data models, integrations, and supporting documentation are accurate, maintainable, and aligned with company standards and best practices.

Communication

• Oral communication - Speaks clearly and persuasively in positive or negative situations and demonstrates group presentation skills
• Provides training, support, and guidance to users of reporting and business intelligence tools
• Written communication - Demonstrates ability to express complicated and technical matters in a clear, concise manner

Lean Enterprise

• Establish and utilize frameworks and systems, including tools such as visual management, problem solving, standard work and kaizen.
• Adhere to and promote the HR Pledge.
• Cooperate and commit to achieving goals and deliverables in a team environment.
• Resolve difficult or complicated challenges using the problem-solving process.
• Actively embrace our core principles.

Competencies

• Analytical - Synthesizes complex or diverse information
• Problem solving - Identifies and resolves problems in a timely manner and gathers and skillfully analyzes information
• Judgment - Displays willingness to make decisions, exhibits sound and accurate judgment and makes timely decisions
• Planning/organizing - Prioritizes and plans work activities, uses time efficiently and develops realistic action plans
• Computer skill - Creates and maintains documents, presentations, and analytical content using Microsoft Office applications including Outlook, Word, Excel, PowerPoint, and Teams. Demonstrates proficiency with business intelligence, reporting, and data visualization tools. Utilizes SQL, databases, data integration tools, and enterprise business systems to develop analytical solutions and support business decision-making. Must be able to proficiently utilize ERP, CRM, business intelligence, reporting, and other corporate technology platforms in the completion of tasks. Maintains the ability to learn and adapt to evolving technologies, analytical tools, automation platforms, and AI-enabled business solutions.

Qualifications

Education: Associate’s or bachelor's degree in data analytics, information systems, computer science, business intelligence, engineering, mathematics, or related field and two to five years of experience or commensurate experience.

Experience/Skills/Abilities: Minimum of three years of experience working with business data, databases, reporting systems, analytics platforms, or enterprise applications. Proficiency in SQL development, ETL processes, dashboard development, Power BI, Phocas, Visual Studio Code, data governance, data quality, enterprise business systems, automation, and process improvement.

Travel Required: Minimal

Hours: Regular 40-hour workweek. Minimal overtime as needed.

Working Conditions: Business casual office setting