Job Title :: Smartsheet Developer/AnalystJob Location :: Danvers, MA - Onsite/ Full remoteDescription:AgreeYa is a global Systems Integrator and is seeking an experienced
Software Application Developer/Analyst with strong experience querying large enterprise databases, building data pipelines, producing interactive web-based reports, maintaining, and advancing Smartsheet workflows, and documenting business processes.
Overview We are looking for a Software Application Developer/Analyst to support network infrastructure planning and reporting.
The role involves querying large enterprise databases, building data pipelines, producing interactive web-based reports, maintaining and advancing Smartsheet workflows, and documenting business processes.
You will work alongside a small team and an AI assistant (Claude) to accelerate delivery.
Responsibilities Write and maintain
Python scripts for data extraction, transformation, and matching across multiple enterprise data sources Query Oracle, Teradata, and Google BigQuery databases to pull, reconcile, and validate large datasets Build and maintain interactive HTML reports and internal web tools (Flask-based) with sortable/filterable tables
Develop and maintain Smartsheet sheets, dashboards, automations, and cross-sheet formulas Design and document business process flows
- intake-to-delivery workflows, data lineage diagrams, and decision trees using tools such as Visio, Lucidchart, or equivalent Support ad-hoc data investigations
- identify mismatches, gaps, and anomalies across systems
Must-Have Skills:- - 2+ years Smartsheet: sheet building, cross-sheet formulas, dashboards, and automations
- Python (intermediate+): pandas, database connectors, data processing scripts
- 2+ years SQL (intermediate+): comfortable across Oracle, Teradata, or BigQuery; understands joins, aggregations, NULL handling
- 3+ years Process analyst / Python Developer - ability to translate complex multi-system workflows into clear process flow diagrams and written procedures
- 2+ years HTML/JavaScript: able to read, edit, and extend existing report templates (DataTables, basic JS)
- 2+ years Creative problem solving able to take an ambiguous business question and propose a practical, well-designed solution not just execute instructions
Desired Skills - Familiarity with BPMN or structured process notation
- Experience with large-scale enterprise data (telecom, utilities, logistics, or similar) Google BigQuery / GCP familiarity
- Experience working alongside AI coding tools (GitHub Copilot, Claude, etc.)
Education & Certifications Bachelor's degree in computer science, Information Systems, Data Analytics, or related field
- or equivalent work experience Smartsheet certification a plus
What Success Looks Like -
You can take a vague data question, find the right tables, write a clean query, and deliver a working report
- and when a process is unclear or undocumented, you can map it out, so the next person doesn't have to figure it out from scratch.
You bring both technical rigor and a creative eye: your deliverables are clear, well-structured, and look like someone thought about the audience.
