AI & Automation Software Engineer

De Novo HRConsulting & Business Advisory

Huntingdon Valley, PA

JOB DETAILS
SKILLS
Application Programming Interface (API), Artificial Intelligence (AI), Artificial Intelligence (AI) Agents, Authentication, Automation, Automation Systems, Billing, Cloud Computing, Data Management, Data Warehousing, Database Administration, Database Architecture, Database Extract Transform and Load (ETL), Ecosystems, Engineering, Identity Data Management, JSON, MCP - Microsoft Certified Professional, Machine Learning, Microsoft .NET, Microsoft Access Database, Microsoft C# (C Sharp), Microsoft Product Family, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Modeling Languages, Pagination, Problem Solving Skills, Python Programming/Scripting Language, REST (Representational State Transfer), SQL (Structured Query Language), SQL Databases, Scalable System Development, Scripting (Scripting Languages), Snowflake Schema, Software Development, Software Engineering, Technical Support, Traffic Shaping, Training Data Sets, Use Cases, Wheel/Front-End Loader, White Papers
LOCATION
Huntingdon Valley, PA
POSTED
16 days ago

Our client is seeking a highly capable AI & Automation Software Engineer. You will not just be writing basic scripts; you will be architecting the data pipelines and AI agents that power our managed services. We need a builder who can securely bridge Large Language Models with our enterprise infrastructure using modern frameworks like the Model Context Protocol (MCP) and Databricks/SQL Database ETL pipelines.

Note to Applicants: A verifiable portfolio of your work (GitHub, architecture teardowns, or live projects) is an absolute requirement for this role. We are looking for proven execution.

Core Responsibilities

  • Agentic Workflows & MCP: Design and deploy custom Model Context Protocol (MCP) servers (using Python or .NET) to allow AI agents (like Copilot Studio) to securely interact with our infrastructure and APIs.
  • ETL & Data Engineering: Build and maintain scalable data pipelines using PySpark, Databricks, and SQL Databases. Implement Medallion Architecture (Bronze, Silver, Gold layers) for robust data ingestion from third-party REST APIs.
  • AI & Vector Databases: Architect RAG (Retrieval-Augmented Generation) pipelines. Deploy, populate, and maintain vector databases to feed contextual data to LLMs.
  • Model Training & Fine-Tuning: Curate large, complex datasets to fine-tune machine learning models and LLMs for highly specific IT and managed service use-cases.
  • Cloud Orchestration: Develop within the Azure ecosystem, utilizing Azure Container Apps, Azure Automation (Runbooks), Entra ID (Service Principals/Managed Identities), and Data API Builder.
  • Advanced Automation: Work with automation platforms (Azure Logic Apps / Power Automate) to connect disparate systems (Microsoft Graph API, RMM tools, billing platforms) into seamless, zero-touch workflows.

Required Qualifications

  • Experience: 3+ years of hands-on software development and data engineering experience (this is not an entry-level or fresh-graduate role).
  • Programming: Deep proficiency in Python and/or C# (.NET). You must know how to write clean, scalable, and highly secure code.
  • API Mastery: Extensive experience building, consuming, and authenticating RESTful APIs, specifically dealing with pagination, rate limiting, and complex JSON payloads.
  • Database Infrastructure: Strong SQL skills (T-SQL / Azure SQL). Experience with modern cloud data warehouses (Snowflake, Databricks) is highly preferred.
  • Security-First Mindset: Understanding of cloud security paradigms—you know why an LLM should never have direct, un-containerized access to a raw database.

Portfolio Requirement

You must submit a portfolio of past work. Examples of what we want to see:

  1. Code repositories demonstrating complex API integrations or ETL pipelines.
  2. Custom AI agents, RAG implementations, or MCP servers you have built.
  3. Architecture diagrams or white-papers you've authored detailing a problem you solved using Azure, Data, or AI.

About the Company

D

De Novo HRConsulting & Business Advisory