Smartsheet DeveloperAnalyst

Job Title :: SmartsheetDeveloper/Analyst
Job Location :: Danvers MA Onsite/ Full remote

Description:
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

• 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
Bachelors 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 doesnt 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.


About AgreeYa
AgreeYa is a global systems integrator delivering competitive advantage for its customers through software solutions and services. Established in 1999 AgreeYa is headquartered in Folsom California with a global footprint and a team of more than 2200 staff across offices. AgreeYa works with 500 organizations ranging from Fortune 100 firms to small and large businesses across industries such as Telecom Banking Financial Services & Insurance Healthcare Utility & Energy Technology Public sector Pharma & Biotech and others. Please visit us at for more information. AgreeYa is an equal opportunity employer. We evaluate qualified applicants without regard to race color religion gender identity sexual orientation national origin disability veteran status or other protected characteristics. Visit our website to learn about our Career & Culture.