Sign upLog in

Software Developer

Tellus Solutions

Santa Rosa, CA

Apply
JOB DETAILS
SKILLS
Acceptance Testing, Agile Programming Methodologies, Analysis Skills, Artificial Intelligence (AI), Automation, Backlog Prioritization, Business Processes, Business Skills, Business Solutions, Communication Skills, Computer Engineering, Computer Science, Cross-Functional, Data Collection, Data Entry, Data Processing, Data Quality, Data Structures, Functional Testing, GitHub, Identify Issues, Information Technology & Information Systems, Internet Application, Interpersonal Skills, JSON, JavaScript, Microsoft Excel, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Visual Basic, Microsoft Visual Basic for Applications (VBA), Microsoft Visual Studio, Object Oriented Development, Object Oriented Programming (OOP), Problem Solving Skills, Product Demonstration, Production Systems, Programming Tools, Python Programming/Scripting Language, React.js, Relational Databases (RDBMS), Requirements Management, Requirements Validation/Verification, Root Cause Analysis, SQL (Structured Query Language), Scripting (Scripting Languages), Scrum Project Management and Software Development, Software Development, Sprint Planning, Team Player, Test Automation, Test Plan/Schedule, Usability Engineering, User Interface/Experience (UI/UX), Web Application Framework, Web Programming
LOCATION
Santa Rosa, CA
POSTED
1 day ago
Job Description:
Data Collection Tool Developer
We are seeking a contract developer to design, build, and support a data collection solution that will begin as an Excel-based tool and later transition to a scalable web application. The initial phase focuses on Excel "Smart Forms” that pull data from Microsoft SQL Server and use macros, VBA, validations, and business rules to guide accurate data entry. The long-term goal is a dynamic, user-friendly web application that improves usability, data quality, maintainability, and process efficiency.

Primary Responsibilities

  • Develop and maintain Excel-based data collection forms integrated with Microsoft SQL Server.
  • Create macros, VBA scripts, formulas, validations, and guided workflows to improve data accuracy.
  • Translate business requirements into rules, dependencies, constraints, mandatory fields, and exclusion logic.
  • Design forms that display only relevant fields, selections, and instructions based on business logic.
  • Collaborate with stakeholders to gather requirements, validate functionality, and support adoption.
  • Support planning for the future web application, including requirements, data structure, workflow, and user experience.
  • Document functionality, assumptions, requirements, test cases, and support procedures.

Required Technical Experience

  • Advanced Microsoft Excel skills, including formulas, data validation, structured templates, and macro-enabled workbooks.
  • Hands-on experience with VBA, Visual Basic, or similar scripting languages for Excel automation.
  • Experience connecting Excel or business applications to Microsoft SQL Server or relational databases.
  • Familiarity with SQL or T-SQL for troubleshooting, reporting, validation, and analysis.
  • Ability to implement business rules, dependencies, constraints, mandatory fields, and exclusion logic.
  • JavaScript, TypeScript, JSON, YAML, and Python experience are preferred for future development, automation, and testing.

Testing, Quality, and Deployment

  • Develop and execute unit, scenario-based, regression, and user acceptance testing.
  • Troubleshoot data, macro, rule logic, and workflow issues; identify root causes and resolve defects.
  • Promote changes through development, test, and production environments.
  • Follow Agile Scrum practices, including backlog refinement, sprint planning, demos, and iterative delivery.
  • Ensure solutions are maintainable, documented, and aligned with business requirements.
Skills:

Soft Skills & Role Expectations

  • Strong communication, collaboration, and interpersonal skills.
  • Ability to clarify ambiguous requirements and translate them into practical technical solutions.
  • Ability to explain technical trade-offs to technical and non-technical stakeholders.
  • Strong analytical, diagnostic, and problem-solving abilities.
  • Comfortable working independently as a contractor while staying aligned with priorities, timelines, and stakeholder expectations.
  • Ability to work effectively with cross-functional teams across geographies.

Preferred Tools and Technologies

  • Microsoft Excel, VBA, Visual Basic, JavaScript, TypeScript, SQL, T-SQL, SQL Server, and relational databases.
  • Visual Studio or similar development environments; Angular, React, or similar web frameworks.
  • Confluence, Jira, Bitbucket, Power BI, Report Builder, and Microsoft 365 applications.
  • AI-assisted development tools such as ChatGPT, GitHub Copilot, or Claude Code.

Education:

Qualifications

  • Bachelor's degree in Computer Engineering, Computer Science, Information Systems, or equivalent experience.
  • Experience developing Excel-based tools, macro-enabled workbooks, or business process automation solutions.
  • Experience with web application development and object-oriented programming preferred.
  • Experience developing user-friendly tools that collect, validate, and process business data.

About the Company

T

Tellus Solutions

Resume Resources

Free Resume TemplatesFree Resume Builder