AI Data Engineer

At AspenView, we are passionate about transforming the way organizations approach technology. We specialize in creating high-performing, nearshore IT teams to help North American clients innovate faster and more efficiently. As we continue to grow, we’re looking for exceptional people to join our team and help drive impactful change across industries.

AspenView Technology Partners is seeking an AI Data Engineer to work on a contract basis with one of our clients. You'll be reporting directly to the company executive leadership (SVP and COO), you will create visibility into operations by connecting and unifying data from a mature, federated systems landscape — with an AS/400 core — and turning it into reports, dashboards, and AI-ready data products. A central part of the role is building agentic connectors that let AI tools work safely and securely with company data, backed by disciplined management of syntax, schema, and the semantic layer. You will partner closely with the company IT team while delivering executive-level insight — helping the business move from ad hoc Excel and Claude analysis to dependable, enterprise-wide intelligence.

• Build reports and dashboards that give executive leadership clear, timely visibility into operations, working under their direction.

• Translate leadership questions into well-structured, trustworthy data products.

• Connect and unify data from disparate sources across a federated landscape — including the AS/400 core — without a wholesale data-lake migration.

• Reconcile mismatched data from bolt-on acquisitions (e.g., SKUs, warehousing, safety records) to maintain integrity and comparability.

• Build agentic connectors that let AI tools — such as Claude — work with company data reliably.

• Protect and secure those connectors: scoped access, authentication, and safe handling of sensitive data.

• Manage syntax, schema, and a semantic layer so data is consistent, well-defined, and ready for both analysts and AI.

• Establish shared definitions and metrics that hold up across systems and acquisitions.

• Partner with AMCON’s IT team for access, cooperation, and knowledge of the existing environment.

• Deliver iteratively — prioritizing the insights leadership needs most — and document what you build

• Solid data engineering experience, with a track record of building reports and dashboards that stand up to executive scrutiny.

• Practical AI fluency — comfort using tools like Claude and building and securing agentic connectors (e.g., MCP-style integrations) between AI and enterprise data.

• Strong skills in syntax, schema, and semantic-layer management, and in reconciling disparate data sources.

• Experience integrating data through a federated approach — querying and connecting sources — rather than relying solely on a central data lake.

• Familiarity accessing data from legacy / enterprise systems, ideally AS/400 (IBM i) / DB2, via ODBC, APIs, or equivalent.

• Strong SQL and a scripting language (e.g., Python), with sound data modeling fundamentals.

• A security-first mindset for connectors and data access, with good judgment about sensitive information.

• Excellent written and spoken English, the confidence to work directly with C-suite stakeholders, and self-directed delivery in a lean-IT environment.

• Hands-on AS/400 (IBM i) / DB2 data extraction and modernization experience.

• BI platform experience (Power BI or similar) and semantic modeling.

• MCP (Model Context Protocol) or other agentic connector / integration experience.

• Background in wholesale distribution, supply chain, logistics, or retail data.

• Experience unifying data after acquisitions (M&A data integration). • Data governance and security tooling experience

AspenView is proud to be an equal opportunity employer. We believe in creating an environment where all employees feel welcome, valued, and empowered to succeed. We celebrate diversity and strive to build a culture of inclusion where all individuals, regardless of their race, color, gender, gender identity or expression, sexual orientation, disability, age, or any other characteristic, can thrive. We encourage applicants from all walks of life to join our team and make a lasting impact.