AI Product Engineer

Shermco Industries, Inc.•Irving, TX

1d•$150,000 - $170,000•Remote

About The Position

Shermco is seeking a Senior Data Engineer to strengthen its data engineering and applied AI/ML capabilities and support the next stage of its analytics and AI journey. The role joins a small, collaborative team with expertise in database operations, business intelligence, and stakeholder engagement. It is a hands-on position covering the full data lifecycle, from ingesting and transforming data to modeling, enriching, and applying advanced analytics. The engineer will help the team navigate and adopt Microsoft Fabric and the Azure AI ecosystem, while shaping the organization’s developing AI/ML capabilities. The position focuses on building practical, meaningful data solutions and exploring valuable AI/ML opportunities. The engineer will deliver data pipelines and analytics-ready datasets, apply AI/ML techniques to business use cases, and collaborate with teammates in BI, database engineering, and business analysis. The role uses an iterative workstyle and emphasizes reliable, maintainable, well-documented solutions.

Requirements

Bachelor’s degree in Computer Science, Software Engineering, Data Science, or a related field, or equivalent professional experience.
3–7+ years of hands-on experience in data engineering, analytics engineering, or applied machine learning.
Deep experience with SQL and Python for data ingestion, transformation, and integration.
Experience with Microsoft Fabric or Azure data ecosystem tools such as Data Factory, Synapse, ADLS, or Databricks.
Proven ability to extract, transform, and model data from ERPs, SaaS systems, APIs, and file-based sources.
Familiarity with Spark for larger-scale transformations.
Real-world experience applying AI/ML techniques, such as regression, forecasting, classification, NLP, or enrichment.
Ability to work autonomously and collaborate within a small, multidisciplinary team.
Experience working in iterative frameworks such as Agile or Scrum, using Jira or equivalent tools.

Nice To Haves

Relevant Microsoft, Azure, Fabric, or AI/ML certifications or an advanced degree.
Experience with Business Central or similar ERP systems.
Exposure to Power BI semantic modeling concepts.
Experience deploying or operationalizing ML models.
Familiarity with Azure AI, Copilot, or LLM-based enrichment.

Responsibilities

Own and build end-to-end data pipelines within Microsoft Fabric.
Ingest data from ERP systems, CRM and SaaS systems, APIs, and file-based sources such as CSV, JSON, Excel, cloud storage, and SFTP.
Deliver reliable, validated, well-structured datasets for analytics and operational needs.
Build analytics-ready datasets within Fabric Lakehouse and Warehouse architectures.
Use SQL, Python, and Spark to normalize, join, enrich, and clean data.
Design simple, transparent, and scalable data modeling patterns suited to the team and business.
Prepare training datasets, run models, evaluate outcomes, and integrate results into pipelines and analytics products.
Apply AI/ML to process automation, forecasting, predictive modeling, classification, data enrichment, and extraction from unstructured sources.
Use Microsoft Fabric, Azure Foundry, and other AI/ML capabilities to deliver practical, value-driven solutions.
Implement testing, validation, error handling, and monitoring across pipelines and models.
Use Git and appropriate CI/CD practices, and keep solutions maintainable and well-documented.
Collaborate with BI, database engineering, and business analysis teammates to deliver complete data solutions.
Help define requirements, validate outputs, troubleshoot issues, and break complex initiatives into manageable increments.
Participate in Agile-style backlog management, sprint planning, and work tracking using Jira or similar tools.
Stay current with Microsoft Fabric and Azure AI advancements, propose improvements and opportunities, and grow ownership of AI/ML capabilities.