高级 GIS 数据分析师（公用事业）
Senior GIS Data Analyst (Utilities)
职位描述：我们正在寻找一位高度积极的高级GIS数据分析师加入我们的水务资产管理部门，远程工作，主要支持东南地区在节水、资产管理及物联网领域的数据运营。理想的候选人将在收集、分析和解读来自多种来源的数据方面发挥关键作用，包括物联网传感器、GIS系统、公用事业资产注册表和客户平台。
该职位涉及开发可操作的见解，以优化流程、提高决策能力并增强运营效率。高级数据分析师将管理并分析大型数据集，维护Esri地理数据库中的公用事业资产数据，设计和实现数据可视化仪表板，并维护跨各种系统的集成。该职位还参与McKim & Creed数据平台的持续开发——与工程师和项目经理合作，完善分析、算法和报告工具，以推动我们的节水和智能资源管理使命。
在您的工作日中，您将：
数据质量保证与控制
- 对每日的计量器、SCADA和遥测数据流进行质量检查，确保一致性、准确性和完整性。
- 识别并解决差异或异常，以保持数据的完整性和可靠性。
GIS资产数据管理
- 在Esri地理数据库中维护和编辑公用事业资产数据——包括公用事业网络和其他供水/污水处理资产数据模型——确保属性、连接性和资产层级的准确性与最新性。
- 支持资产注册流程：竣工图和计划图纸的整合、属性填充、状况和重要性字段，以及与客户主系统（Cityworks、Maximo、Lucity、Cartegraph或类似系统）的核对。
- 运行并记录数据验证、拓扑和网络错误解决，以及版本化编辑流程；维护相关的数据字典和质量检查清单。
客户沟通与洞察交付
- 每日向客户提供事件通知、重大趋势识别和从数据分析中得出的可操作见解的更新。
- 建立强大的沟通渠道，促进协作和信任。
库存监控与管理
- 对所有项目地点进行日常库存检查，确保最低可部署的传感器库存水平得到维持。
- 与相关团队合作，处理库存问题。
查看英文原文
OVERVIEW: We are seeking a highly motivated Senior GIS Data Analyst to join our Water Asset Management team, remotely, in the Southeast, supporting data operations in the water conservation, asset management, and IoT sectors. The ideal candidate will play a critical role in collecting, analyzing, and interpreting data from a diverse range of sources, including IoT sensors, GIS systems, utility asset registries, and client platforms.
This position involves developing actionable insights to optimize processes, improve decision-making, and enhance operational efficiency. The Senior Data Analyst will manage and analyze large datasets, maintain utility asset data in Esri geodatabases, design and implement data visualization dashboards, and maintain integrations across various systems. This role also contributes to the ongoing development of McKim & Creed's data platform—collaborating with engineers and project managers to refine analytics, algorithms, and reporting tools that drive our mission of water conservation and smart resource management.
DURING YOUR WORK DAY, YOU WILL:
Data Quality Assurance and Control
- Conduct daily QA/QC of incoming meter, SCADA, and telemetry feeds to ensure consistency, accuracy, and completeness.
- Identify and resolve discrepancies or anomalies to maintain data integrity and reliability.
GIS Asset Data Management
- Maintain and edit utility asset data in Esri geodatabases — including Utility Network and other water/wastewater asset data models — keeping attribution, connectivity, and asset hierarchies accurate and current.
- Support asset registry workflows: as-built and plan-sheet incorporation, attribute population, condition and criticality fields, and reconciliation against client systems of record (Cityworks, Maximo, Lucity, Cartegraph, or similar).
- Run and document data validation, topology and network error resolution, and versioned editing workflows; maintain the supporting data dictionaries and QA checklists.
Client Communication and Insights Delivery
- Provide daily updates to clients regarding event notifications, significant trend identifications, and actionable insights derived from data analysis.
- Establish strong communication channels to foster collaboration and trust.
Inventory Monitoring and Management
- Perform daily inventory checks across all project locations, ensuring minimum field-deployable sensor inventory thresholds are maintained.
- Collaborate with relevant teams to address inventory shortages proactively.
Maintenance Coordination
- Maintain daily correspondence with maintenance staff to coordinate product allocations and schedule maintenance activities.
- Ensure timely interventions to minimize downtime and improve operational efficiency.
Client Relationship Management
- Conduct weekly client meetings to review reports, discuss project progress, and identify opportunities to expand or enhance service offerings.
- Build and sustain strong client relationships through consistent engagement and problem-solving.
WHAT YOU'LL NEED:
Technical Skills
- Python Programming: Proficiency in Python for data manipulation, analysis, and workflow automation (Pandas, NumPy, Matplotlib preferred).
- SQL & Database Management: Strong SQL skills for querying and managing large relational datasets; experience optimizing queries and ensuring data efficiency.
- Spatial Data Engineering: Experience designing and maintaining spatial data pipelines — ingesting, transforming, and publishing geospatial and time-series data across systems; spatial SQL (PostGIS or ArcSDE), coordinate systems and projections, and schema design for large multi-source datasets.
- AI-Assisted Development: Practical use of AI coding assistants and agentic tools (Claude, Copilot, or similar) to build internal applications, analysis tools, and automation — with sound judgment about where AI-generated output requires review, testing, and validation before it reaches a client deliverable.
- MCP & AI Integration: Familiarity with Model Context Protocol (MCP) and similar integration patterns for connecting AI tools to data sources, APIs, and internal systems; interest in building and maintaining connectors that make utility data accessible to AI-assisted workflows.
GIS Expertise
- ArcGIS Pro: Comfortable with spatial analysis, mapping, and basic geoprocessing for QA/QC and reporting workflows.
- Geodatabases & Utility Asset Data Models: Working knowledge of geodatabase structure — feature classes, domains, subtypes, and relationship classes — and familiarity with utility asset data models such as the Esri Utility Network or comparable water, sewer, and stormwater schemas.
- Asset Data Editing & Validation: Comfortable editing asset features, resolving validation and connectivity errors, and working within an established editing and QA process.
- Survey123 & Field Maps: Comfortable using deployed forms, validating field-collected data, and troubleshooting field-side issues.
- Operations Dashboard & Experience Builder: Comfortable navigating and interpreting client-facing dashboards and apps.
Qualifications:
- Bachelor's degree in Geography/GIS, Data Science, Computer Science, Engineering, or related field.
- 7–10 years of professional experience in data analysis, GIS, or IoT-related analytics.
- Hands-on exposure to the Esri Utility Network — you have worked inside a UN-based dataset (editing, validating, tracing, or analyzing), even if configuration and administration were handled by others. Deep configuration expertise is welcome but not required.
- Strong analytical and problem-solving skills with the ability to interpret complex data and deliver meaningful insights.
- Excellent written and verbal communication skills; comfortable engaging with clients and cross-functional teams.
- Highly organized, self-motivated, and able to manage multiple tasks in a remote environment.
- Valid driver's license and acceptable motor vehicle and criminal record.
WHAT WILL MAKE YOU STAND OUT:
- Direct utilities data experience — water, wastewater, or related utility sector.
- Deeper Utility Network work beyond day-to-day editing — asset package configuration, network rules, subnetwork and trace workflows, or migration from a geometric network.
- Experience integrating GIS with enterprise asset management or CMMS platforms (Cityworks, Maximo, Lucity, Cartegraph).
- Familiarity with asset management program fundamentals — condition assessment, criticality and risk scoring, renewal planning, and levels of service.
- ArcGIS Enterprise/Portal experience, including branch versioning, service publishing, and data migration from CAD or legacy systems.
- Background in non-revenue water (NRW) programs, leak detection workflows, or wastewater inflow/infiltration (I&I) work.
- Experience with data QA/QC workflows from field collection through delivery.
- Experience building API integrations to telemetry vendors (Ovarro, Trimble, Sentryx, Ayyeka, DataGate, etc.) or SCADA systems.
- Early exposure to Survey123 form authoring, Experience Builder, or ArcGIS API (Python or JavaScript) work.
- Familiarity with Grafana, Power BI, or similar dashboarding platforms for time-series and event visualization.
- Demonstrated examples of tools, scripts, or applications you built with AI assistance — and the ability to explain what you validated and how.
- Experience with cloud data platforms (Azure, AWS) and orchestrated pipelines for utility or sensor data at scale.
- Demonstrated ability to translate data into clear, actionable insights for clients.
WHAT WE OFFER: Join a company that puts its employees first.
Ranked as one of the Best Firms to Work For, here are just some of the reasons to become part of the McKim & Creed team:
- Employee Stock Ownership Plan (ESOP): All employees are owners & benefit from profits earned.
- Competitive pay: Paid holidays, bereavement, and parental, medical, and military leave.
- Multiple office locations to work from: Stick close to home or travel for a change of scenery.
- Growth opportunities & training: Grow confidently in your career with our mentoring & training options.
- Professional development: Tuition reimbursement, early career professional program, online courses & more.
- Work that makes a difference: See the direct impact your work has on our communities.
- Collaborative, supportive team: People to help you solve problems, cheer successes & encourage you along the way.
McKim & Creed is an Equal Opportunity and Affirmative Action Employer, and VEVRAA Federal Contractor and will consider all qualified applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status or disability status and maintains a Drug Free Workplace,
Originally posted on Himalayas