Enterprise Automation Developer

Westwood Professional Services is looking for an Enterprise Automation Developer to design, build, and support the custom automation that keeps our business systems running.  This role sits on the Enterprise Applications team and is hands-on: you'll write T-SQL against our ERP database, develop RPA workflows in UiPath, build .NET applications and services, script in PowerShell, build AI-assisted workflows and own the day-to-day support of the automations you and the team put into production.

This is a development role with a real operations component. Your time splits roughly evenly across three areas: developing new automation and integration work, supporting the automations already in production, and broader systems work; upgrades, acquisition onboarding, and process improvement alongside business stakeholders.

Key Responsibilities

Automation Development (40%)

• Design and build custom automation solutions using UiPath, .NET, PowerShell, and T-SQL against Deltek Vantagepoint and related business systems.
• Develop stored procedures, triggers, and SQL frameworks following team standards, including preview-first execution, explicit transaction handling, and consistent naming conventions.
• Build, deploy, and maintain UiPath automations for processes where RPA is the appropriate solution, including UI-driven workflows, application interaction, and scheduled unattended jobs.
• Develop and maintain integrations between systems, including ERP, HRIS, and payroll systems, using REST APIs, scheduled jobs, and file-based processes.
• Develop PowerShell automations for job orchestration, file movement, unattended scheduled tasks, REST API calls, and server-side processes. PowerShell scripts should be developed and maintained as production code using the same standards applied to C# and SQL development.
• Instrument applications with telemetry and logging so issues can be identified and addressed before they impact users.

Production Support (30%)

• Provide day-to-day support for automations in production, including monitoring scheduled jobs and UiPath bots, investigating failures, and resolving data issues.
• Triage and respond to support tickets related to automation and integration issues.
• Identify issues at the database level by analyzing read replicas and queries prior to modifying the production environment.
• Document automations, runbooks, and troubleshooting procedures so production support does not depend on tribal knowledge.

Collaboration, Upgrades & Improvement (30%)

• Support upgrades of core business systems, including ERP version upgrades, integration and platform updates, regression testing of customizations, validation of stored procedures, reports, and integrations following upgrades, and remediation of issues that arise.
• Work directly with accounting, HR, and operations stakeholders to identify manual processes that may benefit from automation.
• Recommend the appropriate technology for each automation request, including native ERP functionality, T-SQL, custom .NET development, UiPath, or AI-assisted solutions, and explain the tradeoffs between approaches.
• Contribute to team development standards, code reviews, and shared libraries.
• Assist with acquisition onboarding as needed, including extracting and migrating data from acquired firms’ legacy accounting and project systems into Vantagepoint.

Required Qualifications

• 3+ years of experience developing and maintaining automations in UiPath, including Studio, Orchestrator, and attended or unattended robots, or experience with a comparable RPA platform with willingness to work in UiPath.
• 3+ years of professional development experience with .NET and T-SQL.
• Strong SQL Server skills, including stored procedures, triggers, transaction handling, and performance analysis.
• Strong PowerShell scripting skills, including functions and modules, error handling, REST API calls, file and process automation, and unattended or scheduled execution.
• Experience building and consuming REST APIs.
• Experience supporting production systems, including debugging live issues, reading logs, and working incidents through resolution.
• Ability to work directly with non-technical business stakeholders and translate process problems into effective technical solutions.

Preferred Qualifications

• Professional experience with UiPath, including Document Understanding and API-based automation.
• Strong T-SQL and .NET development experience.
• Experience with Deltek Vantagepoint or another project-based ERP, such as Deltek Vision, Unanet, or BST.
• Experience with data migration or ETL, including extracting, staging, and loading data.
• Experience working with LLM APIs such as Anthropic Claude or OpenAI, including prompt design, structured outputs, and document intelligence workflows. 

About Westwood Professional Services, Inc. (Westwood)

At Westwood, our purpose is to create a better world for people through our work. We transform the energy grid, design resilient infrastructure, and develop communities that will flourish today and for future generations. With over 50 years of experience and a legacy of innovation, we stand at the forefront of our industry, dedicated to understanding the unique needs of the markets we serve.

Our approach revolves around people. We are committed to building a culture that attracts, retains, and develops high performers. Our team values relationships, innovation, dedication, initiative, and growth. We believe fostering a collaborative “One Team” mentality yields superior outcomes in everything we do.

We customize our technical capabilities and geographic reach to meet our clients where they are and help them realize their vision. We are partners in our clients’ success, driving to provide solutions that make a lasting difference. Safety, sustainability, and operational excellence are not just facets of our work; they are intrinsic to our identity, guiding every decision we make.

We are deeply invested in the communities we serve. Through our projects and giving-back initiatives, we enrich the lives of those we serve, engage others within our industry, and create a lasting impact on communities around the world. To us, success transcends the completion of projects; it is reflected in the lives we have positively impacted by our work.

Join us in creating a better world.

In 2025, Westwood was recognized as #77 on the ENR Top 500 Design Firms. Additionally, Westwood was ranked #5 for ENR's Top Design Firm for Solar, #6 for Battery Storage, and #3 for Wind (2025). The firm consistently ranks on the industry's top 25 lists and receives recognition for its involvement in award-winning projects nationwide.

Westwood provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. We believe that diverse backgrounds strengthen our business. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.