Experis

Sr. Business SME2

โญ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Sr. Business SME2, a part-time ArcGIS Pro Business Analyst, on a 3+ month contract, 100% remote. Key skills include ArcGIS Pro expertise, SQL Server management, and virtual desktop administration.
๐ŸŒŽ - Country
United States
๐Ÿ’ฑ - Currency
$ USD
-
๐Ÿ’ฐ - Day rate
Unknown
-
๐Ÿ—“๏ธ - Date
October 8, 2025
๐Ÿ•’ - Duration
3 to 6 months
-
๐Ÿ๏ธ - Location
Remote
-
๐Ÿ“„ - Contract
Unknown
-
๐Ÿ”’ - Security
Unknown
-
๐Ÿ“ - Location detailed
Augusta, ME
-
๐Ÿง  - Skills detailed
#Azure #Statistics #Database Maintenance #"ETL (Extract #Transform #Load)" #Business Analysis #ODBC (Open Database Connectivity) #Security #SQL (Structured Query Language) #Server Administration #Scripting #Documentation #Monitoring #Consulting #SQL Server #Databases #Deployment #Python #Virtualization
Role description
ArcGIS Pro Business Analyst - MUST HAVE ArcGis Pro exp. 3+ month contract Work Location: 100% Remote. This will be an ad-hoc / part-time position. Hours will vary but all work will be done during normal business hours (Monday - Friday 8:00am - 5:00pm) Top 3 Skills ArcGIS Pro knowledge Virtual Desktop in Azure environment Business Workflow Analysis - ability to communicate with end users on their needs Skills Required for ArcGIS Pro Users in an Azure Environment with SQL Server ArcGIS and Geospatial Skills Deep ArcGIS Pro Knowledge: Proficiency in ArcGIS Pro's core functionalities, including data editing, spatial analysis, and advanced cartography, is essential to guide users effectively in their workflows. Ability to describe and guide users about best practices for using ArcGIS Pro interactions with ArcGIS Enterprise Portal applications and services. Enterprise Geodatabase (SQL Server): Expertise in managing enterprise geodatabases within SQL Server is crucial. โ€ข SQL Server Standard: Understanding how to create, manage, and secure a geodatabase, including user creation, permissions, and database maintenance tasks like compression and index rebuilding. โ€ข SQL Server Express: Awareness of the significant limitations of this edition, including the 10 GB maximum database size and hardware limits on CPU and RAM. Advising users on when to use it (for small-scale projects or testing) and when to upgrade to a licensed version is critical to avoid performance problems or service outages. Connection Management: Creating and managing secure .sde database connection files for users connecting to the SQL Server databases or SQL managed instances from their virtual desktop projects and/or the Enterprise Data Store is necessary. ArcPy Scripting: Proficiency with Python and the ArcPy library is necessary to automate geoprocessing tasks, particularly for data loading and management operations involving the SQL Server geodatabases. Virtual Desktop Administration Skills Virtual Desktops and Apps: Esri recommends a Virtual Desktop Infrastructure (VDI) approach for ArcGIS Pro for optimal performance, managing and optimizing both dedicated desktop and virtualized application deployments is essential. GPU Virtualization: As ArcGIS Pro is graphics-intensive and performs poorly without a dedicated GPU, expertise in configuring graphics delivery using technologies like NVIDIA vGPU within the virtual servers is required to ensure a responsive user experience. Performance Monitoring: Monitoring and troubleshooting performance issues within the Enterprise environment, particularly those that impact ArcGIS Pro workflows, is necessary. Issues can arise from resource contention on AVD servers, especially if graphics or CPU resources are not properly allocated. User Profile Management: Managing user profiles (e.g., using virtual Profile Management tools) is important for ensuring users' settings and customized tools are persistent across sessions on their virtual desktops. SQL Server Administration Skills Database Maintenance: Performing regular maintenance on the SQL Server databases, such as updating statistics and rebuilding indexes, is crucial to prevent performance degradation. For SQL Server Standard, leveraging the built-in SQL Server Agent for a utomated tasks is beneficial. SQL Server Express Limitations: Proficiency in managing the constraints of SQL Express is important. This includes monitoring database size to prevent reaching the 10 GB limit and understanding that features like the SQL Server Agent are unavailable for automated maintenance. Security Management: Knowledge of the correct methods to manage SQL Server security is needed to work with the team that manages the profile information of authenticated database users and roles, ensuring appropriate permissions are granted to GIS users. Connectivity and Drivers: Knowledge of installing and configuring the correct SQL Server ODBC drivers on the virtual desktops is essential for establishing stable database connections. Consulting and Troubleshooting Skills Business Workflow Analysis: You must listen to users' needs and design appropriate workflows that account for the different capabilities and limitations of SQL Server Express vs. Standard. This involves advising users on whether their project data should reside in one database or the other. End-to-End Troubleshooting: Diagnosing and resolving issues that span the entire stack, from the virtual desktop application to the underlying SQL Server geodatabase, is essential. Training and Documentation: Providing training and creating documentation outlining best practices and limitations, particularly for users of SQL Server Express, is crucial for successful user adoption and preventing data loss or performance issues. If this is a role that interests you and youโ€™d like to learn more, click apply now and a recruiter will be in touch with you to discuss this great opportunity. We look forward to speaking with you! About ManpowerGroup, Parent Company of:Manpower, Experis, Talent Solutions, and Jefferson Wells ManpowerGroupยฎ (NYSE: MAN), the leading global workforce solutions company, helps organizations transform in a fast-changing world of work by sourcing, assessing, developing, and managing the talent that enables them to win. We develop innovative solutions for hundreds of thousands of organizations every year, providing them with skilled talent while finding meaningful, sustainable employment for millions of people across a wide range of industries and skills. Our expert family of brands โ€“ Manpower, Experis, Talent Solutions, and Jefferson Wells โ€“ creates substantial value for candidates and clients across more than 75 countries and territories and has done so for over 70 years. We are recognized consistently for our diversity - as a best place to work for Women, Inclusion, Equality and Disability and in 2022 ManpowerGroup was named one of the World's Most Ethical Companies for the 13th year - all confirming our position as the brand of choice for in-demand talent.