[Remote] Software Application Developer/Analyst - II

Note: The job is a remote job and is open to candidates in USA. Alpha Consulting Corp. is hiring a Software Application Developer/Analyst - II to support network infrastructure planning and reporting. The role focuses on querying enterprise databases, building data pipelines and interactive web-based reports, maintaining Smartsheet workflows, and documenting business processes.

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

Skills

• Targeted Years of Experience: 3–5 years
• 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 Proces alyst / Python Developer — Contracts documentation: 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
• Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field — or equivalent work experience
• 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.)
• Smartsheet certification a plus

Company Overview

Alpha Consulting Corp. has been exceeding expectations in the IT, pharmaceutical, and clinical staffing business since 1994. It was founded in 1994, and is headquartered in East Brunswick, New Jersey, USA, with a workforce of 201-500 employees. Its website is http://alphaconsulting.com.

Company H1B Sponsorship

Alpha Consulting Corp. has a track record of offering H1B sponsorships, with 2 in 2025, 4 in 2024, 3 in 2023, 4 in 2021, 6 in 2020. Please note that this does not guarantee sponsorship for this specific role.