Summer Rpa Intern Jobs in Frederick, MD (NOW HIRING)

Job Summary Responsible for designing, building, and operating advanced application solutions that modernize municipal services. The incumbent leads complex development efforts across application engineering, AI and robotic process automation, data platform architecture, and enterprise integrations. Responsibilities include project leadership for strategic initiatives, hands-on senior development, systems programming, and database and data lake administration.

The role ensures requirements analysis, architecture, coding, testing, deployment, and operational support are delivered on time and to high quality standards. The position supports financial systems, procurement, asset management, permitting and land use, collaboration platforms, GIS, and enterprise analytics. Work is performed under general managerial direction and has significant impact on City operations and digital transformation.

Essential Job Functions Lead full lifecycle development for enterprise applications from requirements through production and ongoing support. Design and implement AI solutions including generative AI agents, machine learning models, and MLOps pipelines to automate decisions, document processing, and citizen services. Develop and maintain RPA solutions to automate repetitive workflows across multiple departments including: finance, procurement, permitting, and HR.

Architect and operate data platforms including relational databases, data lakes, ETL/ELT pipelines, and real-time streaming for analytics and dashboards. Deliver enterprise SharePoint and Teams solutions for portals, collaboration, content and document management, forms, and automated workflows. Provide senior-level troubleshooting and production support for enterprise systems and integrations, coordinating incident response and vendor escalations.

Mentor and guide development teams on modern engineering practices, secure coding, CI/CD, observability, and performance tuning. Engage multiple department staff to translate complex business needs into scalable technical solutions and measurable outcomes. Application Development and AI Engineering Lead architecture and development of custom applications using modern frameworks and languages including .NET, Python, JavaScript, TypeScript, and SQL

Design and deploy AI services such as natural language processing for citizen interactions, document extraction and classification, predictive analytics, and anomaly detection. Implement MLOps and model governance including model training, validation, versioning, deployment, monitoring, and retraining pipelines. Build conversational agents and agentic AI workflows that integrate with municipal systems, knowledge bases, and citizen portals.

Create and maintain APIs and microservices for secure, scalable integrations with enterprise systems and third-party services. Data Platform, Analytics, and Dashboards Design and manage data lakes and warehouses using cloud or hybrid architectures to centralize structured and unstructured municipal data. Develop ETL and ELT pipelines using tools such as SQL Server Integration Services, Azure Data Factory, or equivalent technologies.

Author complex SQL and data transformations for reporting, analytics, and operational dashboards. Create interactive dashboards and BI solutions using Power BI, or similar tools to deliver actionable insights to leadership and operational teams. Implement data governance, security, and lineage to ensure data quality, privacy, and regulatory compliance.

Optimize database performance and scalability for OLTP and analytical workloads. Enterprise Systems Support and Integrations Provide senior support for finance, HR, procurement, permitting, GIS and other systems. Automate operational tasks with RPA tools to reduce manual effort and improve accuracy.

Manage integrations between enterprise platforms, middleware, and external services using API management, message queues, and event-driven architectures. Coordinate patching, release management, and change control to minimize production impact. Lead incident response and root cause analysis for major production issues and implement preventive measures.

Qualifications Bachelor's degree in Computer Science, Information Systems, or related field, and seven years of progressively responsible experience in software design and development, or equivalent combination of education and experience. Certifications such as Azure Data Engineer, Azure AI Engineer, AWS Certified Data Analytics, Certified RPA Developer, or relevant vendor certifications are a plus. Demonstrated experience leading senior development efforts and delivering enterprise-scale solutions.

Knowledge, Skills, and Abilities Technical Skills Advanced programming in .NET, Python, JavaScript, HTML5, and CSS. AI and ML experience including model development, deployment, and MLOps. RPA development experience with leading platforms

Strong SQL Server expertise and experience with data lakes, ETL/ELT, and data warehousing. Experience with BI and dashboards such as Power BI. API and microservices design and integration experience.

Cloud platform experience with Azure. SharePoint and Teams development for portals, workflows, and collaboration solutions. Familiarity with GIS integration and Esri ArcGIS is desirable.

Professional Skills Strong analytical and problem-solving skills. Excellent communication and stakeholder engagement abilities. Proven ability to lead projects, mentor engineers, and deliver on aggressive timelines.

Customer focus and commitment to public service.