Python / Smartsheet Developer

Job Title: Python / Smartsheet Developer

Job Location: Danvers, MA | Onsite

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.

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:

• Python (intermediate+): pandas, database connectors, data processing scripts
• 2+ years Smartsheet: sheet building, cross-sheet formulas, dashboards, and automations
• 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 / Google Cloud Platform 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.

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 2,200 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.