Senior GIS Data Analyst (Utilities)

<p><strong>OVERVIEW</strong>: We are seeking a Senior GIS Data Analyst to join our Water Asset Management team and own the GIS application-development side of the practice. While our analyst-level team handles data operations, QA/QC, and client reporting, the Senior role takes the lead on building the tools that make that work scalable — designing Survey123 collection forms from scratch, developing Operations Dashboards and Experience Builder apps for client-facing visualization, and writing custom integrations against the ArcGIS API for Python and JavaScript.</p> <p>This is the role where engineering-grade GIS development meets utility data delivery: senior hires drive how M&C ships its analytics products, mentor the analysts who consume them, and contribute the modern AI integrations that are becoming part of every utility data stack.</p> <p><strong>DURING YOUR WORK DAY, YOU WILL:</strong><br><strong>Application Development</strong><br>• Design, build, and deploy Survey123 collection forms aligned to utility field workflows.<br>• Develop Operations Dashboards and Experience Builder apps that translate raw sensor and meter data into actionable client-facing tools.<br>• Build and maintain custom integrations against the ArcGIS API for Python and JavaScript, including AI/ML-enabled workflows where they earn their place.</p> <p><strong>Solution Design</strong><br>• Architect end-to-end data + GIS solutions for utility clients — from field collection through dashboard delivery — balancing Esri-native tools with custom Python/SQL plumbing.<br>• Define data models, schemas, and integration patterns that the analyst team can pick up and operate.</p> <p><strong>Technical Leadership</strong><br>• Set the technical bar for the WAM team’s GIS development output — code review, pattern reuse, documentation standards.<br>• Triage and resolve the high-complexity issues that the analyst team escalates.</p> <p><strong>Client Engagement</strong><br>• Lead technical conversations with utility clients during scoping, demos, and implementation reviews.<br>• Translate utility-side requirements into the application architecture that delivers them.</p> <p><strong>Mentorship</strong><br>• Pair with analyst-level team members to accelerate their growth into form authoring, Experience Builder development, and API work.<br>• Maintain a culture where the team’s collective skill ceiling rises over time.</p> <p><strong> </strong><strong>WHAT YOU’LL NEED:</strong><br><strong>Technical Skills</strong><br>• Python Programming: Production-grade Python — modular, tested, automated workflows for data ingestion, transformation, and analysis (Pandas, SQLAlchemy, HTTP libraries, Matplotlib / Plotly).<br>• SQL & Database Management: Advanced SQL — schema design, query optimization, indexing strategy, and integration with operational data stores.<br><strong></strong></p> <p><strong>GIS Development:</strong><br>ArcGIS Pro: Advanced spatial analysis, custom geoprocessing tools, ModelBuilder, ArcPy scripting.<br>Survey123: Design and deploy custom field collection forms — conditional logic, dynamic content, integration with downstream systems.<br>Experience Builder & Operations Dashboards: Develop client-facing apps from scratch — data widget configuration, custom theming, embedded analytics.<br>ArcGIS API for Python & JavaScript: Build custom integrations, automation scripts, and web applications that extend the Esri platform.<br>AI / Modern Integrations: Experience connecting LLMs, ML services, or other modern tooling into Esri workflows (or strong interest in doing so).</p> <ul> <li>Bachelor’s degree in Geography/GIS, Data Science, Computer Science, Engineering, or related field.<br>• 5–7+ years of professional experience in GIS development, data engineering, or utility analytics — at least 3 of those in a hands-on GIS development role.<br>• Demonstrated portfolio of deployed Survey123 forms, Experience Builder apps, or ArcGIS API integrations (work-sample request likely at interview).<br>• Strong analytical and problem-solving skills with the ability to interpret complex data and deliver meaningful insights.<br>• Excellent written and verbal communication skills; comfortable engaging with clients and cross-functional teams.<br>• Highly organized, self-motivated, and able to manage multiple tasks in a remote environment.<br>• Valid driver’s license and acceptable motor vehicle and criminal record.</li> </ul> <p><strong>WHAT WILL MAKE YOU STAND OUT:</strong><br>• Direct utilities data experience — water, wastewater, or related utility sector.<br>• Background in non-revenue water (NRW) programs, leak detection workflows, or wastewater inflow/infiltration (I&I) work.<br>• Experience integrating telemetry vendors (Ovarro, Trimble, Sentryx, Ayyeka, DataGate, etc.) or SCADA systems into Esri / GIS workflows.<br>• Hands-on experience with AI-augmented GIS workflows — LLM-driven data classification, computer vision for asset inspection, ML for anomaly detection.<br>• Track record mentoring junior analysts into GIS development competence.<br>• Familiarity with Grafana, Power BI, or similar dashboarding platforms alongside the Esri stack.<br>• Demonstrated ability to translate utility-side operational requirements into delivered GIS applications.</p> <p><strong>WHAT WE OFFER: </strong>Join a company that puts its employees first.<br>Ranked as one of the <a href="https://www.mckimcreed.com/news-and-insights/mckim-creed-named-2024-best-firm-to-work-for/" target="_blank" rel="noopener">Best Firms to Work For</a>, here are just some of the reasons to become part of the McKim & Creed team:</p> <ul> <li><strong>Employee Stock Ownership Plan (ESOP):</strong> All employees are owners & benefit from profits earned.</li> <li><strong>Competitive pay</strong>: Paid holidays, bereavement, and parental, medical, and military leave.</li> <li><strong>Multiple office locations to work from:</strong> Stick close to home or travel for a change of scenery.</li> <li><strong>Growth opportunities & training: </strong>Grow confidently in your career with our mentoring & training options.</li> <li><strong>Professional development:</strong> Tuition reimbursement, early career professional program, online courses & more.</li> <li><strong>Work that makes a difference:</strong> See the direct impact your work has on our communities.</li> <li><strong>Collaborative, supportive team:</strong> People to help you solve problems, cheer successes & encourage you along the way.</li> </ul> <p><em>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.</em></p> <p>#LI-DNI</p> <p> </p>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...