Note: The job is a remote job and is open to candidates in USA. PTR Global is a provider of information technology and workforce solutions. The Software Application Developer/Analyst will support network infrastructure planning and reporting by querying enterprise databases, building data pipelines, creating interactive web reports, maintaining Smartsheet workflows, and documenting business processes. The role also involves investigating data discrepancies and delivering user-friendly technical solutions for business stakeholders.
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, including intake-to-delivery workflows, data lineage diagrams, and decision trees using tools such as Visio, Lucidchart, or equivalent
- Support ad-hoc data investigations by identifying mismatches, gaps, and anomalies across systems
Skills
- Intermediate+ Python skills, including experience with pandas, database connectors, and data processing scripts (2+ years)
- Proficiency in Smartsheet, including sheet building, cross-sheet formulas, dashboards, and automations (2+ years)
- Intermediate+ SQL skills, with experience in Oracle, Teradata, or BigQuery; understanding of joins, aggregations, and NULL handling (3+ years)
- Ability to document processes, translating complex multi-system workflows into clear process flow diagrams and written procedures (2+ years)
- Experience with HTML/JavaScript, including reading, editing, and extending existing report templates (DataTables, basic JS) (2+ years)
- Creative problem-solving skills, with the ability to propose practical, well-designed solutions to ambiguous business questions
- Familiarity with BPMN or structured process notation
- Experience with large-scale enterprise data in industries such as telecom, utilities, or logistics
- Google BigQuery / GCP familiarity
- Experience working alongside AI coding tools (e.g., GitHub Copilot, Claude)
- Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field, or equivalent work experience
- Experience with large-scale enterprise data in industries such as telecom, utilities, or logistics
- Google BigQuery / GCP familiarity
- Experience working alongside AI coding tools (e.g., GitHub Copilot, Claude)
- Smartsheet certification is a plus
Benefits
- Medical benefits
- Dental benefits
- Vision benefits
- 401K contributions
- PTO
- Sick leave
- Other benefits mandated by applicable state or localities where you reside or work
- Fully remote EST
- W2 employment
Company Overview