Senior Data Analyst
Senior
Analytics
Arcpy
Azure Data Services
Business Analytics
Business Intelligence
Data Analysis
Data Analytics
Data Architecture
Data Integration
Data Pipeline
Data Platform
Data Visualization
Geographic Information System
GIS
Microsoft Power Platform
Power BI
Power Platform
Reporting and Analytics
Snowflake
Spatial Analysis
SQL
Job Description
Senior Data Analyst (Gas Engineering) is a hybrid role based in Waltham, MA, focused on advancing data management maturity, analytics capabilities, GIS utilization, and technology enablement across Gas Asset Management & Engineering (GAME).
Responsibilities
- Drive improved utilization of connected data across Snowflake, GIS, Enterprise Maximo, risk model platforms, reporting environments, and related systems.
- Define business and analytical requirements for data integration, interoperability, pipelines, interfaces, and reusable data models.
- Identify data silos, reconciliation points, and manual handoffs; partner with IT and data engineering teams to implement sustainable improvements.
- Promote end-to-end traceability from source data through analytical outputs and business decisions.
- Expand GIS usage from mapping and visualization to spatial analysis, workflow enablement, asset intelligence, and decision support.
- Develop geospatial analytics supporting asset management, risk models, leak management, integrity activities, regulatory needs, and capital planning.
- Improve GIS data quality and usability, including attribution, connectivity, topology, and location accuracy, in partnership with data owners and GIS teams.
- Design reusable GIS-enabled tools, maps, dashboards, analyses, and automation to improve engineering and operational workflows.
- Identify opportunities where coding, automation, integration, low-code tools, or emerging technology can remove non-value-added work and improve control effectiveness.
- Design, code, test, document, deploy, and maintain reusable scripts, applications, workflows, and analytical tools using approved technologies.
- Automate data extraction, transformation, validation, quality checks, GIS analysis, reporting, and repeatable business processes.
- Develop proofs of concept and pilots, defining value, controls, support needs, and transition paths for scalable solutions.
- Use sound development practices, including modular design, version control, testing, documentation, monitoring, and knowledge transfer.
- Build advanced analysis, dashboards, KPIs, and executive scorecards supporting asset, risk, investment, compliance, and operational decisions.
- Perform data profiling, root-cause analysis, trend analysis, and scenario analysis to identify risks and improvement opportunities.
- Create repeatable analytical processes and self-service capabilities to improve consistency, speed, and transparency.
- Translate complex data into clear findings, recommendations, and decision-ready stories.
- Engage stakeholders to define business outcomes, requirements, priorities, success measures, and sustainment needs.
- Communicate analytical findings, data risks, solution options, and technology opportunities to technical and non-technical audiences.
- Develop business cases, roadmaps, recommendations, and implementation plans for leadership consideration.
- Act as a trusted advisor connecting business, data, GIS, and technology communities.
Requirements
- Bachelor’s degree in Engineering, Computer Science, Data Analytics, Information Systems, Statistics, Mathematics, GIS, or a related field.
- Minimum 3+ years of experience in analytics, business intelligence, data strategy, engineering analytics, GIS, automation, or a related discipline.
- Proven experience delivering analytics, reporting, coded solutions, automation, or technology-enabled business improvements.
- Experience working with enterprise data platforms, complex datasets, and cross-functional stakeholders.
- Experience leading workstreams, projects, requirements development, or continuous improvement initiatives.
- Skills and experience with SQL; Power BI; Snowflake; advanced Excel; data modeling; data governance; data quality management.
- Experience with Python; scripting; APIs and web services; Git/version control; Power Apps; Power Automate.
- Experience with ArcGIS Pro; ArcGIS Enterprise; ArcPy; spatial analytics; Enterprise Maximo; utility asset data.
- Knowledge of ETL/ELT concepts; data pipelines; system interoperability; Azure data services.
- Experience with AI and generative AI applications, machine learning fundamentals, intelligent document extraction, and risk analytics platforms such as Synergi (or equivalent).
Technologies
- Snowflake
- GIS
- Enterprise Maximo
- SQL
- Power BI
- Excel
- Python
- APIs and web services
- Git/version control
- Power Apps
- Power Automate
- ArcGIS Pro
- ArcGIS Enterprise
- ArcPy
- Spatial analytics
- ETL/ELT
- Azure data services
- AI and generative AI
- Machine learning
- Intelligent document extraction
- Synergi
Compensation
- $111,000 - $130,000 per year
Location: Waltham, MA (hybrid)